This is a migrated thread and some comments may be shown as answers.

Drill through with parameters

6 Answers 40 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Al
Top achievements
Rank 1
Iron
Iron
Veteran
Al asked on 04 Nov 2016, 01:09 PM

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?

6 Answers, 1 is accepted

Sort by
0
Al
Top achievements
Rank 1
Iron
Iron
Veteran
answered on 04 Nov 2016, 01:41 PM
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.
0
Al
Top achievements
Rank 1
Iron
Iron
Veteran
answered on 04 Nov 2016, 01:50 PM

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>
0
Katia
Telerik team
answered on 04 Nov 2016, 02:42 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Al
Top achievements
Rank 1
Iron
Iron
Veteran
answered on 06 Nov 2016, 10:04 AM

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

0
Katia
Telerik team
answered on 07 Nov 2016, 04:41 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Al
Top achievements
Rank 1
Iron
Iron
Veteran
answered on 16 Nov 2016, 09:42 AM
Thanks, I'll log a ticket with a sample project
Tags
Report Designer (standalone)
Asked by
Al
Top achievements
Rank 1
Iron
Iron
Veteran
Answers by
Al
Top achievements
Rank 1
Iron
Iron
Veteran
Katia
Telerik team
Share this question
or