Crytal 8.5 Suppress Header based on condition

[ainkca]

Hi all,

I'm trying to modify a 'template' report. The report exists (written by someone else) and pretty much needs to remain unchanged except for one thing.

We've added a reporting facility, and I need to have the header of the report show either Address A, or Address B. Problem is that the facility info isn't introduced until the first 'group' which is patient info. And inside there, the only way for me to tell:
If the first character of the account # field is an A or a zero, then it's facility A, if it's a W then it's facility B.

I'm concerned I won't be able to do this with such an old version of Crystal... do I need to pass a variable... can't do that till version 9 right? Any suggestions for a way around this? I thought it should have been simple.

If it's facility A, show me this, if it's facility B show me that.

Of course I'm just getting this now and the 'go live' for the new app this report is using is in two working days.

Thanks in advance

 

[CR85user]

Just because a field isn't displayed until a certain point does not prevent you from conditionally suppressing the header of the relevant page.

It only becomes an issue based on the report construct where it is introduced as a variable later or subreport with inadequate linkage etc.

Have you tried to format the section and suppress with a formula added for:
left({account.number},1) in ['A','0']

Will all account numbers always have one of those prefixes? Would you prefer to have a caveat added in case of an account which doesn't match in future?

'J

 

[ainkca]

The account number is in a subreport.

All accounts will always have an A or a W. The 0s are all facility A, and will eventually purge out (within 6 months).

Here's what the report looks like:

Report Header - null
Page Header A - subreport of global address(now not applicable)
Page Header B - subreport of patient info
Page Header C - subreport of doctor info
Details A - subreport of exam info
Details B - just a line separating Details A and Details C
Details C - subreport of results (exam results)
Report Footer - null
Page Footer - page N of M, date/time stamp etc.

Information in Header A does not contain the account number, and is not linked to main report, just pulls a global address.

Patient subreport is linked to main report using patient id(not the same as account number). The account # field is not avaialable from the main report.

Hope that makes sense? I appreciate your response.