Drill through with parameters

[Al]

Hi,

Say I have two reports, one that is a list of companies and one that is a list of staff, from the company report I want to click one of the rows and open the staff report to show all people in that company. I have got the click action working fine ie. I can run the staff report by clicking a company name but I can't figure out how to filter the data.

I would imagine that the staff report needs a parameter "company" that would get passed to it when a company is clicked but I can't see how to do this - is it possible?

[Al]

I managed to get this working - I see now that I needed to use "Edit Parameters" on the "Load report from"  "Url or File" on the calling/main report and then set the parameter according to the parameter name in the called/child report.

[Al]

Is it possible to do drill through with the html report viewer?

I've got the drill through working in the designer perfectly but I don't see any option when viewing the report in the html viewer:

<div class="fcontainer" style="height:100%;">
    <telerik:reportviewer
        ID="reportViewer1"
        Width="100%"
        Height="100%"
        runat="server">
        <ReportSource IdentifierType="UriReportSource">
        </ReportSource>
        </telerik:reportviewer>
</div>

[Katia]

Hi Al,

All report's actions are supported when viewing the report in HTML5 Report Viewer. An example of NavigateToReport Action working as expected in HTML5 Report Viewer can be found in Telerik Reporting installation folders:
[installation folder]\Telerik\Reporting [version]\Examples\CSharp\ReportLibrary\ReportCatalog - report
[installation folder]\Telerik\Reporting [version]\Examples\CSharp\Html5Demo - project with the viewer

If the issue persists you can attach a sample project reproducing it in a support ticket so we can review it locally.


Regards,
Katia
Telerik by Progress

[Al]

Hi Katia,

My report does not even show the 'hand' icon to indicate that the data is drillable + clicking or double-clicking the detail does nothing (in the report designer the clickthrough is fine) - is there something I need to do to enable this?

I am using a custom reports controller, not sure if that makes any difference as the reports are running ok, just the drilldown is not working, it's as though it's not enable

[Katia]

Hello Al,

No additional setting are required in order to enable the action in the viewer. 

If you are using custom report resolver, check what modifications are applied to the report inside the Resolve() method.

As this behavior is not reproducible with our demos, we would need to check a sample project that reproduces it (you can attach it a support ticket).


Regards,
Katia
Telerik by Progress

[Al]

Thanks, I'll log a ticket with a sample project