ReportServer Forum

ralex

Member

Registered: 2015-04-20

How to see the query produced by a birt report

Hi,
I need to troubleshoot a query produced by a birt report.
I looked at catalina.out, but I can't see the query.
Do you know how to find this information?

Thanks,

Alex

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: How to see the query produced by a birt report

Hi Alex,

that is not easy since BIRT composes the query internally and does not invoke ReportServer for the execution. One option would be to look at your database, they usually provide query logging capabilities.

Cheers,
Arno