Best practice forum (Archived)

This forum discussion has been removed

 
This forum post has been removed
Thursday, 8 May 2014, 12:48 PM
The content of this forum post has been removed and can no longer be accessed.
Fiona Cashmore
Re: Enhancement Request for report source:
by Fiona Cashmore - Thursday, 8 May 2014, 1:22 PM
 

Hi John

We also frequently need a single report that contains information from multiple sources. My recommendation for the enhancement request would be for multiple selections from the drop down list of data source (site admin>reports>report builder>manage reports). That way administrators could select all data required and create one report rather than multiple that they then have to manipulate separately and merge.

Great idea John.

Regards

Fiona

Aja Rennie
Re: Enhancement Request for report source:
by Aja Rennie - Friday, 9 May 2014, 1:46 AM
 

Thirded. We know of other organisations that have built/commissioned special report plugins, but I think the capacity to build from multiple sources should be a base feature of Totara in the future. 

Steph Wild
Re: Enhancement Request for report source:
by Steph Wild - Monday, 12 May 2014, 7:28 AM
Group Learn Site Administrator

Absolutely agree with this enhancement request.  We would really benefit from being able to report using multiple 'Report Sources' within the same report. 

Simon Coggins
Re: Enhancement Request for report source:
by Simon Coggins - Monday, 12 May 2014, 3:34 PM
Group Totara

Could I just ask for a bit of clarification on exactly what you are wanting here.

From the first post it sounds like you want to display multiple reports one after the other. So take the existing contents of the "course" report and append the existing contents of the "programs" report, etc.

However the later comments perhaps imply that you want to create one report table with columns from different sources. Can you all confirm which of those two you mean?

If you mean the later one, can you give me some examples of the kind of reports you would want to make (e.g. which columns from which sources)?

Simon

Aja Rennie
Re: Enhancement Request for report source:
by Aja Rennie - Wednesday, 21 May 2014, 2:21 AM
 

One example of what we would be looking for (and I believe other NHS organisations may have similar requirements) would be the capacity to pull in one report details from the User source, Face-to-face sessions source, Course Completion, and Audiences. 

Which columns would depend on the person/role assigned the report and we could use the flexibility to have all of them as an option on any report. 

 

Simon Coggins
Re: Enhancement Request for report source:
by Simon Coggins - Sunday, 25 May 2014, 7:14 PM
Group Totara

It is technically difficult to allow multiple sources to be used together because the system needs to understand the links between the various pieces of data (which is what a single report source does).

There are some areas where we pull some data from one area into another report (for example information about users such as their profile fields is available in the face-to-face sessions report), but it doesn't go as far as you are describing.

To allow a more fluid linking of data of different types would require a significant rewrite of report builder, however it might be possible for us to add some additional columns or filters to particular sources that would help.

Please let us know which columns would be helpful, and in particular include how the data is linked. For example something of the form "Include the Course completion status of a face-to-face session's course in the face to face sessions report source".

Simon

 

This forum post has been removed
Monday, 30 June 2014, 11:30 AM
The content of this forum post has been removed and can no longer be accessed.
Simon Coggins
Re: Enhancement Request for report source:
by Simon Coggins - Wednesday, 2 July 2014, 7:53 PM
Group Totara

What you are asking for seems quite different to Aja. It seems that you want to be able to combine different report sources (record of learning, certifications and programs/certifications), and also to be able to add custom headers/footers onto reports.

Technically that is an easier addition to make that allowing arbitrary linking between existing sources.

Thanks for the feedback,

Simon