Prasenna's Q&A profile

• SQL Server Web forms and report parameters

  Hi all- I am having trouble with my understanding of how web form input fields affect report and subreport parameters. My assumption is that when you invoke a Reporting Services remote report from the POST action of a form, any input fields declared in your form must also be declared as report parameters in your target report. Is that true Must all subreports in that target report also have report params corresponding to the form input field names (For instance, my Submit button is form input field...) Do form input field values override the report parameters which share the same name Must I declare a default value for these corresponding report params, even if they will be overridden by the invoking form Would query parameters (which ...Show All

• SQL Server Connect to Analysis Server - A connection cannot be made. Ensure that the server is running ...

  In my SSAS SP1, I received an error msg in Aggregation design wizard "A connection cannot be made. Ensure that the server is running ..." while I was tryng to start "Performance gain reaches%" box. I verified that the local source SQL 2005 sample "AdventureWorksDW" is running without a problem. (1) I removed and re-installed Microsoft SQL Server 2005 Developer Edition on my Windows XP Professional, yet the error remains. (2) I, then, downloaded and installed Microsoft SQL Server 2005 SP1, and try again, the error remains. (3) I also remove and reinstall my Network Interface Card on my IBM ThinkPad, and start all services who can be started on my Operating System, the error remains. Who can help ...Show All

• Visual Studio 2008 (Pre-release) ServiceContractAttribute Issue in Self Hosted Application:

  HI, I am having one more issue In Self hosted application: Basically we are developing a project in two version one is demo version and the other one is full version I want to use the same class interface service structure for both [ ServiceContract ()] public interface IService1 { [ OperationContract ] System. Guid AccountInfo( AccountInfo dataContractValue, string conn); } public class ClientInfo : IService1 { public System. Guid AccountInfo( AccountInfo dataContractValue, string conn) { // Code for the method } } this is working in IIS hosting wcf service, In case of self hosted , I am getting the following error : The contract type ClientInfo is not attributed with ServiceContract ...Show All

• SharePoint Products and Technologies Auto create a workspace - event handler or workflow designer?

  Hi - what would be the quickest way to have a workspace automatically created when a check box column is ticked for a list item Basically we need to replicate the functionality available in a calendar list where you can tick the checkbox to create a workspace when adding a new item but we need it for a Task and Issue list. From what I can tell, some level of coding is required but if anyone knows a way of creating this functionality without code that would be ideal. Otherwise whats the best design for coding this Darren, I wouldnt recommend it, but if you must, I would go with an event handler and not a workflow. Both are a-synchronous, so if the site creation fails the user will now know about it ...Show All

• Audio and Video Development Question about how a element's opacity affecting its children.

  Dear All, I have a question about how a element's opacity affecting its children. I think the parent element's opacity shall cascade to its childen elements, for example: " <div id="parent" style:position="absolute" style:x="10px" style:y="10px" style:width="100px" style:height="100px" style:opacity="0.2"> <button id="children" style:position="absolute" style:x="5px" style:y="5px" style:width="50px" style:height="50px" style:opacity="0.8" /> </div> " I think button "children" shall be drawned as a half-transparent element with opacity ...Show All

• SQL Server Inserting data from text file to SQL ME table

  Hello, I have an application taht requires the use of a table. The device that this application works on, has a local memory that does not allow me to insert the 800,000 records that I need. Therefore I have two approaches: 1. To insert less records into my local memory database e.g 40,000 but not row by row, bulk insert is better. How do I do the bulk insert 2. This is the most prefferable way: To find a way to insert all 800,000 records into a table on the storage card which is 1GB. What do you suggest Will using threads be helpfull Any ideas I use C# from VS 2005, SQL ME, compact framework 2.0 and windows 4.2. Thanks in advance, John. Do you have to load the records on the device Or ca ...Show All

• SQL Server Disk Partition Size

  Can you please tell me what the largest disk partition size is for a clustered SQL Server 2005 installation (64 bit edition) I have been told it is 2 Terabytes - can anyone confirm this Many thanks Shirley If you're asking about logical partitioning, this might help: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/sql2k5partition.asp But if you're asking about physical partitions on the hard drive, then Books Online states it's 16 terabytes. Paste this in the "URL" bar of BOL to check out the table of specifications: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm Buck Woody ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA on IRC

  Join us on IRC in #XNA on efnet We are growing a community where people can get real time help on their issues and work on projects together! Thanks, Ziggy I would if my work didn't block chat.  Even web based chat pages are blocked AFAICT (the one listed above certainly is). I keep forgetting to start Trillian at home. I'll have to make a note. ...Show All

• SQL Server Dumb question

  Simple question from a simpleton. I'm working through Microsoft Press SQL Server 2005 Reporting Services Step by Step. It references a database rs2005sbsDW, which as far as I can tell was not included with either the sample databases on the SQL Server (standard edition) install disk or the Step by Step book. Where the heck is it What am I missing. Trying to reinstall the sample databases from the SQL Server install disk's tells me I have everything installed already. Thanks in advance. Please I need the datasource rs2005sbsDW my email is edupuebla@yahoo.com. Thanks ...Show All

• Software Development for Windows Vista High Level Product Comparison

  I have been dabbling with "Workflow" for ~ 15 years now, using various products and am very excited that MS has finally gotten a product to market that is not wrapped by BizTalk etc... Given my background, I was hoping to find some resource that did some kind of high level comparison to the products I am already very familiar with. Can anyone on here point me to some resources that might do just that Essentially I am very familiar with the concepts and architectures behind ViewStar(Global 360) and FileNet, so anything that draws comparisons against these will be invaluable! Thanks, Dave Thanks for the follow up Paul. And sorry for the very delayed response (familly emergency :-() After spending some time rea ...Show All

• Visual Studio Team System TFS database tables aren't cleaned after project deletion?

  Hi there, We are currently testing out TFS and have created/deleted a multitude of team projects over the last months. Now we notice that the TFS databases don't seem to clean automatically - e.g. our TfsVersionControl database still holds references to rather old projects that we already deleted. However I do see some jobs like "TfsVersionControl Administration Job" and the "TfsIntegration Maintenance Job", but I cannot see what they are doing (cannot examine the contents of the associated sproc). Any ideas Hi Thomas, You are correct. TFS does not delete all the data from version control when you delete the projects. It is stored for distorical reasons. In next release there will be a destroy op ...Show All

• SharePoint Products and Technologies Can not creat Site collection in wss 3 release version

  hi all... My installation of WSS 3 was successful.. My config Windows 2003 SP1 (Part of Domain "testwss") Framework 3 (Release) Wss 3.0 (Release) Sql 2005 ( On other machine which is part of Domain "testwss") IIS 6.0 office 2003 pro after creating application successful i am not able to create site collection i get the following page. The Windows SharePoint Services Web application has been created. If this is the first time that you have used this application pool with a SharePoint Web application, you must wait until the Internet Information Services (IIS) Web site has been created on all servers. By default, no new SharePoint site collections are created with the Web application. To create a new sit ...Show All

• SQL Server Make subtotal column widths bigger than normal columns?

  The reason I say this is because a subtotal of a dollar amount will take up more space than other values. Right now, I'm forced to make all columns the same larger width because it appears to be all wrapped into 1 column width setting. I can try to change the value of the subtotal column, "matrixcolumn4", but it reverts to the other value after I press enter to apply the changes. Sorry there is no good solution at this point. One alternative approach is to use side-by-side matrices to a subtotal column with different width, however you would need to "hide" the row headers of the second matrix. For the next major SSRS release we are looking into significantly improved support of these ...Show All

• Visual Basic Reading XML File (Fast and Flexible Approach)

  Workign on creating a web service using VB 2005, the Web Service consumer has to send an XML file while the actual web service implementation has to get the data out of the XML file and process it. Whats the fastest way to go about doing this Not sure but should I use XMLTextReader or XMLDocument. Thanks in advance. If you define the format of this Xml file passed around, one easy way is to use a dataSet. It will flexable for you to define internal tables, and fast to write the code. (Not sure what 'fast' means, fast to write the code, or fast to run ) ...Show All

• Windows Forms is it normal that linkLabel control reacts extremely slowly

  I tried the LinkLabel solution and it is so slow. I followed the msdn example for LinkLabel here: http://msdn2.microsoft.com/en-us/library/system.windows.forms.linklabel.aspx i get the target page 30 seconds after I click on msn link in that example. Is that normal To let you know my Internet connection is really fast. Thanks if any advices. no it works fine over here. Can you post the exact code you are using I have done it before and as soon as you clicked on the linklabel, took a max 2 seconds for the browser to pop up and do its thing. Of course it depends on the website itself and how big the content is :-) what happens if you try a different URL is it faster ...Show All