If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

A special drill-trough

Started by pw, 20 Dec 2005 06:35:04 AM

Previous topic - Next topic

pw

Hi ppl,

i know, a lot of threads have been solved concerning drill-through problematics... i searched and read them, but anyhow nobody seems to have the same problem as i do :-)

This is what i want to:
In out reporting system, our reports are called via URL with Parameters for the Reports: like &p_<Param>=<value>. This works fine.

in a report, which is filtered by one parameter with more then one value, is a crosstable.  In this crosstable, i want one column to be a drill-through column. The report behind has two different parameters, one of them is the drill-through column-value, the other one should be the Parameter, the parent report has got.

Is there any possibility to solve this?

REPORT 1
------------
param 1 (values e.g.: A,G,H,K)  <---- this comes via URL Parameter!


CROSSTAB:
param 2 (values e.g.: X1,X2,X5,X6)


REPORT 2
------------
gets param 1 and param 2!



So how to pass a parameter via 2 reports? :-)


Thanks in advance,
cheers and merry x-mas
pw

bdybldr

pw,
To my knowledge, there is no way to pass multiple values in one parameter using the drill-through functionality.  This is because, when you define your drill-through links, the only operator you can use is "=" (?parameter1? = [field1]).  Not sure how this works using a URL but this is how Report Studio behaves with drill-throughs.

You can pass additional parameters from the parent to the child report but they must be query items in the query of the parent report or parameters in the parent.

I hope this makes sense.  Can you provide more specifics regarding your issue?