display generated select statement

[hlauwers]

Using Crystal Reports 8.5, how does one display the select statement CR will generate to retrieve data from the back-end?

 

[lbass]

You can either go to the field explorer->special field and drag "Record Selection Formula" onto the report canvas, or create a text box and then go to database->show SQL query->copy the SQL statement->paste it into the text box. You need to format the special field or the text box with "Can Grow" (format field/text->common->can grow).

Note that in 8.0 the special field "Record Selection Formula" is sometimes truncated for longer formulas, so may not work for you.

-LB

 

[hlauwers]

Second method worked, thanks.