I am utilizing MP2 6.1 SQL at the moment. Recently, I incorporated new fields into our Work Order table using MP2 designer. The process went smoothly, and the new fields are now visible on our Work Order form. While I am able to input data in MP2 and see it transfer to the work order history form upon closure, I am encountering difficulties in pulling this new data into reports. Despite my efforts, the new fields do not appear on either the visible or hidden fields list when building the reports. Can you provide guidance on how I can address this issue effectively?
Utilize an older version of Crystal Reports to update essential reports such as the WO print out from the backend. List reports within the application are fixed and require a customization purchase from the MP2 owner for any modifications.
Thank you for your response. Just to clarify, are you confirming that it's not possible to include additional fields in a report such as {Reports > Work Orders > Simple} without buying customization services?
I have yet to find a suitable solution for my needs. Upon reaching out to MP2 several years ago, I was only offered a customization quote as their response. If you come across a more helpful solution, please share your findings. Best of luck in your search!
Hello, modifying canned MP2 reports is not a simple task. However, forms like work orders and purchase orders can be edited using Crystal Reports 8.5. By recreating canned reports in Crystal Reports 8.5, they can be easily accessed from within MP2. Additionally, a Quick Access bar icon can be assigned for convenience. If you have any specific requirements, please let me know. Regards, Donal Fleming from flemingtechnical.com.
It sounds like you've done everything correctly up to this point, but I would recommend checking if the report you are trying to edit actually pulls data from the Work Order table. Not all reports do so. If this doesn't resolve the issue, there could be a latency problem, where the updates you've made haven't been fully processed into the system yet, so the changes aren't reflecting. You might need to restart the software or your workstation after saving your changes, and you should definitely check if there are any updates or patches available for MP2. If these steps don't help, consider contacting the software's support for further assistance.
It sounds like you've already done some solid groundwork in setting up your new fields. What you're encountering is a common problem you might not know about when you modify tables in MP2 6.1. Sometimes, the new fields don't update immediately in the report designer. Have you tried refreshing the database link in the report designer after creating your new fields? This usually helps the system to recognize the newly added fields. If that doesn't work, you might need to rebuild the reporting system's data dictionary - but this should be your last resort as it can be a bit time-consuming.
I've experienced something similar before with MP2. It seems like there might be an issue with the field properties in the designer. After you've created these new fields, ensure that they are marked as 'Queryable'. If they are not marked as such, they won't show up in your reports. Additionally, confirm that these fields are also not marked as 'hidden' in the database. Remember, any changes in the designer need to be saved and the system restarted for them to take effect. Refreshing your database connection might also help resolve the issue.
From my experience working with MP2 SQL, it sounds like your new fields might not have been added to the report database view that's being used to build reports. The distinction here is that the 'views' in MP2 are essentially pre-packaged SQL queries that define what data is available to the report. If changes are made to the underlying tables (like adding new fields), these won't automatically reflect in the existing view. A workaround could be manually adding these new fields to the view's SQL query. If you're not comfortable doing this, you might need to consult with your DBA or seek assistance from Infor Support. I hope this helps!
✅ Work Order Management
✅ Asset Tracking
✅ Preventive Maintenance
✅ Inspection Report
We have received your information. We will share Schedule Demo details on your Mail Id.
Answer: 1. How can I include newly added fields in MP2 6.1 SQL reports? - To include newly added fields in MP2 6.1 SQL reports, you may need to ensure that the fields have been properly added to the database tables and are accessible in the SQL queries used for report generation.
Answer: - The newly added fields may not appear in the visible or hidden fields list when building reports in MP2 6.1 SQL if they have not been correctly linked or synchronized with the report builder tool. You may need to check the data dictionary and report configuration settings to ensure the new fields are included.
Answer: - If you are facing difficulties in pulling new data into reports in MP2 6.1 SQL, you can start by verifying the field mappings, database connections, and report design settings. Make sure that the new fields are properly defined in the system and are accessible for reporting purposes.
Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.