Why when I have compounded pages of different reports some of the pages look like if the text is shifted slightly down. For example:
If I have a table with 2 rows and 2 columns, the text is supposed to appear in the cell... but sometime i see the text in the cell, but practically sitting on the cell's bottom line.
Does this make sense? Why does this happen? Is there someway to fix/prevent this from happening?
Any ideas?
June 10, 2005, 07:25 PM
reFOCUSing
Can you post your code? Can you make it happen using the CAR table? What version of WF are you using?
I would be really interest to see this since our reports are normally all PDF.
June 10, 2005, 08:33 PM
slfmr
I don't think I can make it happen using the car file, but I will see what I can do.
I am using WF Verion 5.2.6 (as well as 5.3). It happens in both.
I will see what I can do about getting code to you.
Thanks so much.
June 10, 2005, 08:53 PM
reFOCUSing
Cool, if you can get it happening on the CAR table I will test it on WF 7.1 and see if the problem is fixed there.
June 14, 2005, 02:48 PM
slfmr
Okay, this didn't quite do what was happening to me (since my r eports are approx. 50 pages long and it happens randomly). BUT you can see that the words look like they are higher in the cell than in the following tables (when you run it), than in the first table. It looks as if the data/words are shifted and the table stays in the same area.
The ouput is like the table top line and then the word starting practically on the line. Let me know what you think. Thank you DEFINE FILE CAR NUM/A50=IF SEATS EQ 4 THEN CAR; NUM2/A50=IF SEATS EQ 2 THEN CAR; CONCAT/A101=NUM || ( ' ' | NUM2 );
COMPARE/A50=IF NUM EQ NUM2 THEN BODYTYPE ELSE ' '; END TABLE FILE CAR HEADING "Car Report" "As of &DATEtMDYY <+0>" "4 Seater vs 2 Seater" PRINT NUM AS '4 SEATER' NUM2 AS '2 SEATER' BODYTYPE AS 'BODY'
BY CAR AS 'CAR' ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK ON TABLE SET HTMLCSS ON ON TABLE SET STYLE UNITS=IN,
PAGESIZE='SCREEN', LEFTMARGIN=0.15,
RIGHTMARGIN=0.15,
TOPMARGIN=0.10,
BOTTOMMARGIN=0.10,
SQUEEZE=ON, O RIENTATION=PORTRAIT, $ TYPE=REPORT,GRID=ON,FONT='ARIAL', SIZE=10, COLOR='BLACK',BACKCOLOR='NONE',STYLE= NORMAL,RIGHTGAP=0.125000,TOPGAP=0.013889, BOTTOMGAP=0.027778,$ STYLE=NORMAL,$ TYPE=HEADING,LINE=1,GRID=OFF,SIZE=20, STYLE=NORMAL,JUSTIFY=CENTER,$ TYPE=HEADING,LINE=2,GRID=OFF, SIZE=14,STYLE=NORMAL,JUSTIFY= CENTER,$ TYPE=HEADING,LINE=4,GRID=OFF, SIZE=16,STYLE=NORMAL,$ TYPE=TITLE,STYLE=BOLD,SIZE=12,$ ENDSTYLE END TABLE FILE CAR PRINT COUNTRY CAR MODEL
DEALER_COST
RETAIL_COST WHERE ( COUNTRY EQ 'USA' ) ON TABLE HOLD AS CAR1 END -TYPE LINE = &LINES -TYPE RECORDS= &RECORDS
-IF &LINES EQ 0 THEN GOTO OUT_NO ELSE GOTO OUT_YES;
-OUT_YES TABLE FILE CAR HEADING "USA Manufactured Cars" PRINT MODEL AS 'Model RETAIL_COST AS 'Retail Cost'' DEALER_COST AS 'Dealer Cost BY CAR AS 'Car' ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTA ON TABLE PCHOLD FORMAT PDF NOBREAK ON TABLE SET HTMLCSS ON ON TABLE SET STYLE UNITS=IN,PAGESIZE='SCREEN', LEFTMARGIN=0.15, RIGHTMARGIN=0.15,TOPMARGIN=0.10, BOTTOMMARGIN=0.10,SQUEEZE=ON, ORIENTATION=PORTRAIT,$ TYPE=REPORT,GRID=ON,FONT='ARIAL', SIZE=10,COLOR='BLACK', BACKCOLOR='NONE',STYLE=NORMAL, RIGHTGAP=0.125000,TOPGAP=0.013889, BOTTOMGAP=0.027778,$ TYPE=HEADING,GRID=OFF,SIZE=16, STYLE=NORMAL,$ TYPE=TITLE,STYLE=BOLD,SIZE=12,$ ENDSTYLE END
-OUT_NO DEFINE FILE CAR OUT_FIELD/A2000 WITH CAR = 'Not Applicable'; END TABLE FILE CAR HEADING USA Manufactured Cars" PRINT OUT_FIELD AS ' ' WHERE RECORDLIMIT EQ 1 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF NOBREAK ON TABLE SET HTMLCSS ON ON TABLE SET STYLE UNITS=IN,PAGESIZE='SCREEN', LEFTMARGIN=0.15, RIGHTMARGIN=0.15, TOPMARGIN=0.10, BOTTOMMARGIN=0.10, SQUEEZE=ON,
ORIENTATION=PORTRAIT, TYPE=REPORT,GRID=OFF,FONT='ARIAL', SIZE=10,COLOR='BLACK',BACKCOLOR=' NONE',STYLE=NORMAL,RIGHTGAP=0.125000, TOPGAP=0.013889,BOTTOMGAP=0.027778,$ TYPE=HEADING,GRID=OFF,SIZE=16,STYLE= NORMAL,$ TYPE=TITLE,STYLE=BOLD,SIZE=12,$ >ENDSTYLE END TABLE FILE CAR PRINT COUNTRY CAR MODEL DEALER_COST RETAIL_COST WHERE ( COUNTRY EQ 'JAPAN' ); ON TABLE HOLD AS CAR2 END
-TYPE LINE = &LINES TYPE RECORDS= &RECORDS IF &LINES EQ 0 THEN GOTO NO_JAPAN ELSE GOTO OUT_JAPAN; -OUT_JAPAN TABLE FILE CAR HEADING "Japan Manufactured Cars" " " PRINT MODEL AS 'Model' RETAIL_COST AS 'Retail Cost'' DEALER_COST AS 'Dealer Cost' BY CAR AS 'Car' ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF NOBREAK ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN,PAGESIZE='SCREEN', LEFTMARGIN=0.15,RIGHTMARGIN=0.15, TOPMARGIN=0.10,BOTTOMMARGIN=0.10, SQUEEZE=ON,ORIENTATION=PORTRAIT,$ TYPE=REPORT,GRID=ON,FONT='ARIAL', SIZE=10,COLOR='BLACK',BACKCOLOR='NONE', STYLE=NORMAL,RIGHTGAP=0.125000, TOPGAP=0.013889,BOTTOMGAP=0.027778, />TYPE=HEADING,GRID=OFF,SIZE=16, STYLE=NORMAL,$ TYPE=TITLE,STYLE=BOLD,SIZE=12,$ ENDSTYLE END -NO_JAPAN DEFINE FILE CAR OUT_FIELD/A2000 WITH CAR = 'Not Applicable'; END TABLE FILE CAR HEADING "Japan Manufactured Cars " PRINT OUT_FIELD AS WHERE RECORDLIMIT EQ 1 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF NOBREAK >ON TABLE SET HTMLCSS ON ON TABLE SET STYLE UNITS=IN, PAGESIZE='SCREEN', LEFTMARGIN=0.15, RIGHTMARGIN=0.15, TOPMARGIN=0.10, BOTTOMMARGIN=0.10, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ SIZE=10,COLOR='BLACK',BACKCOLOR='NONE', STYLE=NORMAL,RIGHTGAP=0.125000,TOPGAP =0.013889,BOTTOMGAP=0.027778,$ NORMAL,$ ENDSTYLE
TABLE FILE CAR PRINT
COUNTRY CAR
MODEL DEALER_COST RETAIL_COST WHERE ( COUNTRY EQ 'GERMANY' ); ON TABLE HOLD AS CAR2 END
-TYPE LINE = &LINES -TYPE RECORDS= &RECORDS -IF &LINES EQ 0 THEN GOTO NO_GER ELSE GOTO OUT_GER; -OUT_GER
TABLE FILE CAR HEADING
German Manufactured Cars" PRINT MODEL AS 'Model' RETAIL_COST AS 'Retail Cost'' DEALER_COST AS 'Dealer Cost' BY CAR AS 'Car' ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF NOBREAK ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN,PAGESIZE='SCREEN', LEFTMARGIN=0.15,RIGHTMARGIN=0.15, TOPMARGIN=0.10,BOTTOMMARGIN=0.10, SQUEEZE=ON,ORIENTATION=PORTRAIT,$ TYPE=REPORT,GRID=ON,FONT='ARIAL', SIZE=10,COLOR='BLACK',BACKCOLOR='NONE', STYLE=NORMAL,RIGHTGAP=0.125000,TOPGAP= 0.013889,BOTTOMGAP=0.027778,$ TYPE=HEADING,GRID=OFF,SIZE=16, STYLE=NORMAL,$ TYPE=TITLE,STYLE=BOLD,SIZE=12,$ ENDSTYLE END -NO_GER DEFINE FILE CAR OUT_FIELD/A2000 WITH CAR = 'Not Applicable'; END ABLE FILE CAR HEADING German Manufactured Cars" PRINT OUT_FIELD AS ' ' WHERE RECORDLIMIT EQ 1 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF NOBREAK
ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, PAGESIZE='SCREEN', LEFTMARGIN=0.15, RIGHTMARGIN=0.15, TOPMARGIN=0.10, BOTTOMMARGIN=0.10 SQUEEZE=ON, ORIENTATION=PORTRAIT, TYPE=REPORT,GRID=OFF,FONT='ARIAL', SIZE=10,COLOR='BLACK',BACKCOLOR='NONE', STYLE=NORMAL,RIGHTGAP=0.125000,TOPGAP= 0.013889,BOTTOMGAP=0.027778,$ TYPE=HEADING,GRID=OFF,SIZE=16, STYLE= NORMAL,$ TYPE=TITLE,STYLE= BOLD,SIZE=12,$ ENDSTYLE END
TABLE FILE CAR HEADING "Car Information" PRINT MODEL AS 'MODEL' RPM AS 'RPM'
BHP AS 'BHP' FUEL_CAP AS 'Fuel Cap' MPG AS 'Miles Per Gallon'
ACCEL AS 'Accelerator' BY CAR AS 'CAR' ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF NOBREAK ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN,PAGESIZE='SCREEN', LEFTMARGIN=0.15,RIGHTMARGIN=0.15, TOPMARGIN=0.10,BOTTOMMARGIN=0.10 =ON,ORIENTATION=PORTRAIT,$ TYPE=REPORT,GRID=ON,FONT='ARIAL', SIZE=10,COLOR='BLACK',BACKCOLOR=' NONE',STYLE=NORMAL,RIGHTGAP=0.125000, TOPGAP=0.013889,BOTTOMGAP=0.027778,$ TYPE=HEADING,GRID=OFF,SIZE=16, STYLE=NORMAL,$ TYPE=TITLE,STYLE=BOLD,SIZE=12,$ENDSTYLE END TABLE FILE CAR "ADDITIONAL CAR INFORMATION/>PRINT LENGTH WIDTH HEIGHT
WEIGHT WHEELBASE BY CAR AS 'CAR' WHERE (LENGTH GT 180); ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF NOBREAK ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN,PAGESIZE='SCREEN',LEFTMARGIN .150000,RIGHTMARGIN=0.150000,TOPMARGIN=0.100000,BOTTOMMARGIN= 0.100000,SQUEEZE=ON,ORIENTATION= PORTRAIT,$ TYPE=REPORT,GRID=ON,FONT= 'ARIAL',SIZE=9,COLOR='BLACK',BACKCOLOR= 'NONE',STYLE=NORMAL,RIGHTGAP=0.125000, TOPGAP=0.013889,BOTTOMGAP=0.027778,$ TYPE=TITLE,STYLE=BOLD,SIZE=12,$ TYPE=HEADING,SIZE=16,STYLE=NORMAL,GRID=OFF,$ ENDSTYLE END
TABLE FILE CAR PRINT CAR DEALER_COST RETAIL_COST SALES WARRANTY STANDARD WHERE (DEALER_COST GT 10000 ); ON TABLE HOLD AS CAR1 END
-TYPE LINE = &LINES -TYPE RECORDS= &RECORDS
-IF &LINES EQ 0 THEN GOTO OUT_NONE ELSE GOTO OUT_CARS;
-OUT_CARS TABLE FILE CAR HEADING "Cost Information" "Where Dealer Cost is Greater Than 40,000" " " PRINT DEALER_COST AS 'DEALER,COST' RETAIL_COST AS 'RETAIL,COST' SALES AS 'SALES' WARRANTY AS 'WARRANTY' STANDARD AS 'STANDARD' BY CAR AS 'CAR' WHERE ( DEALER_COST GT 10000 ); ON TABLE SET NODATA ' ' ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF CLOSE ON TABLE SET HTMLCSS ON ON TABLE SET STYLE UNITS=IN,PAGESIZE='SCREEN', LEFTMARGIN=0.15,RIGHTMARGIN=0.0,TOPMARGIN= 0.10,BOTTOMMARGIN=0.10, SQUEEZE=ON,ORIENTATION=PORTRAIT,WRAP=1,$ TYPE=REPORT,GRID=ON,FONT='ARIAL',SIZE=10,COLOR='BLACK', BACKCOLOR='NONE', STYLE=NORMAL,$ TYPE=HEADING,GRID=OFF,SIZE=16,STYLE=NORMAL,$ TYPE=TITLE,STYLE=BOLD,SIZE=12,JUSTIFY=CENTER,$ ENDSTYLE END -GOTO END_CAR ;
-OUT_NONE DEFINE FILE CAR OUT_FIELD/A2000 WITH CAR = 'Not Applicable'; END TABLE FILE CAR HEADING "Cost Information" "Where Dealer Cost is Greater Than 40,000" " " PRINT OUT_FIELD AS ' ' WHERE RECORDLIMIT EQ 1 ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF CLOSE ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN, PAGESIZE='SCREEN', LEFTMARGIN=0.15, RIGHTMARGIN=0.15, TOPMARGIN=0.10, BOTTOMMARGIN=0.10, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, GRID=OFF,FONT='ARIAL',SIZE=10, COLOR='BLACK',BACKCOLOR='NONE',STYLE= NORMAL,RIGHTGAP=0.125000,TOPGAP=0.013889, BOTTOMGAP=0.027778,$ TYPE=HEADING,GRID=OFF,SIZE=16,STYLE= NORMAL,$ TYPE=TITLE,STYLE=BOLD, SIZE=12,$ ENDSTYLE END -END_CARThis message has been edited. Last edited by: <Mabel>,
June 14, 2005, 04:25 PM
reFOCUSing
I think I see what you mean.
In the '4 Seater vs 2 Seater' report the data is at the bottom of the cell and then in all the other reports the data is at the top of cell.
June 14, 2005, 05:25 PM
reFOCUSing
slfmr, I was able to get the data to be at the bottom of the cell. I did it by removing the NOBREAK which I'm guessing you want in there to make the report smaller. I will take a look at it again later to see if I can find something else that can help you.
June 14, 2005, 06:06 PM
slfmr
Correct, if you don't compound the report, and each individual report starts on a new page, then the tables look fine... it's when they are compounded. Sometime the data might even run on top of each other in extreme cases as well as run of the page and disappear.
In turn if a lot of this happens then we get that pdf corrupted error which is not fun to deal with... which I also have a question out there about.