Ok, I am working with the report tool of Navision. I have just learned that the height limit of a report is 1 meter. I have just reached the limit of my report and since this, my report is acting strangely. I got some page break where i’m not supposed to get. Is there some kind of link between the strange behaviour of my report and the height limit of Navision reporting tool? Or is it some kind of proprety that could the cause? By the way, I’ve got like 79 different sections in my report. Is it too big? Thank you for your response.
That is one BIG report. I have seen reports go berserk when pushed passed a certain limit but nothing too specific. Do you really need that many sections? Can’t you find a different design approach? What will happen when you or someone else needs to change this report in a few months time?
Hehe - this surely must be a joke…[:D]
Well this is not my report, it is one of my co-worker. But I can assure you that this not a joke, she got like 79 sections. I don’t know if she can find another way to do this, I hope so… Thx guys
Hmmm. Sounds like she should rethink the design. Maybe split the report into separate reports.
Yeah I think that’s her plan right now. I think it was 6 reports before but the boss asked to do one with these… Looks like it isn’t the right solution.
It is ALWAYS better to redesign a bad design, than contiinue hacking a bad design. Why don’t you let us into the secret of WHAT you are trying to do, rather than the how, then we can help with the design.
Hi Dominic What exactly is the report supposed to do. I have created a report which is one line short of the 1m limit, and it contains 82 sections, This report is only a one page summary report.
Hi Stephan, once you get to this level of a report for summary information, it really means that by now you should have developed a new posting journal to create a data structure the way the report needs it. So for instance, if it is a sales summary report, then you work by creating a ne ledger table with a summary header that contains the data that you need to report on, then you create a journal and posting routine that populate the entry table, then call the post routine when recording sales (eg cu 80 or 12 or 22). You definitely have the skill set to be able to do this, but if you need help … just holler.
Correct David. We have exactly this situation and used the basic idea you describe.
David, Nelson I agree with you 100%. In the Ideal world this would of been created in the “Account Schedules”. But as the client didn’t want to use A.S., and the way the Accounts had to be sorted and totaled, this was about the easiest (and the costliest way for the client, their choice) and made the report very inflexible. The customer is always right even when…