Click here to Skip to main content
13,055,884 members (49,924 online)
Rate this:
Please Sign up or sign in to vote.
See more: (untagged)
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
Posted 24-Oct-11 5:29am
Marc A. Brown 24-Oct-11 11:46am
You need to provide more information if you're expecting to get any helpful answers. You should also tag your question better.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 24 Oct 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100