crosstab query report

[tselie115]

hello guys im trying to make a report based on a cross tab query.
the number of columns is dynamic in the query.whereas its not on the report.
i have read some articles about adding unbound textboxes and assigning the column values "on open" of the report.this doesnt work for me since i cannot predict the number of columns so i need the columns to be added dynamically on the report along with their values.
can anybody guide me please?

 

[Kiwiman]

Howzit

You can use the ColumnHeadings property (from the query right click on the column field and select properties) setting to always display data, even if there is no data.

The crosstab query will then only return the data that you enter as headings and nothing else. So you can specify all likely returns and build your report on this.

It will return it in the order that you enter them, so you can control the order somewhat.

 

[tselie115]

i think you missunderstood me!my columns headings on the crosstab query is the jobs which are added with time.
what im trying to say is that everytime a job is added as record on my main form, its gona be added as a new column in the query and therefore i want it to be added dynamically(on its own in the report) along with other jobs(columns) before.