Multiple, independent detail sets?

• Larry Stein

  Default port

  Points: 1447

  More actions

  May 24, 2004 at 1:10 pm

  #108434

  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

• ColinSlack

  SSC Veteran

  Points: 270

  More actions

  May 27, 2004 at 4:31 pm

  #508092

   

  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