Learn - Create a Business Objects report showing all Course and Lesson descriptions

In this article, we'll show how to create a report showing Course and Lesson descriptions. This is a really useful housekeeping exercise to ensure your content is correctly and consistently described.

The Course and Lesson description objects can now be found in the 'Edit query' window as shown below:

     

Steps to add the Course and Lesson description objects to a report

1. Open a report
2. Select on 'Design' at the top right of the report
3. Select the 'Edit' button in the 'Data Access' tab to edit the report query
4. Expand the 'Courses' and 'Lessons' folders to find the new objects. Alternatively,use the search box at the top of the list of objects:
   
5. Click and drag the objects into the result objects pane
6. Select 'Run queries' to run the report again
7. Add the new objects from the 'Available Objects' panel into your report

What to do if you cannot see the Course and Lesson description objects

If you cannot find these new objects then you may need to convert your report to use the Learn.unx universe and not the LMS or LMS.unx universe. Instructions on how to do this can be found through this link to the 'Upgrade your reporting Universe' article.

How to remove HTML tags from report output

The course and lesson descriptions may contain HTML tags which format the description in Learn. For example you may see <a href> hyperlink tags, <p> for a new paragraph or <b>sample text</b> for bold text.

If you do see these and want the descriptions to be displayed without the tags then you can change the cell format so that it displays as HTML as follows:

1. Right-click on the description object you have added to your report
2. Select 'Format Cell'
3. In the 'General' menu change 'Read content as' from 'Text' to 'HTML'
   
4. Click 'OK'
5. Your descriptions will now be shown in HTML without the tags.

Get deeper learning in The Academy

Take a tour of the top standard reports in 'Learn LMS: top standard reports and why', for best practice hints and tips to support your learning.

View 'Reporting for beginners' to learn more about reports.

View 'Report building skills' to build your skills. You can also book a space on one of our live ‘Ask me anything: reporting!’ events with our reporting experts. Your opportunity to ask any report questions you have to our experts! 

Have you completed the administrator learning pathway for Learn? Click here to start your learning and to get your trained administrator certificate on completion.

The Academy is your forever free learning hub for Kallidus products including live events, eLearning videos, and more. If you're new to The Academy or know someone who is missing out on free learning, contact your Customer Experience Manager or the Support Team to sign up today!