Category Archives: Crystal Reports

Crystal Reports – inserting missing field headings into page headers

When you drag a field into the Details section in Crystal Reports, the field name will automatically be placed in the Page Header. Occasionally you may place a field in the wrong section of a report and then realise, you … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Crystal Reports – using Propercase but with some words needed in lower case – for example Wired for Sound

In Crystal Reports, if the data coming into a report is a mess of upper, lower and proper case, you may well want to convert the field using the function PROPERCASE. However, on doing so, you may find there are … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Crystal Reports – finding a domain name from an email address

A client recently wanted to group by only the domain name of email addresses. e.g. jdonbavand@btinternet.com would become btinternet and janet@jmdtraining.co.uk would become jmdtraining I guess I could have created one long formula but this was my approach. Formula1 – … Continue reading

Posted in Crystal Reports, Uncategorized | Tagged , | Leave a comment

Crystal Reports – creating a date parameter where the end date is always today’s date

It may be that you want to run a parameter query within Crystal Reports where you can choose the Start Date but the End Date is always going to be today’s date. Create a parameter called Start Date which should … Continue reading

Posted in Crystal Reports | Tagged , | 1 Comment

Crystal Reports – using a parameter field to generate a Summary or Detail report

You may have created a report and you want users to have the option of either just seeing the summary level or the full details. This can be achieved using a parameter. Create a new parameter  called Summary or Detail. … Continue reading

Posted in Crystal Reports | Tagged , | 1 Comment

Crystal Reports – changing date format from 20150131 to 31/01/2015

A client had dates coming into her report in the format 20150131 when she wanted it in the format 31/01/2015. The formula I used to convert this made use of the LEFT, MID and RIGHT functions: RIGHT({Orders_.Date},2)&”/”&MID({Orders_.Date},5,2)&”/”&LEFT({Orders_.Date},4) In this instance … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Crystal Reports – change ‘$0.00’ to ‘-‘

To change the $0.00 to $- , right-click the relevant field and select Format – Field. On the Number tab, click Customize. On the Number tab, in the Show Zero Values as dropdown, select the dash ‘-‘. Then go to … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Crystal Reports – formatting zeros as blanks

If you have zeros in a report, you may want to show them as blanks. Right-click on the relevant field and select Format Field from the shortcut menu that appears. On the Number tab, click Customize. On the Number tab, … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Crystal Reports – Mailing Labels – changing label size once labels have been created

When you have created labels using the Mailing Label Report Wizard, what happens if you then want to use a different label size with the same generated names? There is no Mailing Label Expert and you cannot get back into … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment

Crystal Reports – copying formulas between reports

In Crystal Reports you may have several reports with similar formulas. If you have Crystal Reports Enterprise you can copy formulas to the repository, but many people do not have this option. To copy formulas from a report, drag the … Continue reading

Posted in Crystal Reports | Tagged , | Leave a comment