Click here to Skip to main content
11,641,717 members (64,436 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: from
      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 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 DamithSL 233
1 Mika Wendelius 150
2 Sergey Alexandrovich Kryukov 134
3 OriginalGriff 110
4 Afzaal Ahmad Zeeshan 89
0 Mika Wendelius 460
1 OriginalGriff 265
2 DamithSL 258
3 CPallini 169
4 Afzaal Ahmad Zeeshan 149

Advertise | Privacy | Mobile
Web04 | 2.8.150731.1 | Last Updated 24 Oct 2011
Copyright © CodeProject, 1999-2015
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