New Report Builder suggestions

Answered

Follow

Calvin Young

• 02 November 2015 02:00

Here are some suggestions that would help us use the new report builder more efficiently.

1. Add duplicate reporting filters for all fields. e.g. the domain filter allows you to include or exclude more than item into the report. A text filter field such as "class descriptor" does not allow you to filter by more than one item. You also can't add multiple instances of the class descriptor field like you can in the old report builder.

2. Remove the compulsory display fields. It would save more time if I could generate the report with only the fields that I want to see instead of having to export the report and remove them manually.

3. The fields should be displayed in excel in the same format that they are displayed/viewed in axcelerate. In the old report builder, fields such as "TFN Collected" and "VET FEE HELP Eligible" came out as Yes or No when exported to excel/csv. In the new report builder these are coming out as 1's and 0's. Having to change these once exported to excel seems a waste to me.

0

• Official comment

  

  Michael Ryan

  • 03 November 2015 00:56

  Hi Calvin,
  Thanks for the feedback. Duplicating filters is something we would like to have in the future and I have added this task to the development backlog however this feature is not yet scheduled.
  Compulsory fields is more of a tricky issue, some reports require compulsory fields because the report will fail if there is not at least one field selected from the base table in the report. In these cases we have tried to use a field that is likely to be chosen anyway. I'll keep this in mind and see if I can find a better solution that makes it more configurable whilst still ensuring the code stability. The stability of the feature always takes precedence.
  As for 1's and 0's, these are the preferred option for Boolean type fields because we need to allow data to be easily transferred from our export formats into other systems. Boolean fields represent true or false which you probably know in machine language is represented by 0 (false) or 1 (true). It's possible that we may consider an 'Export Options' feature in the future but this is not yet on our plan.

  Comment actions Permalink

Please sign in to leave a comment.