You have done everything right but just check 2 things.
1. your report parameters are of same as stored procedure parameters.
2. Go to table properties and check whether the dataset of the stored
procedure is associated with the table.
Amarnath
[quoted text, click to view] "Vinay" wrote:
> hi all:
>
> I'm trying to develop a proof of concept solution using Reporting Services
> and I'm new to this. Here is what I'm trying to do:
>
>
> I want the user to be able to generate a report, based on 2 selections the
> user can make using a dropdown list. For example, the first dropdown list
> contains all States and when the user selects a state, I will him to be able
> to select a city that is in the selected state. Once the user selects a city
> and clicks on View Report I want the report to be generated.
>
> Here is what I have done thus far:
>
> Created 3 datasets.
> 1. States: This pulls a list of states from the DB using a SQL statement
> (Form parameter State).
> 2. Cites: Based on the State, this drop down is populated by pulling all the
> cities in the selected state using a sql statement that looks like Select
> Cities from TBL where StateCode=@State.
> 3. GetDataForCity: Using the DataSet property pages, I've set the
> commandtype to 'StoredProcedure' and provided the storedproc name in the
> QueryString section.
>
> I've created the report and dragged the fields from the storedproc (a total
> of 4 fields) into the details section of the report.
>
> Now when I preview the report, the selecting of the state and city works
> just fine. (E.g. when I select CA, all cities in CA does get loaded into the
> second dropdown list) BUT the report turns up blank.
>
> I know the GetDataForCity data set does not have any errors as when I
> execute it manually, it shows the dialog where I have to provide the State
> and City and it shows me the data correctly.
>
> I'm quite sure I'm missing something here - but am not sure what it is. So
> I'd appreciate is very much if someone could help!
>
> TIA
>
> Vinay
>
>
>
>
>
