How to �NOT� use Fields in a Report

[forskare]

I have 8 fields (pgrm1 thru Pgrm8) There is a corresponding numerical field for each Pgrm field. I will always use at least 1 Pgrm field and the corresponding numerical field but up to as many as all 8 fields could be used. The goal is to only display the Pgrm fields, along with the corresponding numerical field, on the report �IF� the Pgrm field is not Null or IOW, if it contains data.

This is how it would work.

During data entry, the user will enter a Pgrm in one or more of the Pgrm fields and also enter a numerical value in the corresponding numerical field. (A drop down will be used to choose the Pgrm value).

Data entry example:
Pgrm1 Num1 Pgrm2 Num2 Pgrm3 Num3 Pgrm4 Num4
Pgrm5 Num5 Pgrm6 Num6 Pgrm7 Num7 Pgrm8 Num8

Say only Pgrm1 and Pgrm2 and the corresponding Num1 and Num2 fields contain a value. On the report, I only want these fields to appear. I do not want the other fields to appear on the report.

Report Example:
Pgrm1 Num1 Pgrm2 Num2

Now, the $64 million dollar question. How can this be done?

[Al Buchholz]

Re: How to �NOT� use Fields in a Report

3 words

conditional objects

or

html reporting

[forskare]

Re: How to �NOT� use Fields in a Report

Hi Al,

I figured this would have to be contained in a conditional object. The example in the documentation is for a use on a form and has little application to a report. The HTML in reports does not have anything to do with conditions other than conditions about formatting appearance. I'll keep searching but that's all I found in the documentation using 'Reports', 'HTML' and 'Conditional Objects'. My next method will be to search Alpha using Google.

[Al Buchholz]

Re: How to �NOT� use Fields in a Report

Hi Al,

I figured this would have to be contained in a conditional object. The example in the documentation is for a use on a form and has little application to a report. The HTML in reports does not have anything to do with conditions other than conditions about formatting appearance. I'll keep searching but that's all I found in the documentation using 'Reports', 'HTML' and 'Conditional Objects'. My next method will be to search Alpha using Google.

Conditional objects work great in reports. No difference in use of a form or a report.

HTML reporting is a little tricker. Build the HTML from an xbasic function that looks at the fields and decides what to show.

[forskare]

Re: How to �NOT� use Fields in a Report

I found the Conditional Object info for reports using Google. Now it's time to experiment and see what happens.

Thanks for the directional approach.