Drill through target not accepting date promp

[syedshah]

hi all,
I have created a filter in the target report as [run date]=?executed_at? . I have set the drill through definition in the source report and assigned the passed data value to this filter. I have some other filters too and they are working well. However, when i drill through from the source report to the target, instead of accepting the data parameter form the source report, the target report opens a data calendar and asks me to select the data. I want this report to accept the parameter from the source report. This report is accepting other filters from the source report but the data filter is not working. Can someone please help me out in this.

[MFGF]

Hi,

It sounds like the source report is not passing an appropriate date.  What kind of package is the source report based on - dimensional or relational?

There is a simple thing you could try which might help you understand better what's going on - define a layout calculation in the page header of your target report with the expression ParamValue(?Your Date Parameter?)

This should show you what value is being passed as the date parameter to the target report.

Regards,

MF.

[syedshah]

Hi,
I really appreciate that quick and informative response. Thanks a lot

actually i am drilling down from a chart to a list. The list in target has four parameters.
1) ?application? 2) ?phase? 3) ?executed_at? 4) ?run flag?

The chart in source has two of the above parameters as its series and x axis. The other two values (date and run flag) is being calculated in the query behind the chart, but is not being used in the chart. Now what i have noticed is that the two parameters 1) application 2) phase is being accepted while the other two 1) executed_at 2) run flag are not being accepted and instead the target opens prompts for these two values to be entered

Does this mean i can only send the values as parameter, which is being used in the chart? and whe cannot send the other fields from the query if they are not being used?

[MFGF]

Hi,

Is this in ReportNet or Cognos 8?  I'd suspect the latter, given the behaviour you describe.  In Cognos 8, items defined in a query are not used at runtime by default if they are not required to render the page, in order to minimize queries as much as possible.  This behaviour can be overridden on an item-by-item basis using the 'Properties' property of the reporting object on the page (list, crosstab, chart etc).

Regards,

MF.

[syedshah]

Hello,
Thanks for the reply. I am using cognos 8.4. I can find the properties property of list, but when i click the chart (graph), then i cannot find the properties property of the chart. Is there some other property where i can override this behaviour.

Thanks
Arif

[MFGF]

Hi,

Click one of the chart axes, and you should see a Properties property.

Regards,

MF.

[syedshah]

excellent. It worked awesome. Thanks a lot.

Arif

[anthus]

Hi.  I have a very similar issue.  I am using Cognos 8.4.1 and have a chart with a drill thru to another report.  One of the data items (project) I need to pass to the drill thru report doesn't appear in the chart and isn't a parameter.   The item is in my query, though.  When I add this data item to the "properties" property of the Axis, it only passes one of the projects.  Any ideas?  The parameter on the drill thru side is an "in" filter.

Thanks.....Anthus

[MFGF]

Hi,

Logically, it will only pass a single project value if you are passing it as a Data Item Value - think of it as you selecting a single row of data in the source report, and the drill-through passing the values stored on that row.

Are you prompting for project in the souce report?  If so, and you have multiple project items in a parameter in your source report, you could try passing the parameter instead of the project data item value.

Regards,

MF.