Dynamic Columns In A report

I want to create a report that has columns based on records. So the columns of the report have to grow or shrink depending on the number of records. Can this be done? Can Navision reiterate horizontally on a report? Any advise, tips or help are more than welcome.

Hi, No, you have to write the code(logic) according to your requirements.

In these situations, it may be best to try outputting to MS Excel. Attain 3.60 has a very nice table T370:Excel Buffer that takes the strain out of coding for excel. If you’re using 2.60, you may be able to import the above table from a 3.60 db as there are no dependancies on other modules. You would still code a report, but each iteration would create entries in the excel buffer. G/L Budgets has an example which you could use to get an idea of how to implement it. Regards, Edward.