Cascading Parameters

[ramanmahalingam]

Hi All

I am using RS 2000. I used 2 input parameters for one of the report. The 2nd parameter is based on the 1st parameter. i.e. First Parameter is Country and 2nd Parameter is State. Based on the Country selection the list of states for the selected country will get displayed. This is working fine in Reporting services as well as report server. When deploying into the application it doesn't work.

If you have solution for this I would like to share.

Regards

Venkataraman M
ramanmahalingam@hotmail.com

[fatherjack]

what is the error that you get? Do both parameters use the same datasource?

[ramanmahalingam]

I am not getting any error. It is not considered i.e. the 2nd parameter based on 1st parameter - State list based on country selection. I am getting empty list box. One is from the input parameter. the other one is data source.

[fatherjack]

are you sure the data has the values to fill the 2nd parameter? With adventureworks i can create 4 datasets - Country, State, City and Data and then use each one to filter the next until i get the data returned for sales for a city...

Country dataset:
SELECT Name, CountryRegionCode
FROM dbo.CountryRegion
ORDER BY Name

State dataset:
SELECT DISTINCT CountryRegionCode, Name, StateProvinceCode, StateProvinceID
FROM dbo.StateProvince
WHERE (CountryRegionCode = @country)
ORDER BY Name


1st param (country)=
Name:Country
Prompt:Choose country from list
data type:string
available values:from query
dataset:country
Valuefield:countryregioncode
labelfield:name

2nd param(state)=
Name:State
Prompt:Choose state from list
data type:string
available values:from query
dataset:state
Valuefield:stateprovinceid
labelfield:name

[ramanmahalingam]

It does work on Report Server. But the reports are being called from ASP .Net application. In that application 2nd parameter listing corresponding to 1st parameter is not working.

[ramanmahalingam]

It does work on Report Server. But the reports are being called from ASP .Net application. In that application 2nd parameter listing corresponding to 1st parameter is not working.

[fatherjack]

ramanmahalingam, i dont have any experience of running RS from an application so i dont think i can help further. My first thing to test would be permissions though - is your app getting to the data?