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