Prepare Your Data Set

1. Create a custom report in Illuminate that contains all of the columns needed for the prebuilt report you are creating.

2. Export the data from the custom report using the "Tab Delimited with Header Row" option.

3. Open Jaspersoft Studio (JSS), locate the Repository Explorer, right click on "Data Adapters", and choose "Create Data Adapter."

4. Select "CSV File" and click "Next."

5. Name the data adapter anything you prefer. It issuggested to name the Data Adapter the same title as your Illuminate Custom Report.

6. Click "Browse," for the file type select "*.*" and select the file downloaded from the custom report (it will have a .txt file extension). Click "Open."

   

7. Select the tab "Separators" and for the field separator choose "Tab."

8. Click the tab "Columns", check the box next to "Skip the first line (the column names will be read from the first line)", and click the button "Get column names from the first row of the file." The columns names should appear below that button, then click "Finish."

9. Now you have successfully created a link to the dataset that you can use to locally develop your prebuilt report.