Tag 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 – showing Details or Summary based on a parameter

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 Uncategorized | 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