simonpaul64

asked on

# Change heading inside a subreport when the subreport returns now rows.

Hi my background is as a developer in PeopleSoft apps. I am fairly new to Crystal reports (using version 9) since I would normally write an SQR. However, Crystal is a very capable tool andI have an opportunity to use it more - so I want to. So far though I am finding very limited online resource for syntax help etc (happy to receive site or book recommendations!).

Anyway, to my current problem. I have a subreport which uses a formula for a heading . The formula is based on a simple count of rows - like this.

IF Count(queryname) > 0 Then

"heading text" + Clientnamefromquery

Else

"Alternative heading text"

When there are rows, the formula works. When there are no rows it seems Crystal doesn't even get to the formula, so is there a better way to display the "Alternative heading text"?

Thanks in advance!

Anyway, to my current problem. I have a subreport which uses a formula for a heading . The formula is based on a simple count of rows - like this.

IF Count(queryname) > 0 Then

"heading text" + Clientnamefromquery

Else

"Alternative heading text"

When there are rows, the formula works. When there are no rows it seems Crystal doesn't even get to the formula, so is there a better way to display the "Alternative heading text"?

Thanks in advance!

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER