s_n_e.h's Q&A profile

• SQL Server How to add columns dynamically based on number of groups used.

  Hi,    I am pretty new to the Microsoft Reporting services. I wanted to know if this is possible to design in the reporting server. I have a requirement to take the number of groups in my report as input. So if there are two groups I will have two columns and if I have three groups I will have three colums. Is there any way I can dynamically set the number of columns based on the input. Currently I am having to design different report for different number of groups. This causes more maintenance in case of frequent report design changes. Thanks in advance, Ragz. Yes, you can do this.  The ...Show All

• SQL Server IIf problem

  I'm using that expression in a select statment in generic query designer, but there is a problem with it. I'm wondering what would that be. IIf(Parameters!StartDate.Value = "" or Parameters!EndDate.Value = "", "", "where (Date between '" & Parameters!StartDate.Value  & "' and '" & Parameters!EndDate.Value & "')") Thank you Deepak for your help. Actually it worked with one double quote, the problem was in the condition (Parameters!StartDate.Value = ""), I replaced it by IsNothing(Parameters!StartDate.Value) and it worked fine. ...Show All

• Visual C++ Convertir String a Numero

  Hi, is the answer int.parse(string) ;) Simple int n1,n2; n1 = Convert::toInt32(textBox1->Text); n2 = Convert::toInt32(textBox2->Text); textBox3->Text = n1 + n2; ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. deform the mesh

  hi I want to deform the mesh like if I have a mesh, I want to move its vertices. The vertices can move in and out of the mesh and the mesh changes its shape. I am using managed DirectX. Can anyone suggest me the technique for this thnx  Perhaps you want to check out a sample called Basic HLSL in the directx sdk ...Show All

• Windows Forms How to replace carraige returns in DataGridView

  I am trying to replace carriage returns/line feeds with spaces in a DataGridView column.  I am importing this data from a parse engine that I am using in the application.  In the DataGridView, they Cr/Lf comes across as a square (hard code).  My question is what code do I need to replace this with and where do I place this code in my application  So far, I have done the following with no results: 1) try to replace the characters in the DataGridView by calling: [what class/object to use..].text = text.Replace("\r\n", "").Replace('\r',' ').Replace('\n', ' ') 2) Instead of using the "\n" and "\r" I used Chr( ...Show All

• Visual Studio 2008 (Pre-release) How to use XPSViewer in Win32 based applications

  hi: I have a few qeutions to ask : a)Our company's software(win32 based application) would spport xps file format, viewing and wirting the xps file. Could the XPSViewer be embeded in own software to view the xps file if can do, how to do If can't, how to support to view the xps format file b)What are difference between win32 based application and WPF application Could I use the new API classes under win32 based application such as  DocumentViewer,  XpsDocument and so on. Question: Our company's software(win32 based application) would spport xps file format, viewing and wirting the xps file. Co ...Show All

• Visual C# Error:Not all code paths return a value

  The following method is supposed to get data from database, store them in an array, and then return it. But somehow error of "Not all code paths return a value " occured. Pls help me with this, your help is greatly appreciated! (note:DBClass etc. are class made by me, which works well without problem) public ArrayList querycolidbyupcolid() { try { DBClass db = new DBClass(); db.ConnStr = ConfigurationSettings.AppSettings["cstr_article"]; db.Sql = "select colid from webcolumn where upcolid=" + _upcolid; db.readerData(); ArrayList s = new ArrayList(20); while (db.dr.Read()) { int ...Show All

• Visual C++ using ATL macro to change LPSTR to LPCWSTR

  Hello, I'm making a 3D game and realized I would have to face many problems and maybe trying to "reinvent the wheel" on my own, if I wanted to implement SETTINGS -(for graphics mode) in my game. So I am going for DXUT framework or engine by Dx team or what it is called to simplify my life. But I am facing some problems, because it is using UNICODE and I need to change LPSTR to LPCWSTR so I use macro A2W(lpstr) and include this for it #include <AtlBase.h> #include <AtlConv.h> But then I have a compile error: fatal error C1189:#error : Need to include strsafe.h after tchar.h bec ...Show All

• Visual Studio 2008 (Pre-release) WinFX Browser Applications and WPF/E?

  I'm confused as to how WPF/E (Windows Presentation Foundation Everywhere) relates to WinFX Browser applications. As I understand it WPF/E is supposed to deliver a subset of XAML (and the .NET framework ) in the form of a plugin to non-ms browsers. And this is supposed to be accessed programmatically through JavaScript So will there ever be a browser plugin that allows full WinFX Browser Applications in non-ms browsers i spoke with joe stegman at MIX. here's the scoop. WPF/E will be a subset of the full WPF. what that subset contains is not finalized yet, but they are targeting around 2MB run ...Show All

• SQL Server Cant locate SQL Server Express from client pc

  Hi, I have a 5 user network running SBS 2000. I have installed SQL Server Express on one of the client machines (not the SBS Server) I can connect locally without problem. However i cant connect from the other client machines. I have enabled TCP/IP, Remote Connections Etc I am attempting to test the connection using an .udl file. The server name is found but i still cant connect. Any help would be apreciated. Hi, the error message would be helpful for us. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server SA account Locked out

  I have been using SQL2000 for a number of years and the company I work for needs a new system so I decided to install SQL2005. I installed SQL2005 without any problems and set a complex password for SA. I tried to log on and had to make several atempts as I remmebered the password after the SA account got locked out with the following message: Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. (Microsoft SQL Server, Error: 18486). The problem I have is I cannot log onto SQL at all as it is not logging on with windows authentication either! How do I unlock the SA account ...Show All

• Visual Studio Express Editions Compiling

  Hi, I recently downloaded the Visual Studio Express Edition, and I am unable to compile the file to run it, or at least I do not know how to use the file once created. I was wondering how I would test out a program/file once it is debugged. Thanks everyone for the help! Can you describe more what you are doing and your expected results To compile an application you will need to load it as a project, build it and then run it. ...Show All

• Software Development for Windows Vista MSDN Problem.., Where is Documentation?

  In MSDN WinFX Software Developer Kit, In class Library Reference.., If I go to System.Workflow.Activities namespace, I can't able to view the webpages.., http://winfx.msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/N_System_Workflow_Activities.asp Can anyone of you say why it is not working Remaining and all namespaces are working properly but only System.workflow namespace is not woriking properly. Sekhar Ragu If you installed WF extensions, documentation should be there. It is not integrated in VS - look in programs->Windows Workflow Foundation->Windows Workflow Foundation Hel ...Show All

• Windows Forms Hiding Printing Dialog Boxes - Is this possible?

  Hey, I am using a PDF Printer to convert the file i have selected to a PDF. From my windows form when i click my print button it brings up a Save Dialog box for you to enter the new file name and the path of where it is to be saved. Is there anyway to specify these values so i can save this pdf to a place i specify wi ...Show All

• SQL Server Rendering Report

  I have created a page in Reporting Services with one row of data, but when the data is increased to 5 rows my pages doesnt render that...Any suggestions You need to use a dataregion (List, Table or Matrix) to display the data. Try adding a table with detail rows, each row from your dataset would show up as a detail row in the table. ...Show All