use column name for drillthrough

[john234]

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 ???

[DanSev]

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.