Report header and footer doubt in Nav Report

Niceguy1978

Hi All,

I am a new user in Dynamic Nav 2009, whereby I am facing some issue and need to clarify.
1) Can I design multiple report header? and user just select which to use when generate report?
2) Can I change the footer page number style from Page 1, Page 2 , etc to Page 1 of 5, Page 2 of 5 and etc?

Hope someone can enlightern me on that. Thanks sincerely.

krzychub83

1) Can I design multiple report header? and user just select which to use when generate report?

Yes, you can do it. In classic client reports you are ablet to show/hide sections (including headers) by CurrReport.SHOWOUTPUT();. Then you need to pass true/false as a parameter to that function to show/hide any section.
On the Request Form you can add an option/checkbox based on which your users will be showing/hiding sections on the report.

2) Can I change the footer page number style from Page 1, Page 2 , etc to Page 1 of 5, Page 2 of 5 and etc?

Not out of the box. Basicaly NAV does not know at the first page how many pages will be printed. Some kind of solution would be to print that report twice. First time to an xml file just to force system to recalculate everything (including global variable which was added to hold total page count). Then you call that report to get/set total page count. Then you can print that report one more time, however this time to printer and including total record count.
Personally if any customer would request it from me I would tell him that this is not possible. You will need to execute one report twice to get page count. This is huge waste of processing power just for the total page count...

Good luck
KB

Niceguy1978

krzychub83 wrote:

1) Can I design multiple report header? and user just select which to use when generate report?

Yes, you can do it. In classic client reports you are ablet to show/hide sections (including headers) by CurrReport.SHOWOUTPUT();. Then you need to pass true/false as a parameter to that function to show/hide any section.
On the Request Form you can add an option/checkbox based on which your users will be showing/hiding sections on the report.

Hi KB, Thanks for the guidance given. May I ask another question? Are you means that only 2 report header can be use when using the method above? Since I plan to use different address to categorise the report for the report and there is about 5 address. Do you have any other suggestion? Thanks sincerely.

krzychub83 wrote:

2) Can I change the footer page number style from Page 1, Page 2 , etc to Page 1 of 5, Page 2 of 5 and etc?

Not out of the box. Basicaly NAV does not know at the first page how many pages will be printed. Some kind of solution would be to print that report twice. First time to an xml file just to force system to recalculate everything (including global variable which was added to hold total page count). Then you call that report to get/set total page count. Then you can print that report one more time, however this time to printer and including total record count.
Personally if any customer would request it from me I would tell him that this is not possible. You will need to execute one report twice to get page count. This is huge waste of processing power just for the total page count...

KB

Thanks I understand this. Will try first cause this is 1 of the mandatory characteristics for that particular report.

Billy.

krzychub83

Hi Billy
1. You can have as many sections as you only wish (regardless of type - body, header, group header, etc). I haven't see any limitations related to the section's number.

However please be aware that large section count might affect your invoice layout. Simply saying for each section NAV is pre-saving some space on the page. This is done even for hidden sections (for example when you used SHOWOUTPUT(FALSE)). I would guess that this is related to the way how NAV is calculating free space on current page. Thus it may happen that sometimes an invoice footer will be moved to the new page instead of being printed on the current page (even if there is enough 'empty space' on the current page to fit the footer). At least this is what I have noticed.

What you can do is:
1. Use an Option global variable/combined with a textbox on the Request Form, where all header types will be available to chose from.
2. Create a button for each header option on the caller object. Each button would trigger the report to be executed with different header.
3. Set the header option based on the customer type, etc…
… or combine them into one solution.

2. Printing a report to xml file is some kind of workaround, but I would never use it. The cost of getting this information from the system it to big. NAV is a very flexible product, but you cannot have everything. BTW: During the implementation almost everything is a key requirement.
Good luck
KB