Hi,
I have two scheduled reports created in cognos 8.4 version, both reports are saved in HTML format.
Both the reports are generated by native SQL.
There is a drill through path defined in the first report but it seems passing parameter from one saved report output to another saved report output is not possible. During drill through the second report output shows all the data without applying the filter.
Properties that are set in the drill through..
Action: View Most recent report
Display prompt pages: Only when the required parameter are missing
Parameter Properties:
Method: Pass data item Value
Value: <Name of the field>
Property to pass: Default
Please let me know if it is possible? If yes, what properties I have to change.
Hi checked all the option again one by one and it seems that the whole saved report output will be shown (the option also says 'View most recent report'..) and I think there is no mean to filter the data of 'most recent saved report output while doing the drill through. If someone has sort out this problem before and able to filter the data of saved report while drilling through to 'View most recent report', please let me know..