Possible to display 'Show SQL Query ' in CR XI?

[Jimdeb03]

Is it possible to display any database information on the report?
All I really need is to display on the report what's found under Database/Show SQL Query but virtually anything in Database Expert would be ok.

Are there functions that make this possible?

I'm using Crystal Reports XI 11.0.0.895

Jim

 

[lbass]

You could insert a static copy of the Show SQL Query into a text box, or you could display the record selection formula (special field), or you could export the report definition, and paste a copy of that into a text box. Another option would be to take a screen shot of the Show SQL Query screen (or the linking expert) and paste that into the report header. This would be static, though, too.

-LB

 

[Jimdeb03]

So in other words, there is no way to dynamically display any database connections on the report. Sometime the reports would get their data from a development db while other times live.
Hard coding wouldn't be practical.

 

[lbass]

I'm not aware of a way to do that. You could check to see if there are any likely functions in the SQL expression editor.

If your report was based on a command, and if you set up the database as a parameter within the command, then you could display the parameter on the report, and you would have a dynamic display of the database used.

-LB