Saturday, January 19, 2013 4:18 AM
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.
CAR_ID, MODEL, COLOUR
100, BMW, BLUE
200, MERCEDES, RED
I want Page 1 of my report to look like this:
CAR REPORT - Page 1
CAR REPORT - Page 2
Saturday, January 19, 2013 4:09 PMYou need group by each ROW and page break at end of each section option.
Saturday, January 19, 2013 6:49 PMI 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 AMModerator
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:
Then add a page break for each CARID. For more information about it, please see:
If you have any questions, please feel free to ask.
TechNet Community Support
- Marked As Answer by Charlie LiaoMicrosoft Contingent Staff, Moderator Friday, January 25, 2013 3:27 AM
Friday, January 25, 2013 4:14 AMThanks for your response Charlie, appreciate it :)