Browse By Tags

  • Blog Post: Building Cross Database Views for Reporting

    You may need to reference data held outside of Sage CRM and within another application's database for a variety of business requirements including Reporting Graphing Reports within CRM are based on views and so if the SQL within a view can provide a way of accessing data...
  • Blog Post: Automatically Filtering Reports on Custom Entities by the Currently Assigned User in Sage CRM.

    It is a common business requirement to add new custom entities into Sage CRM. This can be easily done either by using the Advanced Customization Wizard or by using the slightly more manual process of adding the new table under the Administration screens. See: Administration -> Advanced Customisation...
  • Blog Post: Reports and Graphs using Key Attribute Data

    Reports and Report Charts can only be built from views. So If we want to create a Report Chart that uses Key Attribute Data then we must first create the view. The structure of the tables that holds the key attribute data is complex and trying to work this out on our own to build a view would be a deeply...
  • Blog Post: Reports, Saved Searches and Groups

    I hope in this article to explain the meta definition of the following structures: Standard Reports Saved Searches Groups (Target Lists) These features/structures in Sage CRM all use the Reports tables: custom_reportbands custom_reportcharts custom_reportfavourites custom_reportfields...
  • Blog Post: How to customize reports through CSS in PDF format

    Today I'm going to present a simple trick "How to customize reports through CSS in PDF format". But first of all, all files mentioned in this article have to be backed-up before editing. When run a report we can choose 3 modes: Screen (HTML) Export to PDF Excel to XLSX...
  • Blog Post: Embed Sage CRM PDF Reports in External Applications

    An external application can make use of Sage CRM reports. It is not appropriate to invoke HTML reports from a 3rd party or external application as these are designed to interact with the Sage CRM interface. You only need think about the auto hyperlinking feature which allows drill down into Sage CRM...
  • Blog Post: Some thoughts on Sage CRM, FOP, PDF and Reports

    Sage CRM uses Apache FOP (Formatting Objects Processor) to generate its reports in PDF format. See http://xmlgraphics.apache.org/fop/ FOP is an example of a print formatter that uses XSL formatting objects (XSL-FO) and is in theory not tied to outputting in a particular format, although its usage...
  • Blog Post: Sage CRM and Cascading Stylesheet Support

    Sage CRM only has a browser based interface. The system screens that a user see as they navigate around the product are rendered in HTML. HTML tags are used to define the structure and content of a document. They say "This is a header", "This is a paragraph", "This is a table"...
  • Blog Post: custom_reports settings and Summary Reports

    The information included here maybe useful for those people wanting to add features such as automatic definition of reports, or cloning of reports and dynamic groups and editing of summary reports, etc. Please read first a previous article " Reports, Saved Searches and Groups ". There...
  • Blog Post: What Reports have Charts?

    A customer had a requirement to see which reports had charts associated with them so they could consider them as Chart Gadgets in their Interactive Dashboard. It is not immediately clear from the standard report screen which reports might have a Pie chart or HBar associated with them: To allow...
  • Blog Post: Restricting Access to a Report to Specific Times of Day

    This article has been prompted by a question I was asked at a recent Developer training course in Johannesburg, South Africa. During the training course we discussed how when a user runs a large report it can place a load on the customer's server which in turn can create problems for other users...
  • Blog Post: Controlling access to reports

    The security features in Sage CRM extend to cover the internal CRM reporting engine. If a user can not see the data in the screen then they will not be able to see the data in the reports. The main security profile settings apply and so do the field level security settings. But how can we stop people...
  • Blog Post: Creating Groups on Custom Entities in Sage CRM

    I have created a new custom entity called 'Project' using the Advanced Customization Wizard (aka Entity Wizard, Main Entity Wizard). The requirement: The requirement was to be able to use data from the project table in groups used for outbound emails, and within the Interactive Dashboard...
  • Blog Post: Can I create new Summary Reports in Sage CRM?

    Summary reports, which show a quick overview of account information, are available from the Summary tabs of: Companies People Opportunities Cases A summary report is made up of two customizable areas: Header content - summary information from the current entity. For example, click on the Summary Report...
  • Blog Post: Tips for Building Views: A round up of articles on views.

    The following is a survey of all the different articles that have discussed creating and editing views within Sage CRM. Understanding SQL views is essential as they under pin just about every feature within Sage CRM and completely determine what can or can't be done in Reports, Marketing Groups,...
  • Blog Post: Creating Interactive Dashboard List Gadgets for Custom Entities

    List Gadgets derive their data from 4 different types of data source Saved Searches Advanced Finds Reports Groups When a custom entity is added to Sage CRM using the Advanced Customization Wizard (Entity Wizard) only the table is created. The default behaviour associated with...
  • Blog Post: Controlling the Data Passed to Custom Gadgets in the Interactive Dashboard

    This is the second in a series of articles discussing the creation of Custom Gadgets that can be added to the Interactive Dashboard in Sage CRM. In the article " An Example Custom Gadget for the Interactive Dashboard " I mentioned that data is passed to and from Custom Gadgets in JSON format...
  • Blog Post: Creating Groups on External Tables in Sage CRM (E.g. Sage accounting systems)

    The requirement: The requirement was to be able to use data from an external table in a group definition. This will allow data from a Sage accounting system to be used to build groups of Person and Companies that can then be used for outbound emails, and within the Interactive Dashboard as data sources...
  • Forum Thread: Filtering Reports on Current User as a Field, not Assigned User

    I've got an excellent report for our Project Management team; it print current projects (opportunities) listed by stage, has relationship names and notes, it's beautiful. When there's a management meeting they can print it off, walk into the meeting and bring everyone up to date on all the...
  • Forum Thread: alignment from left to right?????

    Dears, How can i make sage crm alignment from left to right permanent coz when i convert it to left to right alignment when i logged it auto convert from right to left IE 9 :/
  • Forum Thread: Can you use multiple source views in a report?

    I am trying to create a report that shows someone all the items they updated in Sage for a specified time period. The problem is updates are made in both the Opportunity Funnel source view and the Communication Summary source view. Right now I can only manage to create two separate reports. Is there...
  • Forum Thread: Full Activity Report for a specific user ?

    Hi everyone, I'm new on this community and I'm working on Sage CRM 6.5 since last March. I have a question : Is it possible to create a full activity report for a specific user ? By "full activity report", I mean : EVERY modification, creation on ANY type of Data. Does someone...
  • Forum Thread: add link image to panel or screen

    Hi How can i do this in .net SDK i try but not work
  • Forum Thread: Currency not set... An error occurred while running the report.

    Hi All, I'm new to Sage 200. We encountered problems export pipeline report, as the report says 'An error occurred while running the report. Currency not set'. I'm not sure if any other administrator changed the currency settings, but the settings seem to be fine now. Any one have...
  • Forum Thread: Crystal Reports supported version?

    Ok trying to figure something out as I am alittle confussed here on what is supported by who :) Let me explain Currently our Vendor has our CRM 200 7.0e (soon to be 7.1 sp1) running on a Windows 2003 server using CR X on app and 2005 sql on DB. We are in the process of bringing our system in house...