Tag: Reporting

  • Content Type

Excluding Reports from the Reports List in Infor CRM

In the Infor CRM (Saleslogix) Web client, users can go to the Reports section to see the full list of reports that are available. However, some reports, you might not want to have available there. For example, at times, you might build reports that serve a certain purpose, that you run via code from somewhere […]

Viewing Previously Run Reports in Infor CRM Web

When you run a report in the Infor CRM Web client, the request it passed to the job server, which runs the report and saves it as a PDF. This PDF is saved in the attachment folder defined for CRM and it also creates a record in the attachment table. This information can be used […]

Optimizing Crystal Reports for Saleslogix

I recently received a tip from a Swiftpage employee about how to speed up the running of Crystal Reports in Saleslogix.  It seemed like it really helped in some reports. The Crystal .Net API used for web reporting can take a long time to load reports, usually when applying connection information and also when validating […]

Setting Up Multiple SalesLogix 7.5 Web Reporting Sites on One Web Server

The standard SalesLogix 7.5.x “SLX Web Reporting” site can only be used for one database because it contains a Connect.Config file that points to a single database. You can switch between databases by re-deploying the “SLX Web Reporting” site, but in a development environment it is more convenient to set up multiple reporting sites, one for each database. The below procedure explains how to setup reporting dedicated to one database. (The...

Using the Reporting API enhancement in SLX 7.5.2 web

Sage has added an API enhancement to facilitate running Crystal reports in the SalesLogix web client. To get the functionality in 7.5.1, it was necessary to install a reporting update bundle, but the functionality has incorporated into 7.5.2 with no additional installation needed. The enhancement adds a number of functions to facilitate running reports in […]

Flattening Out SalesLogix Data To Combine Multiple Rows into a Single String using SQL

A question came up from a person attending our current Report Writing class about how to flatten out data that exists as multiple rows in the database to a single string in a report. There is a really cool trick you can do in SQL to accomplish this which I previously outlined in a post on my personal blog where I outline a technique that can be used to make a query append each value from the rows in the query to a variable. Without using cursors,...

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!