Drill through problem

[erics]

Hi there,
I've inherited some code, and some of it is dubious.
One of the things that I inherited was a report that does a drillthrough for more details.
I've written another report, but would like to reuse the drillthrough.
The child report is supposed to receive a numeric value equivalent to YYYYMM (201503).
I've added a calculated field to my query to calculate max and min period. When I send that value, the child report does not seem to receive it (I'll put layout calculations on the screen, and they don't contain the values that I sent in). I created the same calculated field, and gave it simply the value that I'd like to use as a test. Removed the rollups, aggregate, and such. But I get the same results. Value is sent from Parent to child, but child does not reflect these values.
I then created a parameter, and that worked perfectly with the same values that I just tried sending as a data item.

Has anyone seen this issue before? And any idea how to fix it?

Thanks,
Eric

[MFGF]

Hi there,
I've inherited some code, and some of it is dubious.
One of the things that I inherited was a report that does a drillthrough for more details.
I've written another report, but would like to reuse the drillthrough.
The child report is supposed to receive a numeric value equivalent to YYYYMM (201503).
I've added a calculated field to my query to calculate max and min period. When I send that value, the child report does not seem to receive it (I'll put layout calculations on the screen, and they don't contain the values that I sent in). I created the same calculated field, and gave it simply the value that I'd like to use as a test. Removed the rollups, aggregate, and such. But I get the same results. Value is sent from Parent to child, but child does not reflect these values.
I then created a parameter, and that worked perfectly with the same values that I just tried sending as a data item.

Has anyone seen this issue before? And any idea how to fix it?

Thanks,
Eric

Hi,

Adding a value to the query of the source report is not sufficient to ensure it gets passed as a data item when a drill-through occurs. The item has to be included in the object you are drilling through from to be passed (since you are clicking on a value or intersection of values to pass). Try adding the value to the crosstab/chart/list you are drilling from and see if this fixes the issue.

Cheers!

MF.

[erics]

Hey MF,
So, I have a bar chart with the monthly sales totals for the past year.
What I'm trying to do is that if we click on the bar chart, it open a child report that already exists for the past year.
The issue is, the way that he original report is written, it's supposed to receive starting and ending month, and run the report based off of those values.
As part of my query, I've added two calculated fields. Initially, they contained the date field and one had aggregate and rollup set to min, the other to max. When that didn't work, I set the calculated fields to hold maximum(date) and minimum(date). When I tried to just pass those fields, it didn't work.
I tried your suggestion of having them be series on my chart. Problem with that is though, when I do, it always sends the value of the month clicked. I want to send first and last month. Also, this gives me an extra two bars that I don't want in my report.

Eric

[MFGF]

Hey MF,
So, I have a bar chart with the monthly sales totals for the past year.
What I'm trying to do is that if we click on the bar chart, it open a child report that already exists for the past year.
The issue is, the way that he original report is written, it's supposed to receive starting and ending month, and run the report based off of those values.
As part of my query, I've added two calculated fields. Initially, they contained the date field and one had aggregate and rollup set to min, the other to max. When that didn't work, I set the calculated fields to hold maximum(date) and minimum(date). When I tried to just pass those fields, it didn't work.
I tried your suggestion of having them be series on my chart. Problem with that is though, when I do, it always sends the value of the month clicked. I want to send first and last month. Also, this gives me an extra two bars that I don't want in my report.

Eric

Hi,

I see your predicament. I wonder if the simplest option here is to have the months in your chart nested within the year, and pass the year value to your target report? It would mean changing the filter in your target to accept the year rather than the start and end months, though.

Cheers!

MF.

[erics]

Is there a way of assigning a value to a parameter?
If so, I can hardcode the values that I want to send, and use one of those values to tell the child page to simply give us the last 12 months of data.

Eric

[MFGF]

Is there a way of assigning a value to a parameter?
If so, I can hardcode the values that I want to send, and use one of those values to tell the child page to simply give us the last 12 months of data.

Eric

In theory, you could add a prompt to your report page of your source report, driven by a prompt macro expression with a literal default value eg #prompt('Your Parameter','token','The literal value you want to send')# then hide the prompt so it's never visible to users running the report. You then ought to be able to pass the parameter via a drillthrough.

Cheers!

MF.