A
Ardy Ghoreishi
Hello All:
I have made a cross-tab query which works fine. I also have made a report which is based on this cross-tab query. Due to nature of the cross-tab querythe Value column(s) is dynamic. The report I made is based on all available data types which makes the number of columns change based on availabilityof data point(s)(columns). The report works if all data type is available but the report fails if some of the data types are not available (i.e columns are missing due to not having any value or data).... I hope I am explaining this correctly,
Is there a way I can use expressions in the report to place a conditional clause that if the Control Source(i.e column) doesn't exist place a Null or 0 in the report or in its place.
Regards
Ardy
I have made a cross-tab query which works fine. I also have made a report which is based on this cross-tab query. Due to nature of the cross-tab querythe Value column(s) is dynamic. The report I made is based on all available data types which makes the number of columns change based on availabilityof data point(s)(columns). The report works if all data type is available but the report fails if some of the data types are not available (i.e columns are missing due to not having any value or data).... I hope I am explaining this correctly,
Is there a way I can use expressions in the report to place a conditional clause that if the Control Source(i.e column) doesn't exist place a Null or 0 in the report or in its place.
Regards
Ardy