Monday November 20th 2017

Categories

Insider

Archives

‘Crystal Reports’ Archives

Deploying Crystal Reports to the Crystal Reports Server and the data base connection

Deploying Crystal Reports to the Crystal Reports Server and the data base connection

Recently I came across a strange issue i.e.Reports parameter / prompts were working fine in local computer, however the moment we transfer to the server prompts does'nt work. We updated the database connection at server however setting were not sufficient as prompts were not working on the server. This issue was resolved by changing the database [...]

When to transfer processing to database vrs Crystal Reports

When to transfer processing to database vrs Crystal Reports

It is generally better to have the reporting logic in database end so to minimal processing to be done in crystal reports. This generally true when summarizing the data. However many time people use cursors to built temp table to be used in Reporting. However this mechanism has some advantages but many drawbacks. Running cursors to update temp [...]

Crystal Reports Training Toronto

Crystal Reports Training Toronto

Crystal Reports Training Courses, Toronto Crystal Reports is the ultimate business intelligence application. Used to design and generate reports, Crystal Reports can work with a range of data sources, including Microsoft Excel spreadsheets, Oracle databases, Microsoft SQL Server, Microsoft Access databases, Business Objects Enterprise, and Local [...]

Healthcare Intelligence and Crystal Reports

Healthcare Intelligence and Crystal Reports

This post is about the importance of Crystal Reports in Healthcare to achieve the goal of Automated Comprehensive view of healthcare operations. Biggest challenges in Healthcare intelligence are Data sensitivity, complexity and manual processes information delivery; Recently completed a project on Automated Strategic Information Delivery. [...]

SAP Crystal solutions make a huge difference

SAP Crystal solutions make a huge difference

One of my clients in the healthcare industry was facing huge losses in an insurance related contract with a union. Cash flows were diminishing and costs were escalating. Sizeable amounts of the company’s employees were working on this contract, their jobs were on stake because of this contract’s significant impact on company’s profitability. [...]

A growing trend of moving business intelligence reporting from Excel to Crystal Report

A growing trend of moving business intelligence reporting from Excel to Crystal Report

A growing trend of moving business intelligence reporting from Excel to Crystal Report. We are seeing an increasing trend of Business Intelligence reporting from Excel to Crystal Reports. Main reasons our clients are giving as follows; 1- Manual processes in creating Reports in Excel. 2- Multistep transformations of data as Raw data is received [...]

Need for Management Reporting Automation

Need for Management Reporting Automation

Recently worked on management reporting automation. Top management of the company needed the information on Operational Metrics without any intervention of staff. Data was being provided by the IT from various sources and then consolidated reports were prepared in Excel by staff. I reviewed the process and found it be very complex and error prone. [...]

Ranking Data in Crystal Reports

Ranking Data in Crystal Reports

Recently I came across a scenario where I had to rank salesmen based on their sales. Single ranking is simple as we can just do a descending order for the sales, however ranking was for monthly sales for the last 6 months and ranking each months sales. Further grouping by the area. In this case I used the individual sales for the each month and [...]

Using Crystal Reports Parameters to filter records at Database level

Using Crystal Reports Parameters to filter records at Database level

Recently I was working on my SQL Data Base and I had the query however I needed to create a filter so that only desired data set reach at Crystal Reports Level. There several ways to achieve that for example by creating stored procedure. I used the Crystal Reports Functionality by using command and filtering using Parameters. Its little involved [...]

InRepeatedGroupHeader

InRepeatedGroupHeader

A formula to show the continuation of group from previous page. InRepeatedGroupHeader is Boolean function that returns True if it is placed in a group header section that has repeated. It returns false for the first instance of a particular group header. It will never be True unless the group option repeat Group Header on Each Page is checked. You [...]

 Page 2 of 16 « 1  2  3  4  5 » ...  Last »