i go for two subreport becoz of two result sets?
-
Hi All,
I have a report say for example which is used to display an employee detail , it is grouped by employee name.
grouped:Employeename Address DateofBirth
detail: inservice date
i have a stored procedure for it.
which gives you two result sets.
so i thought of going for sub report because its not possible to retrieve the second result set in a single dataset. it happens in the query part but not in Business Intelligence i dont know what to do with that....
so in sub report i ran a query which gives the second result set.
but it should be based on the first one
for example in the above sample which i have given i will get some 1 or 2 inservice dates for a single employee...
but to retreive this i use another query (i.e. second result set) in a sub report and it should be based on that particular employee....
ie for an employee based inservices date
employee is grouped
i want to know where to group either in main report or in sub report
or else do we have any option to retreive the second result set?
any body to help me please!
cracking my head....getting mad....
-
If I am understanding you correctly, I'd denormalize the results and then use grouping in the report to accomplish what you want. I am slightly confused though. Do you have multiple inservice dates for a single employee?
Oh, and by the way, you have quite a few duplicate threads which you might want to clean up.
-
Yes Mr.David
I have multiple inservice date for a single employee
Please help me!
regards
Thiyagarajam(Priya)
-
Then just denormalize it. Join the tables together and create a group on employee in the report itself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply