17 August |
How Do I? |
A client recently asked me how do I find out which reports have not been run or used within a specific timeframe, in Crystal Reports?
Read More |
|
|
03 August |
How Do I? |
A client recently asked me "How do I create an SQL statement that lists all the products that have not generated any sales, that can be used with either Crystal Reports or SQL Server Reporting Services?"
Read More |
|
|
07 July |
Crystal Reports Preview Sample Feature |
Recently I was delivering a Crystal Reports training session to a client, with a large dataset and a very slow network connection. Rather than returning all the records, it would be better to return just a sample.
Read More |
|
|
30 June |
How Do I? |
Last week a client asked how can one modify the An E-mail Address mailto: hyperlink in Crystal Reports, to add additional information, such as CC, BCC, Subject and/or body of text?
Read More |
|
|
20 June |
Save time designing reports using default formatting options |
When designing reports in Crystal Reports, it is possible to save time by defining the default formatting of the report objects, including fields, text and chart objects.
Read More |
|
|
09 June |
How Do I? |
During a recent training session, a delegate asked how does one create a grouped report based on a financial year that starts in May, using Crystal Reports?
Read More |
|
|
20 May |
How Do I? |
This week I was asked "How does one add an All option when populating dynamic distinct list of values for parameters in Crystal Reports?"
Read More |
|
|
11 May |
Comments, Comments, Comments |
I am currently working on a project designing a suite of reports for a new client, using SQL Reporting Services. Obviously over time the number of reports will increase, and it is so easy to forget why the report was designed in the first place.
Read More |
|
|
09 May |
How Do I? |
Last week a client asked how does one create a watermark report in Crystal Reports?
Read More |
|
|
26 April |
How Do I? |
A client of mine emailed a report that when compiled produced a "Divide by Zero" error message. Here is a solution to this problem.
Read More |
|
|
24 April |
Effective Report Planning |
Before designing reports there are a number of things that must be considered first. This post covers some of the factors, that report designers need to consider.
Read More |
|
|
31 March |
How do I? |
A client asked me how can one change the banding on a simple list report, to alternate every 2 records?
Read More |
|
|
31 March |
The MOD function |
Designers can use this function to create a banded report, to make list reports easier to read.
Read More |
|
|
22 March |
Crystal Reports Non - String Parameter Formulas |
A number of clients have asked me how does one display the parameter values of the report. This is the second part and covers non string parameter formulas, to be placed in the heading sections of the reports.
Read More |
|
|
08 March |
Crystal Reports String Parameter Formulas |
A number of clients have asked me how does one display the values of the report string parameters in the heading sections of the reports.
Read More |
|
|
28 February |
5 Simple Tips to Increase Performance in Crystal Reports |
One of the things clients ask me is how can we improve the processing time of our reports?
Here are 5 simple tips that can be used to increase the performance in Crystal Reports when compiling reports.
Read More |
|
|
