Hi Guys,
I have an issue with one of my reports below are all the details. Any help/ Suggestions will be helpful, Thanks
Detais:
I have a dashboard which contains 4 portlets and each portlet is assigned to a specefic report. out of the these 4 reports i have one report (refered to as master report) which contains 2 Value Prompts, and the other three reports just has optional parameterised filter. Now on the dashboard page i have these reports running in the portlet viewer. The requirement is when i select a value from the master report all the other reports below should run for the selected values. We call this a Global filter. The problem is when i select the value from the master report all the other reports below run for that selected value as they are supposed to but the master report gives me this error.
ERROR: InvalidXPathException: Invalid XPath expression: ./parameter[@modelItem='if ([Division] <> ' ') then ([Division]) else ('All')' and @channel='uniquep'] Unexpected ') then ([Division]) else ('
but when i run the report by itself without having it communicate with another portlet it runs fine without any problem. if you look at the error it says invalid path expression and goes on to where it says... [division]....('All'), this is the expression i am using in the master report.
I have a query in which one of the data items are using this expression and this data item is being used by the prompt , the reason is because when the value prompt is not equal to any value or a value called All it should return me data for all the values in the prompt.
and it says another thing in the error called "channel = 'uniquep'" this is the channel name i am defining...
the report works fine when i run it by itself or on the dashboard where i am not having it assigned to a channel to pass values.
The problem starts when i assign a channel to this report so the values can be passed to other reports...
Thanks guys for reading this...
Try selecting the choice that says 'Portlets not using a channel' rather than assigning a channel name.