CManoj's Q&A profile

• SQL Server Problems Creating Report

  Hi, I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report. What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters. I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column. Can anyone offer any suggestions Dave Ok, I manage ...Show All

• SQL Server Leeson 8

  I went over lesson 8 of sql express resourses with no problem, but when I copy it to online I get problem. Meaning it failed to add IP address to my database. Any help, please. My server is confiqured to accept asp files. Thanks Lesson 8: Connecting your Web Application to SQL Server 2005 Express Edition Lesson Hi Bonni, I'm guessing you're talking about the lessons on LearnVisualStuio.Net, these are not produced by Microsoft. I'd suggest that you ask this question on the forums at http://www.asp.net , which are focused on VWD and web development. I know the folks at LearnVisualStudio.net also have forums to help people with the lessons, but the forums require a paid membership. Mike ...Show All

• SQL Server Displaying an database image in SSRS Report page header

  How to display an database image in the Report page header of sql server reporting service It can be done with the help of matrix.For eg: A report named Report1.rdl is the report to which header image has to be placed.Create a report named MainReport.rdl and in that Add a matrix.In the Row grouping give the grouping field name.For eg: Report is designed to display details of particular invoice no.give that in group on condition (Fields!Invoiceno.value) When Matrix is draged rows ,column and data text is displayed in that then in rows column place the expression =Convert.ToBase64String(First(Fields!companylogo.Value, "DataSet2" )) In data column drag a subreport which points to Report1.rdl. place ...Show All

• SQL Server SSIS package execution

  Hi all, I am Hazara. I am trying to call a SSIS package from a web service. But package.execute() method is returning 'failure'. Though I am able to execute the same package from a normal .Net project and it is working fine (using the same code that i have used in web service). I have also tried to execute it through stored procedure for which firstly I created a .dll in c#(which is perfectly working) and then I registered this .dll in sqlserver-2005 using following command. CREATE ASSEMBLY asmPackageExecuter FROM 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\PackageExecuter.dll' WITH PERMISSION_SET = UNSAFE GO Now on calling the method of .dll (which is responsible to execute the package) I am getting the DTS ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Need a practical walkthrough for XNA

  Hi. Does anyone know where I can find a practical and step by step walkthrough for XNA to create a simple 3D box(cube) I'd be happy if you could also lead me to the source of MS walkthroughs for XNA. The documentation for XNA itself does provide a walkthrough for this purpose, but it seems buggy. I need a fresh one! This is the first Beta, most people have been dealing with this framework for less than a week. There might be a tutorial that simple out right now, but I haven't seen it yet. So you might have to wait a few more weeks for more people to get their feet wet and explore it a bit more. ...Show All

• Visual Studio 2008 (Pre-release) What's the replacement for GetTable() in DataContext?

  A question regarding LINQ to SQL in the January Orcas CTP. DataContext.GetTable is now internal - what method should we use instead For now I'm calling GetTable via reflection which works fine but is a bit messy. I notice a number of LINQ to SQL bugs have been fixed which is great. Thanks Joe There are actually several overloads to GetTable, and some must remain public (GetTable(type), GetTable<TEntity>()) for use in data contexts. What does your data context look like, which works under the Jan bits Our unittests are using, for example: public System.Data.Linq. Table < Category > Categories { get { return this .GetTable< Category >(); // this wouldn't compile if GetTable<TEntity>() were int ...Show All

• Visual Studio 2008 (Pre-release) Getting Real Client IP Address in Service

  I am posting this question again because I have look through the previous post regarding this question but I still have not found an answer that I needed. In most previous post, the solution described as always been making client add their own IP in OutgoingMessageHeaders. But I feel this is not really a good way, someone can masquerade as another client by just putting a fake IP address in the header. Is there a way to obtain the real IP address of the client as appeared on the IP packets received by the service I know that this might be spoofed but at least it is a little better much harder that just relying on the client to tell its IP address. Thanks! Thanks! I am aware of those limitations. Looks li ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Grid using triangle strip?

  Hello, sorry if this is a stupid question, but I was wondering is it possible to draw grid of triangles using triangle strip instead of triangle list I guess you can do this by turning culling mode off, but I was wondering is it possible to do with culling on Thanks, ErnisJ thanks guys! I think for now I will use triangle lists and later on if there will be real need I'll try triangle strip as well. ...Show All

• SQL Server DTS migration wizard, where does it put migrated version?

  From SQL Server Management Studio I right click on Management/Legacy/DTS and select Migration Wizard and enter a SQL Server Source and Destination. A list of DTS packages from the source server is displayed and I select one of the DTS packages and give the destination a unique name. The wizard runs and says it's successful. I can't find the new SSIS version of the DTS package with the new name that I've given it, however. Where does it put the new migrated copy of the DTS package. Thanks, John ...Show All

• Software Development for Windows Vista How do i implement this workflow ?

  Hi All, I am trying to make a simple workflow that has 4 parallel activities each getting input from different users (say it takes interger as it's input) and then adds the inputs (integer values). I was thinking of creating a custom activity that takes input from the user and run 4 instances of it parallely so i will get 4 different inputs and then at the end of the parallel activity i have a cusum activity that adds the 4 input. Is this the right approach. Do parallel activities end seperately and can't be merged into another activity Or if they could then in my case how do i send data from the parallel activities into the activity that does addition. Thanks, Sonali Hi Tom, When you say ha ...Show All

• Visual Studio Team System TFS errors after enabling SP1 ISAPI filter

  I'm trying to get this SP1 ISAPI filter working, but when I enable it I have connection problems with the TFS. I can still connect, but can't see work items or source control. I have the ISAPI filter configured like this: [config] RequireSecurePort=true ProxyIPList=192.168.1.1; There is an event log entry that says it has started correctly with that configuration. Here are the event log messages that start showing up when I try to connect with the ISAPI filter installed: Detailed Message: TF53002: Unable to obtain registration data for application VersionControl. Web Request Details Url: https://tfs.domain.net/VersionControl/v1.0/repository.asmx [method: POST] User Agent: Team Foundation (devenv.exe, 8.0.50727.147) Heade ...Show All

• Windows Forms SerializationException "Cannot get the member 'Child_PropertyChanged'." when de-serializing generic collection

  I have created a custom generic collection class with a signature like so: [ Serializable ] public class blGenericCollection <T> : BindingList <T>, ITypedList , IListSource , IXmlSerializable where T : blObjectBase , new () {blah blah blah} The child items that derive from my blObjectBase publicly implement INotifyPropertyChanged , as does blObjectBase itself. I'm getting SerializationException errrors when de-serializing the collection class (stack trace below) using BinaryFormatter . However, the child item classes serialize and de-serialize just fine, as does my blGenericCollection class when it is empty. But when blGenericCollection contains items - I blow up. (Side note: Xml serialization fo ...Show All

• SQL Server OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Code works on one machine but not on another

  I have written a breakout game which plays brilliantly on my main pc at home. But when i loaded the source recompiled and ran it on my work machine its very very jerky and WAY too fast. I have tried slowing down the code by changing the speed that my objects move but even the lowest settings are still jerky and way too fast. Any ideas Thanks in advance Hi Rick, How are you controlling your game tics If you are moving your objects every time the Update method is called and not limiting it in any way your game will run at whatever speed the system will allow it to go... so on one system it may be slow and on another beefier system it will run way to fast. I have learned a couple of m ...Show All

• Software Development for Windows Vista Events not reaching Workflow...

  Very likely I am not doing it right but cant see the obvious. I used the "Communicating with the host application" lab exercise document as the base with some changes, I have host app (implemented as windows service) that, based on config, loads a couple of assemblies implementing certain local services. The app first registers an instance of ExternalDataExchangeService with the WF runtime which it then passes to the assemblies implementing local services. The assemblies then register instances of their respective local services with the external data exchange service. These satelite assemblies also expose remoting i/f which allows other app to deliver events to be routed to the workflow instances via the local service ...Show All