• Frustrated with standard reports (no DISTINCT clause), how can we use Enterprise (SQL) reports in dashlets?

    Hello Sugar lovers, We're regularly confronted to the limitations of the standard Sugar Reports module: No HAVING, no DISTINCT, no ability to make calculations... Currently our customers do not want to invest in third pary solutions (Discover and…
  • How to add description field in the detail summary page in Report Module

    Hi, Is there a way to add the description field. Se picture for more information. Thanks and regards Jörgen
  • reports filter querystring

    Our client has a "summary" report which lists revevant records. They want us to add a link to each row to a "detail" report for that record: we would need to link to the REPORT URL and pass querystring values to pre-populate the filters. Is this possible…
  • reports varchar link

    I have added a custom field to a custom module so it can be shown in reports. The field contains a link to a report (with query string values added with the intention of setting the filters with those values) The field currently shows on the report…
  • How to add print to pdf functionality while using custom reports

    Hello, Does anyone know how I can create PDF from the custom report. I don't have any idea about how to add custom print to pdf functionality in custom reports. from the above screenshot have export to word functionality but I want same as print…
  • Reports module issue

    sugar_version "10.0.3" sugar_db_version "10.0.3" sugar_flavor "PRO" sugar_build "192" sugar_timestamp "2020-11-03 12:06am" sugar_mar_version "Q2 2020" When I try to create report or view report on my local development, i got a page as below…
  • How we can send email .csv file on scheduled report ?

    Hi All I am Trying to send csv file on auto scheduled report ? by default sugarcrm send pdf format report . please suggest me if any one has any idea. Thanks
  • LayoutManager: Class not found:SugarWidgetFielddiscount-amount

    Hi, We have just upgraded an TEST instance of one of our customers from 10.0.2 to 11.0.2. During testing we noticed something odd. A lot of reports that work on RLI's don't seem to work anymore. They all fail with the error message: LayoutManager…
  • best way to add tags to reports

    Hi, what would be the best way to add tags to a column/row report? A customer uses the tags a lot and wants to get all records from contacts that have tags. But they want to have the tags in a single column in the report. Is it possible to extend…
  • How to create a chart in custom report ?

    Hi There, I have create a custom report in Report module. In that report i have calculated week data and Capacity Utilization Rate based on the records. I would like to represent the data into chart format like in regular Matrix report . For ex: Weeks…
  • Is there a way to display report description in the Reports List View?

    We would like to add descriptions to our reports and display those descriptions in the List View of the Reports module. There isn't Studio access to Reports OOTB, do no modifying things there. Another strange thing is that the Report Create/Edit function…
  • Need to customize the reports

    I am creating a report and as result i am getting all correct data. but i have an requirement that if there is an blank value in any column then i need to put "Not Applicable" How can we customize the report results.
  • Reports: Filter by related record count

    Hey Folks, I would like to create a report with a criteria based on related module record's count. For example, we have Accounts and related Opportunities, each Accounts have "N" number of opportunities related. Here, am trying to get all Accounts which…
  • Not able to create reports, related module fields are not displaying

    Hi Everyone, I am trying to create reports using reports module in sugarcrm 8.0.1 version but after selecting the module related module fields are not displaying and not able to copy the existing reports also. Does anyone have idea on this?