Can anyone tell me why after I edit the query iniside the 'Show SQL Query', I clicked OK, saved the Report itself then run the Report, but it keep going back to the previous query before the change. I even checked the properties of my Report and Read-Only is unchecked. Thanks for the help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Edit Show SQL Query
- Thread starter 112055
- Start date
synapsevampire
Programmer
In CR 9, you can edit the SQL, in older versions, you can edit part of the SQL.
Read the Description area in the Show SQL Query window.
Keep in mind that once you start manually changing the SQL, CR will not be able to update the SQL through the use of it's interface.
If you share specifics of what you're doing and versions, someone might better help you.
-k kai@informeddatadecisions.com
Read the Description area in the Show SQL Query window.
Keep in mind that once you start manually changing the SQL, CR will not be able to update the SQL through the use of it's interface.
If you share specifics of what you're doing and versions, someone might better help you.
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question