Author Topic: A special drill-trough  (Read 743 times)

Offline pw

  • Full Member
  • ***
  • Posts: 29
  • Forum Citizenship: +0/-0
A special drill-trough
« on: 20 Dec 2005 05:35:04 am »
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

Offline bdybldr

  • Global Moderator
  • Statesman
  • *****
  • Posts: 275
  • Forum Citizenship: +7/-1
Re: A special drill-trough
« Reply #1 on: 20 Dec 2005 06:48:09 am »
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?