Hi Tim.I forgot about the reset page number.This is excellent!Thank you
sir!Ed.Sent from my mobile device.
-------- Original message --------From: Tim Rude <[email protected]> Date:
7/19/19 2:03 PM (GMT-08:00) To: [email protected] Subject: Re:
[Dataperf] How to print Total page count in report.
Yep, I'd use an RV, initialize it to 1 in the ---First Page Header--- of the
1st subreport iteration (the the non-printing page-counting phase) and then add
1 to the RV in the ---Other Page Header--- section of that same subreport.
That's about as simple or
elegant as you're going to get. While you can print the page number using
Ctrl-F7,1,3 there's no way to store the current page number into a RV otherwise.
Also, remember at the beginning of the 2nd subreport iteration (the actual
printing phase) to use Ctrl-F7,1,6 to set the page number back to 1 in the
---First Page Header--- section so that Ctrl-F7,1,3 gives you sensible page
numbers.
Tim Rude
On 7/19/2019 2:24 PM, Ed Marfil, MAST UNITED wrote:
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
I’m thinking I could have an RV value of 1 at every start of new page (no print
report) and added to a numeric field in the panel to keep a total page count,
which value can then be used for the 2nd run of the report (printed report).
This seems clunky and complicated so if anyone has a simpler or more elegant
way to keep a total page count in an RV please kindly advise.
Thanks,
Ed.
From: Dataperf [mailto:[email protected]]
On Behalf Of Ed Marfil, MAST UNITED
Sent: Friday, July 19, 2019 8:41 AM
To:
[email protected]
Subject: Re: [Dataperf] How to print Total page count in report.
Thank you Tim and Richard for this info. I do have values in the report that
updates data but I think I can get around that.
I tried to see where I can store the last page number or total pages in an RV
but can’t find a feature for this.
Any suggestions?
Ed.
From: Dataperf [mailto:[email protected]]
On Behalf Of Richard Bragonje
Sent: Friday, July 19, 2019 6:56 AM
To: [email protected]
Subject: Re: [Dataperf] How to print Total page count in report.
Hi Tim, and Ed,
Dredging thru my DP archives (in Eudora), i found this, from a fellow named
"Tim Rude", with a follow up from Ralph Alvy.
Subject: Page numbers & reports...
Date: Wed, 28 May 2003 10:06:08 -0500
From: "Jay Diekmann" <[email protected]>
To: DataPerfect Users Discussion Group <[email protected]>
Hello,
I am attempting to put a "Page *** of ***" in a page footer in a report. It is
obvious how to get the first field, but how do I obtain the number for the
second field? Any help is appreciated.
Thanks,
Jay Diekmann
--
From: "Tim Rude" <[email protected]>
To: DataPerfect Users Discussion Group <[email protected]>
Subject: Re: Page numbers & reports...
Date: Wed, 28 May 2003 22:43:25 -0500
Jay,
DP doesn't know how many pages there will be until they've all been
processed. It doesn't formulate the entire report in memory and then output
it. It outputs it on the fly as it creates it.
That being the case, the only way you could know the total number of pages
to put in the page footers would be to process the entire report twice. The
first time you turn off output to the printer (or send it to NUL) and keep
track of the page total. Then process the report again with output going to
the printer.
This should work as long as all your report is doing is displaying data. If
you're using the report to update any database fields while processing you
might not want to have it happen twice.
The easiest way to accomplish this double-run thing is to run the whole
report inside a subreport. In the outer report shell, turn off Printer/File
output for the first iteration. Store the total number of pages the report
used after the subreport finishes. Then turn back on Printer/File output and
repeat the subreport, using the newly calculated total in the page footers.
Tim Rude
Date: Wed, 28 May 2003 22:00:47 -0700
From: Ralph Alvy <[email protected]>
To: DataPerfect Users Discussion Group <[email protected]>
Subject: Re: Page numbers & reports...
You must create a report that essentially runs twice. The first time it
determines the total number of pages, and stores that number in an RV,
but fails to print anything at all. The second one prints all the data.
You do this by making two *sub*reports that do the above. They are
*parallel* subreports, not *nested* subreports. The parent report runs
on a single record and then stops, since after a single parent report
record, the two subreports have finished their work.
--
Ralph Alvy
[email protected]
Subject: Page numbers & reports...
Date: Thu, 29 May 2003 07:09:49 -0500
From: "Jay Diekmann" <[email protected]>
To: DataPerfect Users Discussion Group <[email protected]>
Hello,
I am attempting to put a "Page *** of ***" in a page footer in a report. It is
obvious how to get the first field, but how do I obtain the number for the
second field? Any help is appreciated.
Thanks,
Jay Diekmann
--
--
Rich Bragonje - Database Specialist
[email protected]
304/293-8783
FAX: 304/293-2441
West Virginia University
Appalachian Hardwood Center
PO Box 6125
Morgantown, WV 26506-6125
From: Dataperf <[email protected]>
on behalf of Tim Rude <[email protected]>
Sent: Friday, July 19, 2019 8:44 AM
To: [email protected] <[email protected]>
Subject: Re: [Dataperf] How to print Total page count in report.
There's no way to know how many pages the report will take until it's finished
running. So the only way I could envision doing it in DP would be to
run the report twice inside two consecutive subreports. The first instance
wouldn't actually output anything but would simply go through the motions to
count the number of pages. Then the second iteration would generate the output
and show your page count
total as desired.
Tim Rude
On July 18, 2019 12:47:35 PM CDT, "Ed Marfil, MAST UNITED"
<[email protected]> wrote:
Hello All,
Is there a way in DP reports to print on each page the total number of pages in
the report?
For example, can the report state this page is 1 of 27 pages, 2 of 27 pages,
etc.
Hopefully someone’s already done this and could please share the how.
Thanks all.
Ed.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/cgi-bin/mailman/listinfo/dataperf
