Cross tabs

Drexl
Drexl Member Posts: 16
edited 2004-06-04 in Navision Attain
Is it possible to make something like a crosstab and if so is there a limitation to the numbers of columns?

Thanks!

Comments

  • RobertMo
    RobertMo Member Posts: 484
    crosstab ?!? are you looking for "matrix forms" functionality ?
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • Drexl
    Drexl Member Posts: 16
    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
    Timo_Lässer Member Posts: 481
    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.
    Timo Lässer
    Microsoft Dynamics NAV Developer since 1997
    MSDynamics.de - German Microsoft Dynamics Community - member of [clip]
  • Drexl
    Drexl Member Posts: 16
    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
    RobertMo Member Posts: 484
    you will have to add columns at design time. is is not possible to add them at runtime...
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • Drexl
    Drexl Member Posts: 16
    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
    RobertMo Member Posts: 484
    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...
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

Categories