Report Section Limit

PavlosPavlos Member Posts: 19
Hi Navision People,

I've just came across a limitation of reports in Navision. Here comes my little story...

One day I was asked to add a column to an existing custom report. Sounds nice and easy. Unfortunately when I did design on the report I discovered that it has about 30 Data Items (maybe more) and more than 100 sections!!! I wanted to meet the guy that created this report! Anyway after few hours I’ve manage to add the new column to the visible sections till I realize that the visible sections was about 97 but the total sections of the report are more than 100. I’ve discovered that there are sections that I was not able to see in the section designer. I realize that when I did preview on report and see a sections that it was not visible in the section designer. I was able to see these sections when I’ve deleted some, visible in the designer, sections. Here comes my question, is there any way to view the rest sections. I know your advice will be to delete the whole report but this is not possible for the time being.

Thanks in advance.

Comments

  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    The limit is the reportdesigner has been there for many years. But I have not yet found a workaround.

    Maybe you can export to txt file, remove some sections, import, change the sections and then put the sections back in via textfile... :-s
  • colingbradleycolingbradley Member Posts: 162
    I came across this limit some time ago and then decided on a different way of achieving the same end.

    I needed to show a different layout and data dependent on conditions.

    I now use variables and just one or two sections.
    The number of variables is not limited so no more problem.
    Experience is what you get when you hoped to get money
  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    It will al be better in nav 5 O:)

    [-o<

    :mrgreen:
Sign In or Register to comment.