Printing a form when there is no data to report

[salguod11]

Hello everyone. This is my first visit to Crystal Tek-Tips and thank you in advance for your help. I am a Certified Consultant for the Sage 300 Construction software (formerly known as Timberline) and I need your help regarding one aspect of a report I just designed in Crystal for my client. Many construction companies have to file Certified Payroll reports to State governmental agencies to verify payroll expense on State construction projects. I have re-created the form for a particular state using Crystal, and with it interfacing with the accounting software, the client can now save countless hours previously spent filling out this report manually. My report design uses the following Selection Formula - record:

{?PE_Date} = {PRT_CURRENT__DAILY_DIST.Period_End_Date} and
({?Job}="" Or ({PRT_CURRENT__DAILY_DIST.Job} Like "*"+{?Job} + "*")) and
{PRT_CURRENT__DAILY_DIST.Certified} and
{JCM_MASTER__JOB.State} = "(two letter state ID)"

In summary, this selection: "finds all jobs in the data base that are located in (two letter state ID) and print the report by period end date and by job # if there was Certified time reported." This works fine.

Here's the issue, the State also needs to receive a blank form with the phrase "NO WORK PERFORMED" for those weeks where there is no payroll expended on the project. How can I print a report each week, by job #, if there is no time to report? Should I just copy my existing report (creating a 2nd version), remove all the data fields, hard code the phrase as text, and instruct the client to fill out the job information manually? I'm aware of the IS NULL function, but unsure as to how to use it?

Thanks again.

 

[Madawc]

You can create an extra Report Header section that says "NO WORK PERFORMED" along with the date.

Conditionally suppress this section: right-click on the section and choose Section Expert. Choose the formula icon (x+2 and a pencil) for suppression. Enter a formula; e.g.

not isnull({your.field})

This suppresses the section when there is data. (You can apply the reverse of this test to suppress unwanted report headers, page headers, totals etc.)


Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP