In a query I created several data items.
For example name of item1 : departmentname1
expression : if(left(number;1) is 1 then(number.value) else (0)
name of item2 : departmentname2
expression : if(left(number;1) is 2 then(number.value) else (0)
Every department has a column in a report, columnheading is the name of the item
Now i want to use this itemname as a drillthrough- parameter to drillthrough to another report.
In this other report I have a prompt, presenting the same departmentnames, for selecting the right values/records again another value is used.
When I passthrough the columnname I get an error message, or the value isn't recognized
Please help me with this problem
TIA
By the way: is there a possibility to passthrough an individual value ???
You should create a few required text box prompts on this report, each with its own parameter name (that of a department), set the default values of these prompts to department names you want to pass.
Then hide the prompts by setting visible property to 'no' and box type to 'none'. Depending on your editor settings you might not see them, unless 'see hidden objects' is enabled.
When setting up your drill-through links to the second report, pass the data to the target report from the parameter of the same name (not data source).
You can also make data items in the query with specified text ('Dept #2') and pass that.