Can you make the Course Reference Code available as a column in the Courses Report?

Q: Can you make the Course Reference Code available as a column in the Courses Report?

A: Although the course reference code is not included in our standard reports, you can include any field you like by creating a report export with custom data fields.

To do this go to the Reports area, click 'Create a report', then choose User or Team Report, select your report criteria and click the blue 'Schedule Email for this Report' link on the right. On the 'Export a report' screen, next to 'Report Format' you will select 'Custom' from the drop-down menu. You then need to enter the string of data fields you would like on your report.

Custom_Export.png

To include the course reference code you would need to include [CourseCode] in your custom format string. Once you are ready and click 'Save' the report will be emailed to you in a .txt format to then be opened in the program of your choice.

To open a .txt file in Excel, you will need launch Excel, under the File menu click 'Open' and select the .txt file. During that import process make sure to stipulate the delimiter that you used in the report export to separate the fields - in the help guide example this is the $ symbol.

Excel_txtfile_Import.png

Have more questions? Submit a request

0 Comments

Article is closed for comments.