Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dineth
Starting Member
6 Posts |
 Posted - 2005-03-19 : 23:35:27
|
Hi ,I want to generate a report as follows;I have 2 datasets , according 2 stored procedures in the database.First dataset returns a result set(rows) with a filed value Emp_ID.Then for each row I want to pass this Emp_ID value to the second dataset as parameter ( hence to the stored procedure) and then retrieve the results and disply them in the same report.( the template that I want to display is attached as a image- basically one column of the enclosing structure should contain tables for each row)![]() I tried to some extend, but faield. Is this possible.ThanksDineth |
|
|
Dineth
Starting Member
6 Posts |
Posted - 2005-03-19 : 23:40:16
|
 |
 |
|
|
XericCoder
Starting Member
12 Posts |
Posted - 2005-03-21 : 10:06:30
|
| I've achieved this functionality with a subreport. Not sure if that would apply to your situation and I bet there are other ways(although I didn't find one) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-21 : 11:59:31
|
| Can't see your image...just post the URL to the image so that we can see it. If it's only on your local machine, then only you can see it.Tara |
|
|
|
Dineth
Starting Member
6 Posts |
Posted - 2005-03-22 : 00:55:51
|
| Hi,sorry for not displaying the image..I resolved the problem I had. Rather than having 2 Data Sets , I had one dataset and stored procedure and then.. I group the column.in the report designer table.Thks |
|
|
|
|
|
|
Dataset Filed as a input parameter