Show label on report only if data in field

[senna]

Hello all,

I have added a function to my report to save me time in having to constantly type in "SEE DSC1101, DSC1102, DSC1103 ETC ETC" as reference photos.
I have created some fields in my table such as image1, image2, image3 etc.
Now, all i do is enter the image number in those fields in my form and then they appear on my report..

My issue/query is, how can i make the report so that it only shows the tags for the fields with data in them?



For example, i have created enough fields for 10 supporting images, and at the moment, i have a report with
DSC DSC DSC DSC DSC DSC DSC DSC DSC DSC

So if i had taken 1 supporting image for this particular claim, it would show on the report as
DSC1101 DSC DSC DSC DSC DSC DSC DSC DSC DSC

Can i make the report so that the other EMPTY DSC fields dont appear unless there is data to show?

[NoellaG]

Hi,

I would change the structure a bit: having 10 fields in a table with the same data DSC1 to 10 isn't really the way to go in relational database design (check the normalisation rules). Just put the information in a second table that is linked to the main table with a one to many relationship. In this case you can have as many (or as little) supporting images as is necessary without showing empty values.
In a report you can create columns to show the images one next to another.

success
NG