Nintex Connect

The Official Community Site for Nintex Software Products, including Nintex Workflow 2007, 2010 and 2013; Nintex Workflow for Project Server 2010; Nintex Reporting 2008 and Nintex Analytics 2010; Nintex Forms 2010; Nintex Live and Nintex SmartLibrary.

Welcome to Nintex Connect Sign in | Join | Help

Home

Forums

Downloads

Nintex Connect » Nintex Reporting 2008 » NR2008 General Discussion » Re: Drill Through on a custom report

Drill Through on a custom report

Last post 07-07-2009, 9:35 AM by Louis Liu. 1 replies.


	Sort Posts: Previous Next

06-30-2009, 11:22 PM 4814

ian
Joined on 06-30-2009
Posts 1

Drill Through on a custom report

Reply Quote

I hve created a custom report and enabled the drill through, the drill through points back at the same report. using the selected item as the parent Item when the user tries to drill through

When I run the report the first time it works correctly, however when I click on the drill through the page reloads, with the parameters set correctly but no data is returned.

I ran a SQL trace and when clicking on the drill down the Stored procedure associated with the report is not run.

Where should I start looking?

Thanks

Ian

Report abuse

07-07-2009, 9:35 AM 4942 in reply to 4814

Louis Liu
Joined on 10-12-2008
Posts 6

Re: Drill Through on a custom report

Reply Quote

Hi Ian,

The first thing to do is ensure that you include the proper <ReportDrilldownParameters> section in the report definition. It should contain the following information:

name,
field
value
ReportID

The field and value are mutually exclusive. ReportID is the report GUID of the drill-down report, which in your case will be the same GUID as the current report. e.g. <ReportDrilldownParameter name="SiteID" field="SiteId" value="" ReportID="9AC90F7C-C7CA-4B2B-8CF5-CA446A72EFA5" />

Also you may want to check the Reports table in the database and make sure the ReportRunnerStoredProcedure field contains the correct stored procedure name.

Regards,

Louis