Lisa Ambler MSFT's Q&A profile

• SQL Server How to send parameters to report when executing ReportingService.Render

  I'm trying to figure out how you send/set the report variables when using the ReportingService.Render method. I can get the ReportParameters array using GetReportParameters but can't seem to find a way to populate the ParameterValue array that is passed as a variable in the Render method. I've tried creating an ArrayList comprised of ParameterValue objects (non-array), adding them to the ArrayList, and trying to convert that to a ParameterValue array. The example code I found is in VB.NET and looks like this: reportParametersArray = rs.GetReportParameters(reportPath, Nothing, True, _          re ...Show All

• Visual Studio Turn off find warning from within VB macro

  I have a macro that searches through the current document using this loop:         While ( DTE.Find.Execute() <> vsFindResult.vsFindResultNotFound )             // do stuff here         End While When the search fails, VS displays a warning window telling me that the search reached the starting point of the search. I can unselect the "show this message" checkbox, but I would prefer to temporarily disable that warning from inside the macro. Is this possible I can't seem to find the proper property. Thanks! --Eric ...Show All

• Visual Basic Making a picturebox have a transparent background

  I have a picture of a panda with a pink background (panda_down.bmp) and I was wondering: how do I get that pink background to be transparent Draw the image yourself in a paint handler, and use the imageattributes class to make 255/0/255 ( magenta ) transparent. ...Show All

• SQL Server Trouble with Iif!

  Hi! My report has a multi-value parameter used to select the elements to put in the "group by" clause of the query. The report must show only the columns selected in this parameter. As I haven't found any better way to do it (I tried to use an expression to hide/show the column, but this would let the report with a "gap" when the columns selected were the first and the third, for example), I created four tables (one for each possible size of the multi-value parameter), and I'm showing/hiding them based on the size of the parameter. I didn't have any problems to choose the rigth parameter value to show in a column tit ...Show All

• SQL Server failure in starting the process for the user instance

  High everybody, I have a set of winforms (.NET 2.0 assemblies) ( 6 total ) that each tries to open a connection to the same Database file using the same connection string. In the connection string, UserInstance is set to true. If each winform is started manually after opening the session on the computer, the connection to the database performs well for every winform. If the same winforms are automatically started at the opening of the user session, the the following error is reported by each application when trying to open the connection : Failed to generate a user instance of SQL Server due to a failure in starting the process f ...Show All

• Visual Studio Team System Problems with Reporting Services after restoring to a different server

  We had to restore our TFS to a different server, I have followed the Restore procedures on msdn: http://msdn2.microsoft.com/en-us/library/ms252516(VS.80).aspx . Team System is back up and operational however when I access the Reporting Services site I get the following error message: The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Get Online Help Thanks in advance! ___________________________ Sarah Cameron - InCycle Software Go to the Reporting Services Configuration manager under your Start->Programs->Microsoft SQL Server 2005->Confi ...Show All

• Software Development for Windows Vista Designer Problems

  I’m experiencing some problems while working with wf in visual studio. Sometimes while building or rebuilding the solution, the build fails, and NO exceptions are given . Opening the workflow file (workflow.cs) will show an exception in the designer: “ Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information .” I don’t know what it means. However sometimes, restarting VS will resolve the problem, but then again…sometimes it doesn’t. The problem occurs for both state machine workflows and sequential ones. I’ve not used workflows with code separation. An other, not so funny feature is ...Show All

• .NET Development VS2005 Dataset Designer Bug?

  Hi I seem to be having an issue deleting datacolumns from a datatable created using the dataset designer (hope that's clear!). I have created a dataset with two datatables based on SQL Server 2000 tables. I can't seem to delete any of the datacolumns that make up the datatable. I can change names, modify, etc but if I try and delete the datacolumn I get the following error message: Failed to delete object(s)'{0}'. {1}. The only option I have is to click OK and the column then reappears. I don't have this issue in any other dataset, just this particular one. I've created quite a few custom queries so I don't really want to delete ...Show All

• Visual Studio 2008 (Pre-release) MenuItem selected color

  Is there a simple way to change the background of a menu item when it is selected There is no such property on the MenuItem class. I tried changing the control template of MenuItem but the default template is already pretty complex and I'd like to avoid having to rewrite the entire template. Any idea Thanks in advance <Style TargetType="{x:Type MenuItem}"> <Style.Triggers> <Trigger Property="IsHighlighted" Value="true"> <Setter Property="Background" Value="red"/> </Trigger> </Style.Triggers> </Style> ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creating a new texture as a rotation of an existing texture

  thank you very much but new problem come: How to create a new Texture from an existent Texture I have a bitmap file, first I created a Texture from a bitmap file by using function D3DXCreateTextureFromFile(). Now I want to create an another Texture from the existent Texture, and the new Texture's content is the existent one's bitmap but be rotated 45 degrees. For Example: the existent Textures have a horizontal line "-" on it's center , from the old Textures I can create another three Textures by rotating different degrees, and the another Textures looks like "\", "|" or "/" . How to do this I only want to create a series of sequential ...Show All

• SQL Server SQL 2005 Full Text Search File Size limitation

  I would like to know what the maximum document size is for full text search in SQL 2005. I found the following in the SQL 2000 Help files, look at the note: Filtering Supported File Types When a cell in an image column contains one of certain types of documents, full-text search uses a filter to interpret the binary data. The filter extracts the textual information from the document and submits it for indexing and subsequent querying. MicrosoftR SQL Server 2000 includes filters for these file extensions: .doc, .xls, .ppt, .txt, and .htm.... Note For full-text indexing, a document must be less than 16 megabytes (MB) in size a ...Show All

• Windows Forms SelectionChangeCommitted not working

  Hello, I have a ComboBox that I want to act as a Parent to a second Child ComboBox.  I am using the SelectionChangeCommitted event of the parent to filter the datasource of the child. The problem is that the SelectionChangeCommitted event of the parent is firing too soon! If I put a*space space*point in my code in the SelectionChangeCommitted handler I see  ...Show All

• Visual Studio Team System Tests not appearing in test manager lists

  Hi, I'm using VS.NET 2005 beta2 (not testing edition just normal developer edition) Have a TestProject in a solution with other projects. I've used the wizard to create unit tests, i've added tests manually, I've added existing tests into a test project. But none of the tests appear in the lists in Test Manager only a manualtest1 appears which is one that visual studio added when it created the test project. How do tests get my unit tests to appear in the lists in test manager I can't see any add buttons except to add new tests. I think what I'd expected is that if you add the attributes <TestClass()>  and <TestMethod()&g ...Show All

• Visual Studio Team System May I obtain RC without MSDN?

  Is there any way I can download or order a CD for the RC version without a MSDN subscription   I obtained the B3R version on a CD I ordered from this site.  Most of the solutions to my problems are "Upgrade to RC", so I'm trying to do that.  My department is debating whether or not to spend tens of thousands of dollars on this software, so I feel it wouldn't be too much to ask for access for evaluation. There will be an updated trial version at some point with the final v1 binaries, but there is not a date set for that. Buck ...Show All

• Windows Forms How to split the column Heading of Datagrid in Two rows

  In vb.net The column Heading of one of columns of the Datagrid is Normal Rate of Change As I have 9 columns to this grid I had set the width for this column 110 Then heading is truncating I want to wrap this heading as Normal Rate Of change I have difficulty could someone please let me know how to do this Thanks Hello Every Body I am also  ...Show All