Multiple Values in Single Parameter wont work

[vinonline85]

Hi All,

I'm trying to pass multiple values through a single parameter to a Drill-through report which doesn't work the way I expect. Let me explain the issue. Need someone's guidance on this.

From the "Source Report", I need to Pass multiple "Order Numbers" through a Drill-Through Parameter to the "Target Report". However, I need to refine/filter the "Order Numbers" based on a certain condition, say, "Order Numbers" which are of a specific "Order Type"

Now I don't know how to filter the "Order Numbers" before passing them through a Parameter to "Target Report" ?

I've tried creating the filter at the "Target Report" end, which is not making any difference.

Please help.

Thanks,
Vino

[Prerna Chaudhary]

Hi.

May be you can just try passing the order type  as a parameter and then have the order number as a column in your target report.

for ex: say source report has a column order type and a parameter created as ?order_type?

Target report will have columns as order type and order number.

So you just need to pass ?order_type? as the parameter, so in your target report you will only get to see the order numbers pertaining to that particular order type.

Regards
Prerna Chaudhary

[vinonline85]

Thank you Prerna. However, I cannot have "Order Type" column shown in "Target Report". Also, I'm trying to pass a Data Item Value (Order No) which is a column in the "Source Report". Or is there a way that I can have the "Order Type" column in the Target Report, but hide it when running the report ? FYI.. The target report is a CrossTab report.

Please let me know if you need more information to help on this.



Regards,
Vino

[Robl]

You can have order type as a filter that doesn't need to be shown in the report.

Are you working with relational or dimensional data?
If it's relational then it's just a simple filter.