How to change the query of a crystal report file (.rpt)?

[Former Member]

I need to change the query of my crystal report file (.rpt) depending of a filter (where clause). How can i do this (change the where clause of my query)? (In the code behind)   Obs: i'm using crystal report 13, .net framework 4.0 and c#.

[former_member183750 · Accepted solution]

You cannot modify the SQL. Not since version 9 of Crystal Reports. Use the selection formula to filter your data.

E.g.:

- Ludek