Pete_M's Q&A profile

• SQL Server Force at least one parameter (2K5)

  I am trying to build a report that has about 6 different parameters. All of the parameters have been set to allow null, however, I would like the user to put in at least one "search" criteria in order to run the report. How would I be able to do that In addition, when I am viewing the report, it automatically runs and does not wait until I click "View Report". How can I set it not to execute when the report is viewed, but when the user clicks the button Thanks Solution: Create embedded code function that takes as parameters your report parameters values (like this MyFunction(p1value, p2value, p3value,...) ) Inside do something like this: iff(IsNothing(p1value)=true,0,1)+iff(IsNoth ...Show All

• SQL Server How to support multiple language(Latin,chinese,japanese,korea) in one report when exporting to PDF format

  We should support multiple language(Latin,chinese,japanese,korea) in one report when exporting to PDF format in reporting service. We have used Arial Unicode as our font. But when we exported the report, the korean language item can not be displayed. Any idea on that Thanks a lot. ...Show All

• .NET Development generation of client stubs and data sources

  Hi, I was wondering if anybody would have specifics into what happens when you add a web reference to a project. I know that it runs wsdl.exe, but I need to know how to generate the other files on the fly from a command line. I need to know how to generate all of the .datasource files, the .map files, etc. Does anybody have the script that they use, or at least know what it is they do. Any help would be greatly appreciated. Thanks, J.P. ...Show All

• Windows Networking Development Wireless LAN - RSSI

  Unfortunately, this is not the right forum for this question. This forum is for network QoS technology related questions. I suggest you post this question on a forum for wireless LANs. ...Show All

• SQL Server Management Stusio install via SMS

  s there a way to only install sql management studio via SMS I found the article on the unattend install, but I do not want the connectivity tools, etc. I only need the management studio portion installed, nothing elsre. Has anyone accomplished this http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=478384&SiteID=1 ...Show All

• Visual C# Learning C#

  Hi, I would like to ask anyone here for their advice on where I should start with C#. I have been programming for nearly a year now and dont know any other languages other than the VB family, such as vba, vb6 and vb.net. Since i have been programming with .net I have learned alot from the msdn library that comes with the installation of Visual Studio, and whenever looking at the example of code I still am always drawn to read the C# code. Something is just making me want to learn this language, However a good friend of mine is trying to alter my path by suggesting I learn C++. Learning C++ I would like to do, and also think I would benefit with the fact my friend knows the language. But may it not be a good path to learn C# then g ...Show All

• SQL Server Context Search

  Hello, I have a web application that I need to search based on what the user entered in the input box. e.g when the user enters in the box something like "Brain Boom" I need to search the column in the DB table where there is anything word like Brain or has Boom or all the above. How will I accomplish this Thanks Since these values are in one Text box, How would I know that there are two words in the text box Do I have to always loop through the text box to check if it is a tab/comma delimited list ...Show All

• SQL Server WINS

  Does SQL 2005 require WINS You will probably have a WINS name, which is assigned to the Server but you don’t need a WINS service as SQL Server also runs on a single machine without any server services. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Formatting Currency Numbers from Analaysis Services

  Hi, I'm using Reporting Services in conjunction with Analysis Services. The problem I'm having is formatting numbers to be dollar amounts. I know how to set this in Reporting Services and when a data source was regular SQL, then everything was just fine. However, when I switch to Analysis Services the number would just stay the same. i.e. "60.2" instead of "$60.20". The only thing I can think of is if Analysis Services is returning the number as a string for some reason, and RS won't format strings for currency. Any thoughts Thanks! Okay, looks like the attribute number was getting returned as a string. I used CDbl() to convert into a double and it works fine now. ...Show All

• Windows Forms cannot handle to property changing event of my datatable

  i select the property changing event of my datatable and i get the folowing exception,. the code is autogenerated and ... Private Sub dt1_PropertyChanging( ByVal sender As Object , ByVal e As System.ComponentModel.PropertyChangedEventArgs) Handles dt1.PropertyChanging End Sub Error 1 Method 'Private Sub dt1_PropertyChanging(sender As Object, e As System.ComponentModel.PropertyChangedEventArgs)' does not have the same signature as delegate 'Delegate Sub EventHandler(sender As Object, e As System.EventArgs)'. D:\.... is that a bug I am a bit confused as the event arg you use is System.ComponentModel.PropertyChangedEventArgs while it handled PropertyChanging. Are you sure you shouldn't handle Prop ...Show All

• SQL Server Open a blank or new record set code needed.

  I have an access 2003 Data access page published to the web that gets its data successfully from an MS SQL 2005 server. I need the "page when it opens" to display a new / blank record (not the first record in the table as it does by default) any pointers would be nice thanks Pete... If you connect a table through a linked table to SQL Server, you will have to specify a primary key on the Access side, otherwise Access might not know how to update / insert new records. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Visual Studio Combined Help Collection is Borked

  How do I repair a damaged help collection In an effort to reduce the insane duplication of help collections I've managed to completely bork my Visual Studio 2006 Combined Help Collection. I've been trying different collections of help files by using the Help Collection Manager form and have finally broken everything. When I launch Combined Help I now get a blank home page with no TOC in the Contents sidebar and no topics in the Index sidebar. However, both sidebars have long lists of items in their "Filtered by:" dropdowns. I am able to access the Help Collection Manager form by manually typing in the url. I can even manipulate the selected collections and verify that the changes are persisted. What I cannot do is get Combined He ...Show All

• SQL Server Using FreeTextTable Conditionally

  Hello all! I have a stored procedure that accepts a parameter @SearchTerm that may be null. In my WHERE clause, I check for all records where @SearchTerm is null, or are LIKE '%' + @SearchTerm + '%' when not null: SELECT (some records) FROM (some tables) WHERE @SearchTerm IS NULL OR (some fields are LIKE '%' + @SearchTerm + '%'); I am trying to use FTS with a FreeTextTable to make our search ability more robust: SELECT (some records) FROM (some tables) JOIN FreeTextTable(tableName, columns, @SearchTerm) ft ON ft.[KEY] = tableName.[KEY] However, because @SearchTerm can be null, meaning the user is not filtering our records by a search, doing a JOIN to a FreeTextTable throws an error (cannot have null as search string). Ple ...Show All

• Visual Studio Express Editions Unable to start debugging on the web server.

  I have been working with Visual Web Developer 2005 Express in file mod and have had no problems. I created a site in IIS which is running and working for aps code. I have asp.net 2.0 installed on my system and appears to be set up for the new site. When I try to run a file from VWD I get the following error message. Unable to start debugging on the web server. Unable to connect to the web server. Verify that the web server is running and that incoming Http requests are not blocked by a firewall.   Even if I turn off by firewall I get the same message.   Can anyone help     Hi! Thanks for asking! I'm a member of the ASP.NET team, and was just popping over here to see what was going on. ...Show All

• Windows Forms Whidbey DataGridView Scroll control info using GetScrollBarInfo fails

  Hi, I used GetScrollBarInfo WinaPI method to get the DataGrid's HScrollBar/VScrollBar Thumb position and other details and this returns perfect result in this case, but the same function when I tried to get the DataGridView's Scrollbar details it returns me false and doesn't populate the ThumbBottom,ThumbTop,rcScrollBar rectangle information. Does anyone know why it doesn't work and how can I get the ScrollBarInfo for the DataGridView control Is there any way that I can get the Thumb information without going thru InterOp Thanks, Nitin Sharma DataGridView uses scroll bar controls, not the window scrollbars. You have VerticalScrollBar and HorizontalScrollBar properties but they are protected so you will need to derive ...Show All