Anand Raman - MSFT's Q&A profile

• SQL Server Error On Clicking Calculation Tab from BIDS (In any Analysis Service Project)

  Hi all ... * Installed SQL Server 2005 Developer Edition and learning SSAS 2005 * While clicking on Calculation Tab, the designer surface shows error: Unexpected error occured: error in application My Machine has following Software Installed (In the same order of listing): Windows 2000 Server Microsft .Net Framework 2.0 SQL Server 2005 Express SQL Server 2005 Developer Found a post on same topic on the forum, but it was NOT concluded with a solution. Can anyone help Piyush Hi all ... The problem is solved..... Sorry to bother. The problem is solved on the same line of the solution provided by the previous post. Though it was NOT because of the OFFICE 2007 TR, the ro ...Show All

• Visual Studio SortedList and reportViewer

  Hello, I use the reporViewer with a business object as datasource. This business object contains a property which type is a sortedList. So my problem is how to access to the Keys and Values of this property in my report. Example : =Fields!MyBusinessObject!MySortedList.Value.Keys =Fields!MyBusinessObject!MySortedList.Value.Values These examples don't work in my project. Thank you for your help. Dany. ...Show All

• Visual Basic Checked List Box in VB DOT .NET - Checked items gets unchecked when used inside Tab Control and while tabbing

  Hi If you are using a Checked List Box Control into a Tab Control on VB .Net application, then when you switch between tabs, the checked items gets disappeared. This bug is already listed in the Microsoft article. I figured out a way on how to avoid this error. Just by adding the checked list box in a user control and then using the user control in your tab control will not erase the checked items list. Please try. Thanks, CM i think a 3rd party tool, a specChkListBox with such interface can solve the problem i had one but it wasn't from a reliable source & so i don't use it, does any one have such a reliable 3rd party specChkListBox with the required interface ...Show All

• SQL Server Is there a max number of pages/parameters for reports?

  I created a report that contains 5 subreports (which retrieves data for meetings). There are currently 826 meetings and each report is 2 pages long (though this number is not static). Each time I run the main report (passing in the 826 MeetingIDs as a parameter), I get a time-out error. However,  I pass in all the MeetingIDs for each of the subreports and it runs fine, even when I do a run several of the subreports together. Before trying to revise my queries, I was hoping someone could tell if there are any limitations on how many pages you can export to PDF Also, in terms of performance, is there any difference between including subreports and just creating different data sets within t ...Show All

• Visual Studio Visual Studio 2005 SP1 is now available!

  Visual Studio 2005 SP1 has now shipped and is available for download here: http://msdn.microsoft.com/vstudio/support/vs2005sp1/default.aspx I'd like to take a moment to thank everyone for using the ReportViewer controls, for helping to answer questions in this forum, and for bringing issues to our attention. I have enjoyed answering questions in this forum over the last year and look forward to continuing. While we haven't been able to respond to every question posted on this forum, I can assure you that we do read all of them and use the feedback to help plan and prioritize future releases. Below is a partial list of fixes that are included in the ReportViewer controls in Visual Studio 2005 SP1. Fixed several issues around A4 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed Direct3D 10

  Since XNA only supports DirectX 9.0 Where is Managed Direct3D 10 I hope there will be Managed wrapper for Direct3D 10 thanks XNA only lets you use an entire window for the graphicscomponent. This is not much use to people like me that make business apps with 3D elements in them, for us being able to create a device in a control within a Windows Form is essential. Our applications are never going to hit the XBox so we would end up moving away to OpenGL libraries rather than use C++ which is too much of an overhead in a RAD environment. ...Show All

• Visual C# Transparent Text Box

  I'm looking for a truly transparent text box. I'm NOT looking for a text box which backcolor is like its parent or Transparent. I DO look for somthing like microsoft did in mspaint. Any suggestions Thanks. thanks, but it's not good enough for me. let give me you the bigger picture: I Have a D3D application. i have a texture streched over the entire window. i want to add a transparent text box to the app. I've tried to set the textbox backcolor to transparent, but it dosen't work (I don't know how transparent is implemented, it's good enough for GDI, but not good enough for D3D). One thing is setting the textbox backgroundimage to a portion of my texture, but i don't like it so ...Show All

• SQL Server What is the main benefit of stored procedures?

  Hi, all here, I am having a question about stored procedures for data mining. What are the main benefits of stored procedures for data mining (what stored procedures can do for data mining on sql server 2005 when they are useful for data mining ). Could please any expert here give me any guidance for that Thanks a lot in advance. With best regards, Yours sincerely, Hi, Brendan, thank you very much for your guidance. Yes, your answer did give me a very clear main benefits from Stored Procedures. Thanks a lot. With best regards, Yours sincerely, ...Show All

• Visual C++ Cannot open include file: 'snanls.h': No such file or directory

  I got this error when trying to build VC++ 6.0 project on Visual Studion 2005 standard edition. fatal error C1083: Cannot open include file: 'snanls.h': No such file or directory There is no website or forum that mention about this error. Please help. Thank you, Aing According to this, http://msdn.microsoft.com/library/default.asp url=/library/en-us/his/htm/_sna_snanls_dependencies_nls.asp it (and the corresponding snanls.lib) is supposed to be part of the Platform SDK. But it's not any longer (it used to be). It's now only included in the Host Integration Server 2000 SDK. http://www.microsoft.com/downloads/details.aspx familyid=e110d022-b5d4-4aae-bc19-ed442b6f44a8&displ ...Show All

• Smart Device Development Require help accessing CF RFid Reader in Compact Framework

  Hi, I've recently started a project developing an application for a PDA that reads RFID tags (tags that emit a radio signal containing a unique id number, and that can be picked up by a reader). I have been supplied with a reader and tags but unfortunately very little information on how to actually program it. All I've been told is: This reader has a standard CF interface. To get the bits into your PC or PDA, you must use the same part of your development system as for reading other data from a CF card. The meaning of the bits you can find in John's e-mail. Please do not forget that different processors might need different versions. The email they're referring to contains the following information: Data format for reading the tags is as ...Show All

• SharePoint Products and Technologies SPWeb.Confiugration Always returning -1 : Bug or No bug?

  The Configuration attribute of the SPWeb object always returns -1. Here is the code I'm using: SPSite site = new SPSite(siteColName); SPWebCollection webCol = site.AllWebs; Console.WriteLine(); Console.WriteLine(site.WebApplication.Name + "\n"); for (int i = 0; i < webCol.Count; i++) { Console.WriteLine("'" + webCol[ i ].Name.ToString() + "' ==> " + webCol[ i ].WebTemplateId.ToString() + ", " + webCol[ i ].WebTemplate.ToString() + ", configuration: " + webCol[ i ].Configuration ); } The .Configuration property is always returning -1. Is there another way to get the Site Template configuration number Thanks, Joubin N ...Show All

• SQL Server Open Navigation Link in a new window

  I have a report with a hyperlink. When I go to the navigation tab, it does not give me any options to open the link in a new window. I have a link to show help and I do not want the user to actually move away from the reports Any ideas This is such a simple thing..I wonder how MS misses this hello : On a hypertext link in a report, how to open the link in a new window IE. Thank's ...Show All

• SQL Server Date Ranges in KPI Value Expression

  How do I enter a date range for a KPI in the Value Expression This simple expression will get me a count for 2006 but how do I get a count of 2005 and 2006 combined ([Measures].[TOTAL AMT], [Incident Status].[Incident Status].&[1], [Start Date].[Year - Quarter - Month - Date].[Year].[Calendar 2006]) Thanks * is shorthand syntax for Crossjoin() - this is documented in BOL : SQL Server 2005 Books Online Crossjoin (MDX) Updated: 17 July 2006 Returns the cross product of one or more sets. Syntax Standard syntax Crossjoin(Set_Expression1 ,Set_Expression2 [,...n] ) Alternate syntax Set_Expression1 * Set_Expression2 [* ...n] A s ...Show All

• SQL Server SQLCMD error

  hi i am using the SQL Server 2005(Express Ed). I am at the client end, i mean i have installed the client tools on the workstation & server is over the network(local). when i try to execute the command at dos prompt C:\>SQLCMD it throws Missing Data Source Name Usage: SQLCMD -d dsn -u user -p password -i filename Why but if i execute the same on the server its working fine. now i wan to execute a set of sql statment from the client (at dos prompt) how can I do this if i do like this C:\>sqlcmd -d dm2006 -u sa -p sysadm -i ss.txt (that is with dsn,username,password, filename) it ok but when i use the SQL Query as C:\>sqlcmd -d dm2006 -u sa -p sysadm -q "SELECT * FROM MISC ...Show All

• Microsoft ISV Community Center Forums SELECT syntax in VBA for retrieving information

  Hi - this is coming as a modification from one of my previous posts that were solved - on an activity screen the user who is logged in can only select companies that have the 'active' tickbox ticked and where the 'leadofficer' value must equal the value of the user logged in. this is achieved by the following VBA Private Sub Form_Load() Me.companyname.RowSourceType = "Table/Query" Me.companyname.RowSource = "SELECT [companyname] FROM [tblcompany] WHERE [active] = Yes AND [leadofficer] ='" & loginname & "'" End Sub where loginname is a global variable held in a module and stores the name of the user currenty logged in. However i now need an additional leadofficer field - 'leadofficer2' which ...Show All