Click here to Skip to main content
11,566,149 members (53,447 online)
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 5: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


Advertise | Privacy | Mobile
Web03 | 2.8.150624.2 | 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