locked
Show record in form RRS feed

  • Question

  • User-1466065877 posted

    Hi,

    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?

    Many thanks.

    Monday, May 18, 2015 9:05 PM

Answers

  • User1711366110 posted

    Is there any method to show the record in form view? Similar to table, set dataset, then click cell to assign its field?

       According to this case , I suggest you to create tablix inside a tablix in ssrs which may help you to fulfill your requirement

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, May 25, 2015 1:03 AM