I' ve some fields as State, contains: R1.S1, R1.S2, R1.S3, R2.S1, R2.S2 . and Region, contains: R1, R2
And I have a straight table with some expression like below:
Region
State
Exp1
Exp2
R1
R1.S1
a
b
R1
R1.S2
c
d
R2
R2.S1
e
f
R2
R2.S2
g
h
That straight table will show in my report as Chart Object. I want to use Chart Object as Image and use Level by State in my template report. When I preview a report, it shows an image with caption:"No Data to Display" in field State values: R1.S3
How to hide some values in a field, if it will show error ("No Data to Display" ), automatically?