Hi,
I created a report that needs to be run for multiple costcenters. I defined a parameter type static. While executing the report, when I specify the value as 1234-123, 2356-233 or '1234-123','2356-233' the report opens with the header but no data.
This is the query
where TDATASEG.PERIODKEY between ~STARTPOVPERIOD~ and ~ENDPOVPERIOD~ And Tpovcategory.Catname='Actuals' and Entityx in (~costcenter~)
When I specify just one value for the parameter like 1234-123 the report opens fine. Also if I hardcode the costcenters in the the query as "Entityx in ('1234-123', '2356-233')", the report opens fine.
When I look in the logs, it shows the below. Not sure what is wrong.
AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.reporting.model.util.ReportManager] [SRC_METHOD: returnValidatedQueryForUI] Query:null[[
where TDATASEG.PERIODKEY between ? and ? And Tpovcategory.Catname='Actuals' and Entityx in ( ? )
order by Tdataseg.Account
Regards,
RR.