Exporting SQL Queries


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.  





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