Hi,
I have a report (Report A) through which i drillthrough to another report (Report B). Some of the parameters i am passing for Report B is not in the layout of Report A but present in the Query.
I included all the necessary Data items for the crosstab column on which i drilthrough to Report B using the properties option.. Now my problem is the paramaneters are not passing to the Report B. When i display the parameters using ParamValue('paramenternam') iam geting NULL values.
I am wondering if we have to pass any data items for drillthrough is it mandatory to have the parameters in the report layout.
I am using Cognos 8.4
In Report A, select the list object and go to the Properties property. Check the items in the query which you want to pass but are not displayed in the report.
Does this fix the problem?
Regards,
MF.
Hi,
I am facing similar issue. My parent report is crosstab and I am drilling through to list report. One of the dataitem which I am passing to child report is not present in crosstab(parent) layout. Does cross tab have properties option to check the required dataitems?? What is the other way of passing this values?
thanks in advance.
Cheers
Mrcool
You can select properties on the column and row nodes of the crosstab.
Thank You Paul.
Quote from: mrcool on 01 Nov 2010 08:16:49 PM
Hi,
I am facing similar issue. My parent report is crosstab and I am drilling through to list report. One of the dataitem which I am passing to child report is not present in crosstab(parent) layout. Does cross tab have properties option to check the required dataitems?? What is the other way of passing this values?
thanks in advance.
Cheers
Mrcool
I also had the need to pass a static value from my parent report crosstabs to a detail list report (2 crosstabs, 1 to drill to detail based on the specified Date Range, and 1 for a Single Month). I created 2 data items in my query, each with a static value (i.e. 'DateRange' and 'SingleMonth') then for each of the 2 crosstabs, drag the appropriate static data item into the crosstab heading nesting it just above the crosstab fact cells. Set the Box Type property for this new heading to 'None' to make it hide. Now the static values are passed to the detail report! In the detail report, I render only of my 2 report pages (either the DateRange page or the SingleMonth page). Previously, I was not getting any errors, but could see that the value being passed was a NULL value.