Cross tabs

Drexl

Is it possible to make something like a crosstab and if so is there a limitation to the numbers of columns?

Thanks!

RobertMo

crosstab ?!? are you looking for "matrix forms" functionality ?

Drexl

RobertMo wrote:

crosstab ?!? are you looking for "matrix forms" functionality ?

Something like that but I need it for a report and I believe you can only use the matrix box for forms.

I want to know if it's possible to make a report in which the number of colums and rows can vary from report to report. I think I read somewhere there's a limit to the number of columns and I like to know what that number is.

Thanks!

Timo_Lässer

I think you must use an array to solve your problem.

:idea: :arrow: Create a simple report by using the wizard for the customer table which will generate address labels.
Take this report and have a look how to handle data in arrays.

Drexl

Timo Lässer wrote:

I think you must use an array to solve your problem.

:idea: :arrow: Create a simple report by using the wizard for the customer table which will generate address labels.
Take this report and have a look how to handle data in arrays.

Thanks!

So cause you can use an array there's no limit to the number of colums?

RobertMo

you will have to add columns at design time. is is not possible to add them at runtime...

Drexl

RobertMo wrote:

you will have to add columns at design time. is is not possible to add them at runtime...

OKay great, but does this mean there is a limit to the number of columns? I'm trying to find that out. I remember reading it somewhere but I can't remember where.

RobertMo

YES, you can add as many columns as you like (as far as I know), but how will then this report look like ? it will be very wide, and even if you fill in only values for first few columns, it will allways show all 100 columns... (unless you also add 100 sections, each with one column more, and showing only one of the sections...)

an NO, if you at design time put 100 columns, you cannot add 101-st in the run-time...