Last post May 25, 2015 11:22 PM by Edwin Guru Singh
May 25, 2015 09:26 AM|Emad khan|LINK
Hi ! Can you please tell me how can i generate report in this format ?
In this image the food and drinks would be a parent group and inside it the names will come. Also the header including Food , Participants , Address and the line below address will be repeated in each page. Please tell me how can i group like this format
? Please note i dont want + and - expand and collapse here.
May 25, 2015 11:22 PM|Edwin Guru Singh|LINK
In this image the food and drinks would be a parent group and inside it the names will come. Also the header including Food , Participants , Address and the line below address will be repeated in each page. Please tell me how can i group like this format ?
1.Concatenate your columns "Food" & "Drinks" into another new column called "FoodItems" in dataset or your corresponding query
2.create one tablix & pull the data using the same dataset
3..Go to grouping panel >>Row Grouping >>right click on the Details group>> Group properties >>General tab>> Group on should be “FoodItems” click.
4.go to report layout and add sum function to numerical value If needed any calculation
5.create one more tablix using the same dataset
6.Preview the report. you can see first tablix showing summary data and second tablix showing detail data
7.Go to Report layout >> first tablix>> right click on left most of the row >> Insert row>> Insert Group below
8.Merge the cells of newly created row
9.Right click on the second tablix, copy and paste on newly created row of first tablix. you can remove column as it is already available in first tablix.
10.For better visibility, we can add drill down also. For adding drilldown, right click on the row where second tablix is pasted>>Row Visibility>>Change the display option – When the report is initially run to “Hide” and display can be toggled by corresponding
textbox and click ok.