I need to create report which fetches data from more than 5 tables,
First i created 1 data set and fetches only 1 field and need to pass this value to next dataset which i could not do it.
so i used a stored procedure in which first i created a cursor where i fetch only 1 field and pass it to the next query . the problem is that in the second query i used join to get value from multiple table , where i execute the query in sql query window i will get more than 5 record for some input value from query1, but when i access the stored procedure through SSRS i will get only 1 record(i mean 5th one )
please sort out this issue