Urgent Help!!!! Project Due

[MrHelpMe]

Hello,

I have created a crosstab report with two date range parameters(start Date and End date). What I am trying to do is if the user enters a start date and end date and no data is displayed, I want the report to display a message stating "No Data Exists for this Date Range". Is this possible. I am using crystal 7(maintenance release). Thank you.

 

[mmaz]

Create a formula (@Test) that counts the number of records that were brought back:

Count({tableNm.PrimaryKey})

Then, drop a label on your report that says: "No Data Exists for this Date Range".

Then, right-click this label, and select "Format Text Object". A window will be displayed. On the "Common" tab, check the "Suppress" option, and then select the formula button on the right.

Type:
@Test > 0

So the label will only be displayed if the number of records is equal to zero.

Hope that helps!

 

[mmaz]

oops! I forgot to tell you that I use CR version 8, so the procedures could be a little different for you. But you get the general idea...

 

[MrHelpMe]

Thank you mmaz. It worked perfectly in Crystal 7.

 

[5050]

I am tring to create a very simple report that shows an employee and the employee's rate (salary or hourly) from Earnings and Deductions. Each earning and deduction is an individual line in an employee table. I written some formulas to only bring back the employee rate and no other earnings and deductions, but where those should be showing up there is just a big blank gap. So my report basically looks like the following example:

Tom Jones 1,000.00 Bi-Weekly





Tim Davis 850.00 Bi-Weekly




Sally Thomas 8.00 Hourly

How do I make it where the gaps are alleviated and the report is more compressed? Any suggestions?

Thanks!

 

[dgillz]

5050-

Next time you post something new, you should start a new thread. Your question has no relation to salvatore's crosstab question.

I do not understand why you wrote formulas. There should be no need for formulas in a report this simple.

Are the employee names in a details section? Are there other details sections below the employees names? Please advise. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office