preview/print query with substituted parameters

[arianhojat]

I was wondering if there was a way to preview the query ireports runs. like maybe somehow make it print to the log?

 

I have a query that should show some results but it doesnt so not sure why. Maybe parameters arent being correctly prepared.

[svenn]

No it does not. There are a few things you can do.

 

1. Run the query directly in a query tool to see if it brings back valid data.

 

2. Set the reports properties for when there is no data to "All sections, no details". Then put controls in the header or title section that contain you parameter values. This will tell you if your parameter are getting passed to your report and what values they contain.