Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSRS Report Builder 3.0 Page Breaks and Groups

Answered SSRS Report Builder 3.0 Page Breaks and Groups

  • Saturday, January 19, 2013 4:18 AM
     
     
    Sign In to Vote
    0

    Hi All, Hoping for some help on this in SSRS Report Builder 3.0. I know its simple and I have done it in Crystal, but have spent 2+hrs and still cant work out on how to do this.  My actual data is complex but for simplicity to explain my issue have created a Dataset in my main report for Cars.  I have inserted a sub report to display Car_Owners that links to the Cars Table on Car_Id.  All I want to do is display the car and the owner on separate report pages.

    CARS TABLE

    CAR_ID, MODEL, COLOUR

    100, BMW, BLUE

    200, MERCEDES, RED

    CAR_OWNERS TABLE

    CAR_ID, OWNER

    100, SCOTT

    200, JOHN 

    I want Page 1 of my report to look like this:

    CAR REPORT - Page 1

    Car: BMW

    Colour: BLUE

    Owner:SCOTT

    CAR REPORT - Page 2

    Car: MERCEDES

    Colour: RED

    Owner:JOHN

     

All Replies

  • Saturday, January 19, 2013 4:09 PM
     
     
    Sign In to Vote
    1
    You need group by each ROW and page break at end of each section option.
     
  • Saturday, January 19, 2013 6:49 PM
     
     
    Sign In to Vote
    1
    I dont see a need of sub report here, you can fetch the car details and owner detail in the same stored procedure, and on the report you can group the data by CAR or by any other field of your need and then do a page break

    Mark this post as answer if this resolves your issue.

    Everything about SQL Server | Experience inside SQL Server -Mohammad Nizamuddin

     
  • Monday, January 21, 2013 8:08 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Hi Scott,

    From your description, you want to display the car data in one tablix which come from two tables, right? If in this case, you can achieve this either by using join in the dataset or using lookup function in the tablix. If you use join in the dataset, then query would like:
    SELECT CARS.CARID, CARS.MODEL, CARS.COLOUR, CAR_OWNERS.OWNER FROM CARS JOIN CAR_OWNERS ON CARS.CARID=CAR_OWNERS.CARID

    If you use lookup function on tablix, the expression would like:
    =LOOKUP(fields!CARID.Value,fields!CARID.value,fields!OWNER.value,”CAR-ONWERS”)

    Then add a page break for each CARID. For more information about it, please see:
    http://www.w3schools.com/sql/sql_join.asp
    http://technet.microsoft.com/en-us/library/dd207058.aspx
    http://msdn.microsoft.com/en-us/library/ee210531.aspx

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    Charlie Liao
    TechNet Community Support

     
  • Friday, January 25, 2013 4:14 AM
     
     
    Sign In to Vote
    0
    Thanks for your response Charlie, appreciate it :)