Cross Tab Report Vs Dynamic coulmns

[ardy]

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 (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 doesn’t exist place a Null or 0 in the report or in its place.

Regards
Ardy

 

[JHB]

..
Is there a way I can use expressions in the report to place a conditional clause that if the Control Source doesn’t exist place a Null or 0 in the report or in its place.

The short answer is NO!
If you want to show the report in "Print Preview" or print it out directly, you can use some VBA code on the report's format event, to make the controls unbound.
If you want to show the report in "Report View", the report's format event isn't fired, then you need another solution like some fake data (0 or null) to get all necessary fields/columns show up in the query.
If you can't get it, then post your database with some sample data, (zip it) + info in which report you've the problem.

 

[ardy]

For a moment I thought I am alone,,........

Thanks JHB for the reply, been reading a bunch since my post, I came to the same conclusion, I think the easiest way out of this is to back fill the data with zero before the report even gets activated.......