Add "pretend" data to output

[Ofina]

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.

 

[Ofina]

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.