I have a report that displays a list of ProviderID  ie…  1001, 1002, 1003.  Under that I need to associate services to each ProviderID.    I can do this nicely with cascading parameters, however the report is set up for many providers to retrieve the same report from an application.  So the ProviderID is already set in the report.  How can I get the services to associate to the ProviderID if its already being passed into the report.

HELP!!!   

Thanks, Aimee

The easiest solution would be to create a view per report per providerid. The view would limit the scope of the data in both the provider records and then the service data. YOu would not need to change your select statements and the parameter for services would only look at the limited view data instead of the full table data.

I will assume you cannot do this. The next option would be to create a cascading parameter and just not use the first parameter in your select statement (since this is 'hard coded' into the select statement). If you can limit the range in the parameter to the allowed items for this vendor report it would prevent them from selecting an invalid vendorid. A little redundant but might work...