by itsapiens

Dynamic Reports and Interactive Charts.
Powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is for anyone, no need for technical knowledge or SQL. Comes with over a hundred prebuilt reports.

Cancel at any time!
Free Trial

#2772 - Only seeing "ID" and not the "Name" of related field for Opportunities report

Open Bug? created by AIE 2 months ago

On Opportunities we have a custom "Relate" field called "Course Name" that relates to the "AOS_Products" module. When we set up a report based on "Opportunities" we do not find the "Course Name" field as an option in fields or filter drop-down lists but only the "Course Name (related ID)" field which doesn't help us as we need to see the related product name and not the ID.

What can we do to show the "Course Name" field on the report (fields/filters) instead of the "Course Name (related ID)" field?

We are using: Version 7.10.7 / Sugar Version 6.5.25 (Build 344)

  1. itsapiens member avatar

    itsapiens Provider

    2 months ago

    Hello,

    Thank you for contacting us!
    You should go to "Reporting Tool Settings" in order to open the report builder and create new report that has Opportunities and your custom module related. Then use the Course Name from your custom module.

    For more detailed vizualized instruction on the report builder please see Page #34 in a User Manual:
    https://itsapiens.eu/public/file/solution/art-sugarcrm/User_Manual_Analytic_Reporting_BASIC_for_SugarCRM.pdf?v=4

    Or let us know if you need any more help!

    Best Regards,
    IT Sapiens Team

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...