SQL Query is not visible in iReport
Posted on June 8, 2018 at 4:20am
Hi,
I have imported a .jrxml file in iReport 5.2. I can see the complete layout of that report with all related parameters but can't see the query behind that report.
That jrxml was created on older version, let me know if this is the reason or if we have any solution for this issue ?
Thanks
Himanshu.
Joined: May 24 2017 - 10:18pm
Last seen: 1 year 5 months ago
Posted on June 8, 2018 at 8:57pm
Hey Tiru,
Thanks but same result. .jrxml is also not shwoing query. I can see al the fields out there but not the query.
Joined: May 24 2017 - 10:18pm
Last seen: 1 year 5 months ago
Posted on June 8, 2018 at 6:17pm
Can you open the .jrxml file and check <queryString></queryString> tags. Do you see the Query there? If yes, then I would manually copy that over to the imported jrxml file as a workaround.
Joined: Oct 30 2017 - 12:56pm
Last seen: 3 days 4 hours ago
Posted on June 9, 2018 at 1:48am
Did you setup a Data Adapter for the query?
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago
Posted on June 9, 2018 at 2:23am
@Hozawa,
Is it needed? as I can see the query for other reports. If yes then let me know how to do it?
Joined: May 24 2017 - 10:18pm
Last seen: 1 year 5 months ago