Create mock or sample query data using Jaspersoft Studio's "export to sql"

Issue Description

Studio version 6.3 includes a feature which helps create a sql query which will mock your source data for the sake of testing and helping the support team reproduce your data-specific problems.    

During development of report designs, you might encounter a problem requiring trouble-shooting from the support team.  When trying to reproduce your problem we typically don't have your datasource, so we cannot run your report without query hacking to match datasets we have readily available.  This process is time-consuming since the design problems can hinge upon certain data values or quantities.  

Using the new feature you can quickly generate a sql query to provide to the support team which will let us run your exact report even though we don't have access to your datasource

Resolution

First, simplify the number of records required to reproduce your problem, then use a limit statement in your sql query to limit the number of records to the amount necessary.

Second, open the "Dataset and Query Dialog", hit "Data preview" at bottom, then "Refresh Data Preview", and rightclick anywhere within the results to select "Export To SQL" :

After hitting "Export To SQL" you'll see a sql query generated which you can save as text and attach to the case or copy/paste into a case comment:

Finally, consider repeating this step for each of the datasets involved in case your problem involves subdatasets (Table components, etc)