Follow

Exporting SQL Queries

Summary

If you found a Crystal Report in Orchestrated that you would like the source code for, you can export the SQL query based on the report by following these steps.

 

Details / How-To

  1. Navigate to Administration → Setup → General → Report and Layout Manager and choose the report you wish to extract from the list:



  2. Once highlighted, click "Edit" to edit the report in Crystal Reports.   It may take several minutes for Crystal Reports to load, especially the first time you run this: 



  3. Click on Database → Database Expert.  On the screen that appears, right click on the word "Command" on the right side and choose "Edit Command":



  4. If the following window pops up, clear out any User ID or Password information that might auto fill and choose "Integrated Security" then click "Finish":
     


  5. The "Modify Command" window will populate with the SQL Query below.  It is already highlighted so you can copy this as is:



  6. You can now paste this directly in to a query under Tools → Query → Query Generator then clicking "Execute" the edit icon, and pasting in the window.  For more information, please see the "Importing Queries" support page.  

 

Version 4.5.1.0

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments