Parameter report - SQL Server Management Studio Custom Reports

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Scripts, Code Samples and SSMS Custom Reports » SQL Server Management Studio Custom Reports » Parameter report

Parameter report

Options

Previous Topic · Next Topic

anaylor01

Posted: Thursday, December 27, 2007 10:04:25 AM

Rank: Newbie

Joined: 12/24/2007
Posts: 2
Points: 6
Location: NYC

Problem #1. In Reports if you add a parameter and select multi-value when I run the report and Select All from the drop down list or if I select more than one value I get "incorrect syntax near ','. I haven't been able to find anything on this error. I am running Sql Server 2005 SP2.

Problem #2. In Microsoft Access I can add a Combobox that will return a list of values from a table and will let me assign a sort order.
When the form is loaded there is no value for combobox. The user can leave this value blank. What I like to do is write code that says if the combobox is null then select all.

When I try to do this in VB.net the form loads the combobox with values already in the combobox.

How can I either fix problem #1 or #2 or both? Thanks for your help.

Happy holidays.

Scott Whigham

Posted: Monday, January 21, 2008 1:29:36 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 329
Points: 700
Location: Dallas, TX

Hi there -

Just saw these - sorry for not responding sooner Smile

#1 - I just actually recorded a series on this same topic Smile

You need to change your WHERE clause from using "=" to using IN (). Example: WHERE OrderId=@OrderId works for single-value but, for multi-value, you just change it to WHERE OrderId IN (@OrderId).

#2 - No idea.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.