sql server reporting services: Parameters with all values as default -- sql server reporting services

RE: Parameters with all values as default

daw
8/11/2005 3:07:03 PM

sql server reporting services:

You'll need to allow Null values for each parameter. There's an example on
www.msbicentral.com. If you login and go to Downloads, Reporting Services,
RDL files, the example is Matrix.Param.RDL. There are other useful examples
there, also.

[quoted text, click to view]

Parameters with all values as default

James Woo via SQLMonster.com
8/11/2005 9:51:05 PM

Hi all.

Have a report with 2 parameters StartDate and SessionName. Both are non-query
based. So, the user runs the report and has to enter values in both fields in
order to run the report. I would like to have by default to have the report
run all values like as in (select * from etc) and then if user decides to
hone in on any StartDate/Session then they can used the parameter fields on
the report and then click view report.

Thanks
James

--
Message posted via SQLMonster.com

RE: Parameters with all values as default

James Woo via SQLMonster.com
8/11/2005 10:21:08 PM

COOL SITE.. Thanks. I will have to spend hours there.

[quoted text, click to view]

--
Message posted via SQLMonster.com

Re: Parameters with all values as default

AshVsAOD
8/12/2005 12:00:00 AM

Easiest way to do this...

Create a new dataset for your Parameter:

e.g
SELECT Product,NAME
FROM Products
UNION
SELECT '***' AS Product,'All Managers' AS Name

This creates a *** as the ALL for products...

Then in your main report dataset...
Make sure you are using the generic query designer (button above the query)
Then as your statement:
WHERE ( Product = @ProductParam or @ProductParam='***')

Good luck

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.