February 22, 2010 at 3:40 am
hi,
I have some problem to use two Dataset for single report.
my first table contain organization detail this data will be display into header area,
2nd table contain details of employee that display into detail area in table.
but these two tables don't have any relation.
if any one already work on it then plz give me suggestion on this problem.
Thank you
February 22, 2010 at 7:25 am
Is the data coming from one database? If so, then the best solution, in my opinion, is to bring all the data in one dataset and use the grouping capabilities of SSRS to display the parent-child relationship.
If you have to use 2 datasets, I think you could use 2 tables, a master table with the organization data and child table (placed inside a row of the master table) that has the employee data. The child table would have to have a filter on it that uses a column in the master table.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply