Allow staff running reports to select which columns appear

Tags:
17

Ultimately what we would like to be able to do is create a report template that had a flag like modifiable when turned on would allow staff running a report to choose to include or remove columns from the report.  For instance we have a title list report that inlcudes: author, title, publisher, call number, circ modifier, and shelving location.  One library runs the report and does not want the circ modifier to appear in the list.   They have the option to run the report without the circ modifier appearing. 

Category

Status: 
Under review

Comments

Re: Allow staff running reports to select which columns appear

This could be fairly complicated when it comes to aggregate information. Should the "hidden" columns still affect aggregate information in output, or should the aggregates act like they aren't there at all?

Re: Allow staff running reports to select which columns appear

Moderator

Preliminary requirements are available at http://masslnc.cwmars.org/node/2908 under REP-02.

Feel free to let me know if you have any questions or suggested changes.

Re: Allow staff running reports to select which columns appear

Moderator

We included this idea in our March 2014 RFP along with the idea to allow staff to select which filters should be used. We did not receive a quote for the project, but I did hear from one vendor this project is a larger scale project.

Re: Allow staff running reports to select which columns appear

Moderator

Tom, your question is important.  I'm inclined to just keep the columns hiddent but still used so it really doesn't change the results of the report and only the display.