How to Create Dynamic Cross-Tab Query Reports?

[Moah Scout]

Hi!
I have a crosstab Query with constant RowHeadings and Dynamic Column Headings. This Query is used as a record source for the reports as follows:
RowHeadings includes:
1. CustoName
2. CustoID
3. Products(SumOFProducts)

Column Headings includes:
ColumnHeadings.

The problem is, with my Reports layout created with three ProductsName on the ColumnHeadings, I cant use the same layout with five ProductsNames on the Column Headings. E.g

CustoID CustoNAME Products ColHead1 ColHead2 ColHead3
  1      John       5        Tomato  Cull      Maize
  2      Jack       0        Cull    Mave      Nano
 

When the number of ColHeads increased from three to five or six, it cant appear on the myreports. I sometimes add the extra Column Manually,
Is there any other alternative of adding the extra Column automatically on the same layout?

[repath]

Hi Moah Scout,
as per my knowledge, reports are not dynamic:

Hence you should have code to place the number of required controls as headers in header section and text boxes in the detailed section so that they are automatically populated. (but at the contents grow, this becomes too illegible to read.

the following link may be of some help:
http://bytes.com/topic/access/insigh...port-using-vba

With regards
Repath Athyala
www.Repath.WordPress.Com

[Moah Scout]

Thanks!
I know that contents of dynamic report of MMcarthy, Nuco and Shap but couldnt settle my problem. The number of columns changes in my case, and I want to keep the same template!
I have three RowHeadings (do not Change) but the number Column headings changes from 3 to 27. When the templates prepared with three colHeading it wont function with 20columnHeadings.
I know I need a code on this but how?
please help!

[Moah Scout]

Being quite to this extent!
Does it mean impossible? I dont think so!!!
Should you think you need more clarification on this question, I will