sql server reporting services: One Parameter to Drive Multiple Datasets -- sql server reporting services

RE: One Parameter to Drive Multiple Datasets

Amarnath
5/27/2007 2:31:01 AM

Should give the same parameter name to all the three.

Amarnath

[quoted text, click to view]

Re: One Parameter to Drive Multiple Datasets

Chris
5/29/2007 4:51:05 PM

On May 27, 2:31 am, Amarnath <Amarn...@discussions.microsoft.com>
[quoted text, click to view]

I think I made a mistake and only replied to Amarnath. Trying
again...

I don't see how to create 1 parameter that is referenced by multiple
datasets. I tried to create a parameter having the same name in each
respective dataset. When I did this I received the following error:
"More than one data set, data region, or grouping in the report has
the name 'myParameter'. Data set, data region, and grouping names
must be unique within a report."

I have a Report Parameter, which appears to have created a new
dataset, but when I reference the parameter in the MDX, I receive this
error: "Parser: The query contains the myParamParam parameter, which
is not declared. (msmgdsrv)". Maybe I'm referencing the Report
Parameter incorrectly from my datasets?

I appreciate any more assistance I can get.

Thank you very much!

Re: One Parameter to Drive Multiple Datasets

Chris
6/1/2007 3:32:58 AM

On May 27, 2:31 am, Amarnath <Amarn...@discussions.microsoft.com>
[quoted text, click to view]

Can you expand on your idea? I don't understand. Thank you!

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.