Cross Tab Report Vs Dynamic coulmns

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top