Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Report WHERE Param is being replaced
Migrateduser
So I'm having a real odd problem. I have a report - one out of 70+ - that runs the WHERE param twice. To Explain:
A Birt report is build and uploaded to the system (maximo). The user does a search for their data then runs the report. The report looks at their search's WHERE clause and puts it into the BIRT report WHERE Param.
It then runs the report. But prior to printing, it reruns a second time, this time it replaces the WHERE param with the one used during the initial report build.
So, when building and testing the report, I used something generic like "workorder = '32000' and site = 'water'". The users' WHERE is being replaced with that.
I couldn't figure out why the print outs were only spitting out this one report. I put a track/log onto this report and discovered that the report runs correctly the first time, then reruns using the where clause used in building the report.
I hope that's not too convoluted. Bottom line, this is the only report that does this. I Can't for the life of me figure out why this is happening.
Find more posts tagged with
Comments
There are no comments yet