Hi Gurus
I have 2 dynamic columns on my report that are based on the Chart category attribute and Chart Series Attribute variable prompts.
The columns change dynamically based on the prompt value selected.
Problem:
When I drill down on No. of Work Orders, the detailed report does not pick up the filters as it would on the normal circumstances. it returns all results instead.
Example
Summary report has 3 records and I drill down the 1st record and expect 2 records on the detailed report.
The detailed report return all results instead of 2 records.
Column expressions for the summary report:
Category Attributes:
CASE '@{varCategoryAttribute}'
WHEN 'Supervisor Department' THEN "Supervisor"."Supervisor Department"
WHEN 'Manager' THEN "Supervisor"."Manager Position"
WHEN 'Supervisor' THEN "Supervisor"."Supervisor"
WHEN 'Work Order Location' THEN "Work Order Location"."Work Order Location"
WHEN 'Functional Location' THEN "Work Order Location"."Functional Location"
WHEN 'Report Location' THEN "Work Order Location"."Report Location"
WHEN 'Asset Number' THEN "Asset"."Asset Number" END
Series Attribute:
CASE '@{varChartAttribute}'
WHEN 'Reported Week' THEN "Date (Report Date)"."Week No"
WHEN 'Work Event' THEN "Work Order Event"."Work Order Event"
WHEN 'Status Category' THEN "Work Order Status"."Work Order Status Category"
WHEN 'Work Order Status' THEN "Work Order Status"."Work Order Status"
WHEN 'Call Out' THEN "Call Out"."Call Out Description"
WHEN 'Overdue' THEN "Work Order Details"."Overdue"
END
I've made the 2 columns to be is prompted on the detailed report in hope that it would pick up on the filters.
I hope I'm clear, Please assist.
