I have an weird issue with drill-through on one of my reports. When I drill-through I get no data where there should be data, when I click finish on parameters page I get data. All of the parameters are passed correctly. My question is how is it possible that I get no data after drill through and then without changing anything there is data after clicking on finish?
I have other reports, almost same as this one, where I setup drill-through in same way and everything is working as expected. If anyone have any idea what may be wrong I would be very grateful.
Quote from: Ludijak on 14 Apr 2022 02:42:22 PM
I have an weird issue with drill-through on one of my reports. When I drill-through I get no data where there should be data, when I click finish on parameters page I get data. All of the parameters are passed correctly. My question is how is it possible that I get no data after drill through and then without changing anything there is data after clicking on finish?
I have other reports, almost same as this one, where I setup drill-through in same way and everything is working as expected. If anyone have any idea what may be wrong I would be very grateful.
Hi,
What exactly do you see when you drill through? Do you end up on a report page with no data in the target report, or do you see a prompt page in the target report? Or something else?
Is this an authored drill-through (ie you have explicitly defined the drill-through definition in the source report) or is it a package-based drill-through (ie set up from the portal under New > Other > Drill Through Definitions)?
Cheers!
MF.
Hi,
I see prompt page in target report with all parameters passed from source report as expected, and bellow in results i have No data message. When I click Finish without any change in parameters on the prompt page on target report I get results as expected.
It is authored drill-through.
Quote from: Ludijak on 15 Apr 2022 02:44:31 AM
Hi,
I see prompt page in target report with all parameters passed from source report as expected, and bellow in results i have No data message. When I click Finish without any change in parameters on the prompt page on target report I get results as expected.
It is authored drill-through.
I would be looking carefully at your target report to see if you have any errant parameters that are optional and not getting passed. Then look at the drill-through definition in the source report to make sure everything the target report needs as a parameter is being passed correctly. I would normally suggest using the drill through assistant to check what is being passed from source to target, but I don't see an easy way to get to this using the interactive report viewer. An alternative would be to add layout calculations showing each parameter in the target report - you could use paramvalue and paramdisplayvalue to make sure you're passing exactly what you need.
Cheers!
MF.