Last post May 25, 2015 01:03 AM by Edwin Guru Singh
May 18, 2015 09:05 PM|PhC|LINK
There is a table components to show data in a table format. We want to show record details (just like form view in .net) after clicking the record id in the table. However, we cannot find a component can show record in a form view. Is there any method to
show the record in form view? Similar to table, set dataset, then click cell to assign its field?
May 25, 2015 01:03 AM|Edwin Guru Singh|LINK
Is there any method to show the record in form view? Similar to table, set dataset, then click cell to assign its field?
1.create one tablix & pull the data using the same dataset
2.Go to grouping panel >>Row Grouping >>right click on the Details group>> Group properties >>General tab>> Group on should be “columnname” click.
3.go to report layout and add sum function to numerical value
4.create one more tablix using the same dataset
5.Preview the report. you can see first tablix showing summary data and second tablix showing detail data
6.Go to Report layout >> first tablix>> right click on left most of the row >> Insert row>> Insert Group below
7.Merge the cells of newly created row
8.Right click on the second tablix, copy and paste on newly created row of first tablix. you can remove country column as it is already available in first tablix.
9.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.
for more information,
Click here to refer.