sql server reporting services: Parameters to reports that only show is previous parameters filled -- sql server reporting services

You're in the

sql server reporting services

group:

Parameters to reports that only show is previous parameters filled

Justin30519
7/16/2004 7:16:01 PM

sql server reporting services:

I don't know if I can do this with Reporting Services. I have ten parameters to a stored procedure. However, each parameter only shows when the previous one is selected. For sake of this discussion, the queries from which the parameters come are completly unrelated.

Initially, only the pull-down for parameter 1 appears. When the user selects a value for parameter 1 using the initial pull-down, the pull down for parameter 2 should appear. When the user selects a value from this pull down, a pull down from parameter 3 should appear.

At any point, the user can click View Report and pass the parameters he selected and all other parameters null.

Thanks in advance for any help.

Justin

Re: Parameters to reports that only show is previous parameters filled

Brian Welcker [MSFT]
7/17/2004 12:41:25 AM

Yes, RS supports sequenced parameter prompting. You build the valid values
query for a parameter using a query that includes previously selected
parameter values. I believe there is a sample called 'Product Line Sales'
that illustrates this technique.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Parameters to reports that only show is previous parameters fi

Justin30519
7/17/2004 7:40:02 AM

[quoted text, click to view]
Thank you very much for your reply. It was helpful. I can do what my boss asked now. :)

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.

home · blog · groups

Questions? Comments? Contact the dn