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 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.