Table field Action - show additional details based on the clicked row

[Paul]

I created a report which shows a list of customer.  I currently have an action to Navigate to Report: CustomerDetailsByAccountID report and this is ok but takes me to a new page and when I click the back button the page is refreshed so I lose my position and need to scroll down to find my last position in the table.

Ideally, I would like to do either of the following

[1] When I click on a table row, I would like to expand the table row to the next row below to show more details directly below the row I clicked on.  Bearing in mind this table could be quite long and showing the relevant info int he same location without scrolling would be the ideal scenario.

Is this possible using Report Designer?

[2] Alternatively, I could click on the Table row and pass the AccountID to a subreport on the same page (at the top - see attached image).  But for some reason, I cannot find how I would pass the AccountID from the table row clicked on to the subreport at the top of this report.

At the moment, navigating to a report seems to be the only option but is not convenient.

Thanks

[Neli]

Hi Paul,

You may use Drilldown Report Action which allows you to control whether a report item initially displays or is hidden when a user views a report. To define a action add a ToggleVisibilityAction on an item. Use the DisplayExpandedMark property to determine whether the item exposing the action will be rendered initially with expanded or with collapsed mark. 
You may check our demo report Product Sales where the approach is demonstrated. The Standalone designer version of the report can be found in (Telerik Reporting installation folder)\Report Designer\Examples. The CS/VB report is in the ReportLibrary project in (Telerik Reporting installation folder)\Examples\CSharp (or VB).
The alternative with subreport at the top of the report is not possible because from a report item (e.g. TextBox in a Table) you cannot access the properties of the SubReport to modify its ReportSource (i.e. passed parameters). This may be achievable with a Custom Action though.

Regards,
Neli
Progress Telerik