August 04, 2005, 08:26 AM
Nigel L.Printing Page numbers in a compound report
Hello all,
I am new to Webfocus, and have a question relating to printing page numbers on a compound report.
My scenario.
I have a compound report that is built up from 4 reports. I would like the page numbers to be printed at the bottom of each page.
The report is COMPOUND OPEN NOBREAK, as the users require to see all individual reports following on from one another.
As the physical page break can occur on any of reports 2,3 or 4, how do I code in the page break to appear at the bottom of the page.
I have seen that this topic has been looked at before, and I have tried to use the code/variables shown. My problem with them, is it appears to place a page number at the bottom of each report, and not just at the bottom of the physical page.
Am I doing something wrong. Any help would be much appreciated.
FYI, we are using 5.3.3
Regards
Nigel
August 04, 2005, 01:04 PM
PrarieSET PAGE-NUM=OFF At the top of report
Then add this footing.
FOOTING BOTTOM "<20><TABPAGENO"
You will have to play with the position of the page number. Also...I do no know if this works on a compound report...but here's a start for you.
August 05, 2005, 08:42 AM
Nigel L.Thanks Prairie.
Whilst that works fine for most reports, it does not really work for a COMPOUND NOBREAK report as it seems to place the page number on the footer of each part of the report as opposed to just at the bottom of the physical page.
As each sub report can finish anywhere on the page, I only want the page numbers to be printed once on each page.
August 05, 2005, 09:29 AM
Tony ANigel,
As you have found, using <TABPAGENO and <TABLASTPAGE issues page numbers by report not by physical page. That is because the code is held within each report individually and not related to the whole compound report.
You need to SET PAGE-NUM=ON to get page numbering for physical pages. Unfortunately you do not have much control over placement or styling of the page numbers though
. They will always be top left of each page and will be tha format - PAGE 1 - etc.
July 25, 2007, 02:18 PM
PrarieDoes anyone know if in the latest and greatest version of WebFocus if you can do a
TABPAGENO of TABLASTPAGE in a Compound Nobreak PDF report that actually works on the pages rather than the report??
 | In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
July 25, 2007, 05:32 PM
FrankDutchPrarie
I was in Las Vegas in one of the hands-on labs and we have build a compound PDF with page numbers and a index page. so yes it must be possible. The details on how this should be dome? I hope it is in the manual.
|
Frank |
|
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7 |
August 01, 2007, 11:12 AM
PrarieAccording to 7.6 Documentation
TABLASTPAGE is supported only for a single report, not pooled or compound reports. A separate page count is generated for each report in a compound report.
Frank - I tried to build a compound PDF report in the PDF painter...and did come up with an Index page - But I'm not one to ever use the GUI...so that did not seem to solve my problem or I did not know what to click on.
Anybody have a thought on how to
cheat to get Page of Pages on a compound PDF report?? The report I have has about 12 reports in one that changes daily and total page count ranges from 20 to 50 pages. This was converted from a Crystal Report...and the user insists if Crystal can do it...why not WebFocus.
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
August 01, 2007, 02:10 PM
jamieIn WebFOCUS 7.6, the PDF Layout Painter has an 'Add Page Master' option, where you can insert different pagination options inside a text box within that Page Master.
Page options are Page #, Total # of Pages, and Page n of n
This is also in the 7.6.1 documentation,
http://documentation.informationbuilders.com/masterinde...61appsgt/topic62.htmJamie
August 01, 2007, 03:41 PM
PrarieWell thanks so much..
It helps to know where to click. That did actually put page of page in a test compound report....now to apply in real life.
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
August 01, 2007, 04:15 PM
FrankDutchPrarie
I see you have build a compound report 20-50 pages, but how many compounds? graphs also and page and foot headers? overflow pages?
I have large problems to get it done and the GUI always hangs the PC.
Some advices??
|
Frank |
|
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7 |
August 02, 2007, 09:01 AM
jamieIn 7.6, have you tried setting the Preview Settings (under the Tools -> Settings option of the PDF Layout Painter) to Simulated Data instead of Live Data?
Documentation is on page 272 at this location -
http://documentation.informationbuilders.com/masterinde...psgt/wf761appsgt.pdfJamie
August 02, 2007, 09:56 AM
PrarieWell I had to go count...this particular one has 26 compound reports in it....with loops!
I inherited this one. It has lots of subheads and subfoots..no graphs...it was not built in the GUI and has had numerous problems in the past. I actually could write a book about it. I've had to adjust widths, put in wraps. This one works good for the Blog fields that are in it.
WIDTH=6.5.
The original report was just a series of -INCLUDES...But that became impossible to maintain...so I put them all in one..and tried to sink them up.
What are some of you particular problems?
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
August 02, 2007, 02:17 PM
FrankDutchWell a good manual written by a WF master....
I think I can too and I will start writing it for myself. The experiences I have got in the last few weeks are important to build new reports.
I have created some one page and some multi page reports, with included table and graphs.
The GUI was a nice start, but once it is build you can not reopen it, so I needed to go into the script.
The next step now they work will be how to send them via RC.
|
Frank |
|
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7 |
August 02, 2007, 05:20 PM
PrarieOh...That's another book...just cause it works when you run it...can be another story in ReportCaster...my favorite error that only happened in ReportCaster...but was fine manually.
COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 1
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
August 29, 2007, 12:10 PM
Linda101I need to put a page n of n on my pdf compound report, so I create a page master and include my compound report by using refrence existing procedure. The compound report runs okay by itself, but after I include it in the PDF layout painter, it only shows the page 1 of 1 and the first line of report which is currrent date ...rest of report goes blank.
Please advise, thanks!
Linda