all groups > sql server reporting services > april 2005 >
You're in the

sql server reporting services

group:

Create Report Parameters Dynamically


Re: Create Report Parameters Dynamically Bruce L-C [MVP]
4/7/2005 1:26:45 PM
sql server reporting services: If you want to have a parameter that is a combo box filled from a query
that is not problem. If you want to vary the number of parameters then that
is fixed. In layout tab, click on a part of the report (empty part), go to
the report menu, parameters.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Create Report Parameters Dynamically hippo
4/7/2005 6:11:21 PM
Hi there,

I was wandering if it is possible to create report parameters on the
fly.

for example. table returns one moment 3 values, other moment 6 values.
depending how many values i would like to create report parameters...

Could anyone help?


Greetz,
Hippo from [NL]
--
Re: Create Report Parameters Dynamically RamR0m
4/8/2005 12:25:02 AM
Hello, i got the same problem, only the following:

Depending on returned values i would like to create a combobox.
For example, my dataset or stored procedure returned [x] names, and each
name has 5 possible values. Depending on [x] i would like to create
dynamically parameters. Is this possible?

[quoted text, click to view]
Re: Create Report Parameters Dynamically Bruce L-C [MVP]
4/8/2005 9:25:36 AM
Search Books On-Line on the phrase cascading parameters


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: Create Report Parameters Dynamically RamR0m
4/11/2005 1:01:03 AM
Thank you Bruce for you reply, but this isn't what i wish.
What i understand of Cascading Parameters is that you have to predefine your
parameters before execution.

What i would like is to have is, depending on values returned by the
dataset, vary the amount of visual parameters.

Greetz, RamR0m

[quoted text, click to view]


[quoted text, click to view]
Re: Create Report Parameters Dynamically Ted K
4/11/2005 9:20:27 AM
[quoted text, click to view]
and there is no way to dynamically add or remove parameters at report
run time. You may want to see if someone from Microsoft knows if this
is a wishlist item for future versions.

If you are letting Reporting Services prompt the user for parameters,
the best thing I can think of that you can do is define the maximum
number of parameters, then use cascading parameters in a way that the
unnecessary parameters only have a single choice called "Not
Applicable" or "Skip Me". If you have an application that is calling
the report, you could prompt the user only for the parameters that you
really care about, and then behind the scenes fill in the remaining
parameters with dummy values that aren't actually needed to generate
your report data.

Ted
AddThis Social Bookmark Button