Monday November 20th 2017

Categories

Insider

Archives

‘Crystal Reports’ Archives

SQL Server Reporting Services and Crystal Reports: A Competitive Analysis

SQL Server Reporting Services and Crystal Reports:  A Competitive Analysis

I read an interesting and very informative article on Comparison between SQL Reporting Services and Crystal Reports. This article discusses and provide comparison on the basis of their functionalities, overall costs and meeting reporting requirements. In the Executive summary report discusses the licensing and overall how both meet reporting [...]

In ideal situation we should use a distinct SQL Query we don,t have to suppress the redundant records, however that being said, there can be a situation when we need all the records and for example 1 Customer may have more than 1 orders and we want to show customers distinctly. In situation like this Crystal Reports Suppression functionality and [...]

Do Not Use Formula Field in the Selection Formula

Do Not Use Formula Field in the Selection Formula

Crystal Reports allows you to use formula field in the record selection formula. For example, say the report contained a formula called @Taxed that computed the order amount plus tax as {Orders.Order Amount} * 1.05. The selection formula for the report could be @Taxed >2000. In this case selection formula could not be converted to where clause, [...]

Role of Reporting Tools like Crystal Reports / SQL Reporting Servoices

Role of Reporting Tools like Crystal Reports / SQL Reporting Servoices

. Recently I visited a large organization and surprised to learn that all the data has been cleansed and scrubbed, However when any requests for reporting comes they uses excel to built the report. Crystal Reports / SQL Reporting services can automate reporting which can then easily exported to any formats. Excel is a great analytical tool [...]

Manual Running Totals

Manual Running Totals

Recently I was working with one of my clients and they were using an Accounting software which came with the canned reports, they wanted some in-depth analysis like Average fixed costs and Average Administrative costs related to specific cost centres. I had access to total overall summarized costs related to direct expenses and Administrative [...]

Report Processing Model

Report Processing Model

An exteremly use ful information found on the MSDN go direct to the source Crystal Reports uses a three-pass reporting method to generate reports. A pass is a process that Crystal Reports uses each time the data is read and manipulated. Depending on the complexity of the report Crystal Reports may make 1, 2, or 3 passes over the data. This feature [...]

Using Dynamic Array and Loop Control Structure

Using Dynamic Array and Loop Control Structure

For Dynamic Array you need to create 3 Formulas; 1- Initialize Array Formula – INIT using the following formula and place it in the report Header Section; WhilePrintingRecords; StringVar Array Names; NumberVar Counter :=0; 2- Create a Formuala Called Accum using the following Code, and place it in the detail [...]

What exactly is grouping on the server?

What exactly is grouping on the server?

If you create a summary report with details section suppressed, then grouping should be done on the server. What exactly is grouping on the server? It basically having a report query with group by clause as well as Crystal reports option grouping done on the server must be checked. This applies to databases using SQL Language. The advantage is [...]

Using Multivalve Discrete Parameters

Using Multivalve Discrete Parameters

In order from multivalue discrete parameters to be available for use in the Select Expert, you must choose the “is equal to” or “is not Equal to” Condition. If we choose “ is equal to” the database query will be constructed with a Where Clause containing a series of comparisons connected with ORs, as Shown here, Where [...]

Horizontal Page Number in Oversize Crosstab

Horizontal Page Number in Oversize Crosstab

in Oversize Recently I worked on the Crosstab reports which spilled across both vertically and horizontally. I utilized the Vertical and Horizontal special field. The page number special field contains the usual vertical page number. The Horizontal Page Number special field contains a number that indicates the count of pages horizontally. This [...]

 Page 4 of 16  « First  ... « 2  3  4  5  6 » ...  Last »