I have developed a BAQ to gather data from The PartDtl table to in turn, create a BAQ Report to assist the Production Supervisors in prioritizing their build schedule ( cover Sales Orders then consider Forecast). First a little background on the data. We have Planners (Production Supervisors) assigned to Product Groups. There are a few exceptions on the Part level where we assign a different Planner. The BAQ (through a Calculated field) will look at the Site level (PartPlant) to see if a Planner is assigned, if not, store the ProdGrup.PersonID…if there is a Planner assigned at the Site level store the personID from the Site level(PartPlant.PersonID). Another calculated field is used to get their name.
I understand I can not use a Filter for this Calculated field( calc_PlannerID) because there is not an adapter for it ( i have scoured the posts). I can put the calc_PlannerID in the Option Fields but the user would have to know their PersonID . Or I could put their name in the Option field and the user would have to type out their full name. My goal is to offer them a Combobox with their name displayed to ease the selection process. ) Planners could wind up covering for each other or as part of a troubleshooting process, look at another Planners report to see if ‘their’ parts are on the others report.
Am I missing something ??
This report was originally a Crystal report and as we are transitioning to ‘The Cloud’, I am taking the opportunity to replace Crystal Reports with either BAQ or SSRS reports. I understand how using Comboboxes on forms work as far as using a Business Object to look up values. I dont see where this would apply to this as the BAQ Report Designer is not a customizable form ( as far as I understand).
I chose a BAQ Report because it has more of the look and feel of the other Epicor reports. All of the SSRS reports I have seen have that ugly option pane on top on a web browser. I know how to utilize cascading Comboboxes on these SSRS reports but like I said, they are 'ugly.
Any and all help is greatly appreciated.