Multiple, independent detail sets?

  • 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

  • This was removed by the editor as SPAM

  •  

    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