info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Cross Tab Report Vs Dynamic coulmns
5 views
Skip to first unread message
Ardy Ghoreishi
Apr 23, 2014, 9:49:18 AM4/23/14
to
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 query the 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 availability of 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 query the 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 availability of 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
0 new messages