Hi
I’ve now managed to set up my 78 courses ready for audiences and programs but want to cross check these with my master list. Is there a way of listing all courses under a sub category in a format that I can export to Excel? The filters restrict rather than set a starting point.
Thanks
Rob
Hi Rob,
You could use report builder to export your courses with category names (or IDs), then group the data with a pivot table in Excel (put categories then course names in the row labels area).
That will work if your catalogue is shallow (i.e. doesn't have many nested categories beneath the top level parent), but I can't think an easy way exporting a deeper category structure without doing a fair bit of work in Excel.
Thanks,
Ryan
Thanks Ryan
Filtered on my live courses so that reduces the ones I need to manipulate and yes should have scrolled down to the export that does the trick.
I only seem to be able to choose one category which is the bottom one. Have to add the parent category manually unless I’m missing something?
Rob
