Drill-through not working as expected

[Ludijak]

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.

[MFGF]

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.

[Ludijak]

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.

[MFGF]

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.