Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: from
Hi,
      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 6:29am
Comments
Marc A. Brown at 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)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 575
1 Kornfeld Eliyahu Peter 409
2 Maciej Los 369
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,353
1 DamithSL 4,854
2 Maciej Los 4,476
3 Kornfeld Eliyahu Peter 4,058
4 Sergey Alexandrovich Kryukov 3,917


Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 24 Oct 2011
Copyright © CodeProject, 1999-2014
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