Cascading Report Prompts on Custom Reports
When writing custom reports for customers, most of them will give us a list of prompts that they want to use when creating it. In this blog, I would like to quickly explain the usefulness of cascading prompts on your custom reports and why they can be beneficial. Below are a couple of common situations where cascading prompts will be helpful.
Customer needs a report for labor hours for specific organization and wants to be able to select one or more employees to run the report on.
Build the custom report with a prompt for organizations that also cascades (filters) for only the employees for that organization.
Customer needs a report for Parts for a specific organization and supplier by store/bin location.
Build a custom report that prompts for organization and cascading (filtering) prompts for parts in that organization and store/bin location for the parts.
These are just two common reports that we can write for customers. But report writing is limitless. We can discuss your needs and draft out a report that is customized for your specific needs. We can also continue customizing it until it is exactly what you want. Remember, writing reports and even revising versions of a report that you may already have in EAM can be tedious. During our discussions with you, we will be upfront with you on what it will take on our part to meet your expectations so we can either continue or scale it back a little and revise it at a later time.
We have lots of experience in working with custom reports. As a result, we have many ways of customizing them and making them work for you. As always, reach out to us for any questions, concerns, or for any further help on this topic. Thank you for reading!