Thursday, March 31, 2016

How to show one Record in different Rows within SSRS Report

i had been asked to generated a report that one record data will be spanned into couple of different rows.

here I will show a demo on how to implement this request.I use the customer table from the NORTHWIND database.

First  I had create a dataset to store data from Customer table



Second. add a table to report body.



third   add a Customer name to the first row.




four. create a parent group with group by CustomerID

 


five Select CustomerID from Group by dropdown List



we can remove the group by column if we do not need to show it in report. we select the column and
right click to show the popup menu. then click on the delete columns,  and select Delete Columns Only, then click Ok button.





five. add a row  Address field to the second row by selecting the CompanyName row, then right on it,

focus on the Insert Row menu item, then select Insert Group Below




six repeat the step five again to add city and post code field. do same for country, Now the report should look like the following




in the preview mode company name, address, city postal code, and country are from the same record, but there are in different rows.













No comments:

Post a Comment