Category Archives: Crystal Reports

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

Crystal Reports – blank pages after crosstab?

Often if I create a crosstab report in Crystal Reports, I find that I have blank pages after the crosstab, which I obviously don’t want to print. I don’t know whether you have ever had a similar problem? To get … Continue reading

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

Extracting part of a string in Crystal Reports

A client had a Crystal Reports field that looked like: She wanted to be able to extract the part of the text within brackets, i.e. jdonbavand11 or joe.bloggs. There well be more than one way of achieving this but this … Continue reading

Posted in Crystal Reports, Uncategorized | Tagged , , | 1 Comment