updaing report fields from a crosstab query

[Paranap]

Hi.



I have a Report from a crosstab query. This query is showing dates for when training is due for a number of different skills for a number of different people. The report I have works fine but when I add a new skill the report doesn't update as it is a new field. Is there any way for it to auto update so it shows all the fields from the query or is there another way of doing it.

Cheers

[ranman256]

There's no 'auto' update, but it can be coded. IF you know vb code you can modify my example to fit your needs.
It reads a sample row, collects the headers, then assigns the fields to the headers. This happens at report_open event.
BUT IT IS ADVANCED CODE.

dynamicXtabRpt.zip

[Paranap]

Hi
I know a bit of vb but your right it is a bit advanced, can you give a few pointers to help intergrate what you've done into my db

[ranman256]

Import the report, rDynamicRpt
and the class object, cDynamicRpt

set the report to your query.

In the REPORT-OPEN event is code
RecordSource = "qxNAMES_Crosstab"
change it to your query.

You MAY have to add text boxes and labels. They must be named like the others.
box1 is lbl1 and box1
then lbl2, box2
etc.
to add pick up where the last box# left off via properties.

like I said, it's advanced.