May 24, 2004 at 1:10 pm
Is there a "good" way of handling headers with multiple, independent details in Reporting Services? For example: generate a list of employees with the names of any dependents and any days-off taken. The query is not a straight equijoin as there may or not be family members and/or days off.
I can certainly create a UNION query forcing the 3 types of rows (e.g. 1 = employee, 2 = dependents, 3 = days off) together in a "single" query. I might be able to create multiple subreports. What options are there in reporting services?
A sample report might look like:
EmpId Name
123 Schmoe, Joseph
Dependents Days Off Taken
Schmoe, Josephine Spouse 1/1/2004
Schmoe, Jehosephat Child 1/2/2004
2/14/2004
124 Dorfman, Fred
etc...
Thanks,
Larry
Larry
May 27, 2004 at 8:00 am
This was removed by the editor as SPAM
May 27, 2004 at 4:31 pm
Hi Larry,
I had a simlar report to build, it listed school id, family name, family members, current balance, then 30days, 60days ect ect.....
not all fields had data, some had 2 or 3 family members.
I created a RS Matrix to display the data.
Hope this helps.
Col
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply