Categorise Your Chris21 Reports
If your list of Chris21 reports is becoming large and difficult to search, you’re not alone. A common complaint I hear from Chris21 users is of the number of report designer reports that are written by the various users within an organisation.
This means the list of Chris21 reports can become very long over time and it then becomes difficult to find the one you are looking for. Worse still, when you do find a report and you try to run it, access is often prohibited. Sound familiar?
Of course, the problem is exacerbated because if a user can’t access a report they will usually resort to creating a new one, thus adding further to the list!
The reality is that this is a common issue because the default value for the Access Control options is Access prohibited to non-owners. So when a user creates a new report they must remember to change the Access control option to allow others to access the report. This step is often overlooked. From a user’s perspective, it would be an improvement if the default was to allow modifications.
It’s not just access issues that are the problem. Many organisations have no rules or conventions in place to create useful reports and name them accordingly. For instance, a report that a payroll user has created will most likely be useful to colleagues. Rather than each user creating their own report, it is far better for everyone to use the one report.
To add further to this issue, many users will want a report that is specific to their requirements. It is often considered easier to create a new report, rather than to find an existing one and make some modifications.
Notwithstanding these issues, it’s unlikely that you will ever get to the ideal of a controlled list of Chris21 reports that will be used regularly by multiple users. So, unfortunately, your list of reports will continue to grow.
So what’s the answer?
There are two options that I can suggest. Firstly, on a regular basis you could review the list of reports and cull (delete) those that are obsolete or duplicated. Perhaps this could be done as one of your annual pre-upgrade tasks.
Secondly, you could categorise your reports. The Chris21 report designer has functionality that allows you to group reports into categories. For instance, you could create a category called Payroll for all of your payroll reports. You could have another category for Training, and so on.
When you categorise reports, you can use a Quick Filter to show your reports list by category. This will make the list of reports much shorter and make it much easier to find the report you are looking for. You just need to remember to select a category for each report that you write. The Category field is found on the report designer Options tab.
For an easy way to manage your Chris21 reports list, try the Category feature. Searching for that elusive report will be just a little easier.
Hi mate,
I need to create a report for a weekends worked counter process.
The requirement is essentially to check in the LVA screen whether the employee has already been granted an additional week of leave for working weekends in the current anniversary year. This needs to be filtered to only 3 leave groups.
The fields to check are spread across the LVA screen, LAC screen and the POS screen. Is this possible?
Regards,
Abid
Hi Abid,
You can include LVA, LAC and POS in one report as they all use DET NUMMBER as the parent key. So I think to do it you would add the relevant fields, and then in Selections select the Leave Type for weekend work and then the 3 leave groups using the BOR condition between groups.
Hope this helps.
Regards,
Tony.
Cheers Tony, worked a charm.
Except now I can’t figure out how to only show results from the last three months. I have tried entering T for today minus 3 months but it doesn’t accept anything other than a date.
Any idea how this would be acheived on a rolling basis? (i.e. each time the report is run it needs to bring up results from last three months from the date it is run).
Kind regards,
Abid
You’re right, Today minus 3 months will do it. The syntax is Greater Than =T-3M
Excellent mate! Worked well! I was missing the ‘=’ sign prior to the T-3M so it wasn’t picking it up as a calculation.
Thanks Tony.
-Abid
You’re welcome Abid. Glad to hear you’ve got it working!
Hi
Could you pls let me know how to create a list of current Salary Class of our existing Staff
Hi Rohan,
You can write a report over SMN and include the Current Class field.
Kind regards,
Tony
Hi Tony, Is there an easy way to re-assign ownership of a previous employees reports to myself?