Post reply

Report with 2 tables per page grouped on same data

  • June 24, 2021 at 8:39 am

    #3899991

    hi all

    looking some advice on the best approach on designing a report in Report builder where each page of the report should have a group header table and then the detail table linked to the data above it, with the column headers of each repeating on each page for the new information. in crystal i could simply have group header page sections etc and it seems much easier to do - no doubt i am just looking at this wrong!

    on each page I want the below split into 2 tables, or at least what appear to be 2 tables

    ssrs inv

     

    Invoice Number     OrderNum

    89841                        60478

     

    and then

    Sales Code             Selling Ship Qty

    asdasd                          656

    dads a                         65

     

    anyone got any tips ?

    thanks

     

    mal

     

    • This topic was modified 3 years, 3 months ago by  dopydb.
    • This topic was modified 3 years, 3 months ago by  dopydb.

  • June 25, 2021 at 9:10 am

    #3900350

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • June 25, 2021 at 12:39 pm

    #3900410

    I am sure you can do this using sub-reports, you would send the Invoice Number or Order Number value through to the sub-report.  I'm also sure you could do this using Groups within the Tablix.

     

     

  • June 28, 2021 at 3:59 pm

    #3901266

    yes sub reports i am having some luck with now (been really restricted in what i can do due to fixed datasources etc from an ERP)

    just needed to take the time and do some reading up!

     

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply