mibuso.com

Hi,

I just had a conversation with the MBS-Support, according to the problem to have something like "page# of totalpages" on a report.

The person I was talking had a good idea, and for me this works.

Here's the Code-Sample:

// BEGIN of Sample

CLEAR(TestReport);
TestReport.SAVEASHTML('c:\test.html');

// Call a function in the report that returns
// "CURRREPORT.PAGENO" after the SAVEASHTML has finished
PageCount := TestReport.ReturnTotalPages;
CLEAR(TestReport);

// Call a function in the report an use the PageCount
// as Parameter
TestReport.DefTotalPages(PageCount);
TestReport.RUN;

// END of Sample

"TestReport" is a Variable of type Report.
"PageCount" is a Variable of type Integer


Hope this helps.

Bye,
Rolf

Good idea, although it costs double running time.
And you should delete the file in the end to clean up.

i also thought about a solution like this ... but i was scarred by the long runtime (twice as 'normal' )

but if you do so you also should save the file in the temp-directory of the pc (for this use ENVIRON('TEMP'); )

I know it will take the double running time.
The Code should only be a sample, it is not "clean" code.

But this solution is the only way, to get the exact total number of pages (official statement of Navision-Support).

To count the records that will be printed an than calculate the number of pages that will be used, only work for simple list-style reports.

This topic could be part of Tips and Tricks

It's an stunning idea for an old issue. But, is it possible to delete repotely the same file? Above all you don't want your company's reports to be left on the local net.

And about the time: does it cost the same to print in Navision rather than to html? We use hand-made reports for inventory because in some branches of my company the Inventory Valuation takes more than a work-time day.

well the second run can be even faster, because some data can remain in buffers...

It is an idea but it does not take the printer characteristics into acount. The same report may apear different on two different printers.

thanks a lot for the solution. It works!

This implementation has issues in counting the pages properly. Report might be one page and it counts two, or the other way around...

Anyone can figure out why?

could you explain me what functions DefTotalPages(PageCount) does?

But where to write these code
"TestReport.SaveAsHtml....."

Have a look at this: http://www.mibuso.com/dlinfo.asp?FileID=752

dear all,
I can run the solution and saveashtml in Form object. But how can i use saveashtml in report. For example, when i run Purchase Order report, i cant use currReport.saveashtml. The common demand show the total page when preview the report and we need to put the saveashtml function in report trigger. Can anyone give a example.
I tried on the triggers of a report, but cant work
Thanks a lot

SaveAsHtml command can only be used with a report variable or as a method of the REPORT. So you cannot use it inside the report itself.