Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add "pretend" data to output

Status
Not open for further replies.

Ofina

Technical User
Feb 25, 2004
156
US
I have an sql view that has registration numbers for all provinces in Canada, except for 2. These 2 no longer require the registration numbers, so they are not in the view. However, I would still like my detail section to show them with "Opted Out" beside it.

I suppose I can add them to the view coding with "Opted Out" as the value, but I'd like to know if there is something in Crystal I do to achieve the same thing.

For that matter, if one province (other than those two above) is missing a registration, I'd like to show it with a blank for the number.
 
I just realized I can probably do exact what I want if I move it all into the page header and out of the detail section.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top