‘Crystal Reports’ Archives
beware of Mcafee!! same tactics like ask.com
My brand new laptop stopped connecting to internet, I wasted time driving to Best Buy and then called router company and then searched intenet resulted in total wasted time of 6 hours. One of employee of geek squad told me to remove Mcafee, I did that and internet started working. I have another problem in which I have to the same thing with ASK [...]
Using Query and Manual Running Totals
Recently our client required us to create a report outlining all the Cash withdrawal transactions with their respective Cash withdrawal Reason and Cash Withdrawal technique. The Cash withdrawals were stored in 2 tables ‘Cash withdrawal reasons’ and ‘Cash withdrawal techniques’. They want report in Crystal Reports in; following format 1- [...]
Creating indexes for faster data access for reporting
This post is based one the Sap Crystal Reports - fast data acces topic from Sap Crystal Reports 2011 User's Guide. We found this topic very clear and easy to understand, as indexing topic is most of the time overly complicated by different technical reference guides or Database / Crystal Report Books. Indexing is on of the several techniques [...]
Creating an excel like spread sheet calculations by overlapping 2 cross tabs in Crystal reports.
Sometime it is necessary to create a cross tab to subtract the 2 internal columns from the last column for example direct cost and administrative cost have to be subtracted from the last column i.e. sales amount column, In crystal reports cross tab which usually summed the columns in cross tabs may seem impossible at first. There are several [...]
Next, Previous Function Crystal Reports
Recently I created a report to calculate time between different events happened. The date time field was stored in a single colomn. I used date diff function by incorporating the next and previous record function and grouped the data according to the events. The report was completed successfully by using this mechanism.
Sub-Reports SQL Server Reporting Services and Crystal Reports
Sub-Reports Recently I was working on Multilevel report which has a main transaction and child transaction. The child transaction further have 1 level down two different types of transaction and lastly these each of the two different types of transactions have two further different types associated parties involved with the transactions. [...]
Alternate Color shading in Cross Tab Crystal Reports for more legible reports
Alternate Color shading in Cross Tab Crystal Reports for more Readable formatting To complete the formatting: - uncheck the "Show Cell Margins" option. - select the field then go Format field Select Border tab and then go to back ground and in the formula option enter the following formula you can select different colors try to change [...]
Data Integration for Agile Healthcare Organizations
By Mian Kaleem Mian Kaleem is Crystal Reports Consultant and have experience of Crystal reports consultancy services to many medium to large size comapnies. View complet profile Report Abstract This paper provides a high level overview of the healthcare data integration and its effect on agility of healthcare organizations. It explains [...]
Use of Array function in Crystal Reports for producing comma delimited list of related orders
This example will demonstrate the very practical use of Array function in Crystal Reports. A client wants see the customer orders list in the comma delimited format in crystal report view used in a custom application. Customer name and related orders are stored in 2 different tables. Please figure 1 below report can be created by placing [...]
Create a table of contents for your reports
A simple TOC can help users navigate your reports In this article, we'll show you how to create a table of contents (TOC) based on the grouping in a Crystal report. For example, if you have a report grouped on country, the TOC would list all the countries in the report, along with the page number that each country begins on. This could be a [...]
