I have report a with radio button filter with static values 'Current Month' and 'Previous Month' and default value is 'Current Month'.
This radio button prompt is in report page not in prompt page.
When I run the report report renders perfectly for 'Current Month'. But, When I am selecting 'Previous Month' the report is giving below error message.
XQE-QTE-0003 The transformation "V5QueryRelationalPlanningTransformationLibrary - SetDetailContextOfV5DataItem" was applied but did not modify the query plan.
I am using this radio button filter as below on the query:
DATE >=
(case
when
?param_month? = 'Current Month'
then
(case
when
extract (day ,current_date) = 1
then
_first_of_month (_add_days (current_date,-1))
else
_first_of_month (current_date)
end)
when
?param_month? = 'Previous Month'
then
_first_of_month (_add_months (current_date,-1))
end)
and
DATE <
(case
when
?param_month? = 'Current Month'
then
current_date
when
?param_month? = 'Previous Month'
then
_first_of_month (current_date)
end)
Thanks in advance
I think the issue is with repeater table. I am using two repeater tables in the report. These two repeater tables contains graphs.
When I deleted one repeater table from the report I am not getting the issue.