Saturday September 23rd 2017

Categories

Insider

Archives

‘Crystal Reports’ Archives

Crystal Reports 2011 Replace Function

Crystal Reports 2011 Replace Function

Found a great resource on Crystal Reports Replace and Switch function. basically it showed first the use of Replace function and then achieved the desired out by using the Switch Statement. Read More

Comparison of SQL and Stored Procedures in Crystal reports perspective.

Comparison of SQL and Stored Procedures in Crystal reports perspective.

Many large databases have their own programming languages. Oracle is PL/SQL; SQL Server’s is called Transact SQL. These propriety languages are tied closely to the SQL and can execute SQL commands directly, but they also have procedural elements like third generation programming languages. We can create variables and execute multiple statements. [...]

Setting defaults for Format Attributes

Setting defaults for Format Attributes

Sometime we need to determine some standard formatting options that should be applied to every report. We can set default formats for the various fields types using the File and then Options dialogue box. Open the option box dialogue box and select the fields tab. As show in the picture. The field tabs has buttons for each of the Crystal Reports [...]

Always check Show SQL Query to determine if the criteria are being passed to the Server.

Always check Show SQL Query to determine if the criteria are being passed to the Server.

Ensuring that record selection in pushed to the server is the most important step in optimizing the use of SQL databases. The result is fewer records that must travel the network and less work to be done locally by Crystal Reports. The record selection formula, created either manually in the Formula Workshop or generated by the Select Expert, [...]

SAP Crystal Report’s position in the Business Intelligence and Reporting

SAP Crystal Report’s position in the Business Intelligence and Reporting

SAP Crystal Reports software which now considered as a standard for Reporting and is being used many medial to large size Business Softwares like Microsoft Dynamics, Medact and many manufacturing softwares. According to SAP With SAP Crystal Reports, you can create powerful, richly formatted, dynamic reports from virtually and data source delivered [...]

Crystal Reports Consultants & Trainers in Mississauga and Greater Toronto Area

Crystal Reports Consultants & Trainers in Mississauga and Greater Toronto Area

We have worked with clients from variety of industries where they bought Standardized ERP and Accounting Soft wares like Med ACT for Healthcare and Pharmacies, Microsoft Dynamics for global financial and business management application, ITrac for Security and Surveillance and many other manufacturing software. These software meet their basic [...]

Preventing Infinite Loops (Crystal Syntax)

Preventing Infinite Loops (Crystal Syntax)

There is a safety mechanism to prevent report processing from hanging due to an infinite loop. Any one evaluation of a formula can have at most 100,000 loop condition evaluations per formula evaluation. For example: Local NumberVar i := 1; While i {movie.STARS} Then Exit While; i := i + 1 ); 20 If {movie.STARS} is greater than [...]

Crystal Reports Performance Information

Crystal Reports Performance Information

Crystal Reports make some performance information accessible. The information is displayed in Performance Information dialogue box and may help you diagnose performance problem. It is also helpful in determining the number of passes required for report processing. Open the Performance Information box by selecting Report then Performance [...]

Using Stored Procedures to Create Crystal Reports®

Using Stored Procedures to Create Crystal Reports®

An interesting demonstration of using Stored Procedure in Crystal Reports. So, when the nature of data makes processing in Crystal difficult, one of the first things you can do is to make the data simpler by using or creating a database view that encapsulates and simplifies the data as well as incorporates security. Please read the complete [...]

Right Combination of SQL, Stored Procedures and Crystal Reports can very well handle data presentation layer

Right Combination of SQL, Stored Procedures and Crystal Reports can very well handle data presentation layer

Crystal Reports has its very solid standing when solving complex problems and presenting data, I would say with proper combination of SQL, Stored Procedures and Crystal Reports we can very well handle data presentation layer, for example multiple level reports, grouping, sub-Reports and formals etc, however expertise on maximizing power of SQL to [...]

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