I have created a report which takes data from a hold file. I included this report in a html file to run with a parameter which comes from a drop down box. Running the html file gives correct report with the default selection of the parameter, but when i change the parameter to another value from the drop down box the whole report get messed up; ( Value of column1 appears in column2 , value of column 4 appears in column 3 and this is random for every row in that parameter selection):
Never seen anything like this before:
Can any one suggest what can cause this ?
Thanks
WebFocus 7.7.02 Windows, All Outputs
November 28, 2011, 11:16 AM
RSquared
Can you please post your code?
Thank You
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
November 28, 2011, 03:36 PM
Waz
Ditto...
Also screen shots or output of the messed up report if possible.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
November 29, 2011, 01:38 AM
Sunilk
Default selection report
Messed Up Report
The report runs correct when i run it as a individual procedure. but after I included it to a html report. this behaves like as shown.
I am trying to put images in this reply. but I dont know how can i brows the image file from system to upload it here.This message has been edited. Last edited by: Sunilk,
WebFocus 7.7.02 Windows, All Outputs
November 29, 2011, 04:30 AM
Wep5622
Those image links don't work, as obviously we cannot look on your hard-drive. You wouldn't want us to be able to either, I'm sure
Put them on a public web-server somewhere and use that URL for the image srcs.
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
November 29, 2011, 05:10 AM
Sunilk
This was a wired error, i must say. the report was an Active HTML report and had visulization on for a column for which i had a drill down report set. it generally used to open in the same window. i added TARGET='_blank' in the visulization part of the code as well and that fixed the drill opening in the same window issue and to my surprise also the messing up of the data for various columns. I know these two things does not co-relate ( or it does?) but now my reports' alright!!!!
the previous code:
TABLE FILE MONTCON PRINT MONTCON.SEG01.MONTH_KEY NOPRINT MONTCON.SEG01.MONTH MONTCON.SEG01.PURWAT/P12.2C AS 'Purch.' COMPUTE Accted/D12.2C = ( MONTCON.SEG01.Billed + MONTCON.SEG01.Adjusted + MONTCON.SEG01.ChgClcExp + MONTCON.SEG01.Inactive + MONTCON.SEG01.MetExp + MONTCON.SEG01.SvcOrdExp ) / 1000; AS 'Acct.' COMPUTE UnAccounted_MOG/D12.2C = UnAccted / 1000; AS 'Unacct''d Cons.' MONTCON.SEG01.UnActPct/D12.2% AS 'Unacct''d, %' MONTCON.SEG01.INCIDENT_COUNT AS 'IncCnt' MONTCON.SEG01.ACTHYDCNT AS 'ActHyd ' ON TABLE SUBHEAD "Loss by Month" " <+0>(Units in Million)" WHERE MONTCON.SEG01.YEAR EQ &YEAR; ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT AHTML ON TABLE SET WEBVIEWER ON ON TABLE SET WEBVIEWTARG OFF ON TABLE SET CACHELINES 100 ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = ENgradient_combine, $ GRAPHTYPE=DATA, COLUMN=N6, GRAPHCOLOR='RED', $ GRAPHTYPE=DATA, COLUMN=N3, GRAPHCOLOR='BLUE', $ GRAPHTYPE=DATA, COLUMN=N4, GRAPHCOLOR='GRAY', $ TYPE=REPORT, FONT='ARIAL', JUSTIFY=CENTER, $ TYPE=DATA, COLUMN=N6, FONT='ARIAL', JUSTIFY=LEFT, FOCEXEC=NONE, $ TYPE=DATA, COLUMN=N3, FONT='ARIAL', JUSTIFY=LEFT, FOCEXEC=NONE, $ TYPE=DATA, COLUMN=N4, TARGET='_blank', FONT='ARIAL', JUSTIFY=LEFT, FOCEXEC=acctwatsize( \ YEAR_MONTH=N2 \ ), $ TYPE=DATA, COLUMN=N1, FONT='ARIAL', $ TYPE=DATA, COLUMN=N8, FONT='ARIAL', FOCEXEC=NONE, $ TYPE=DATA, COLUMN=N7, FONT='ARIAL', FOCEXEC=NONE, $ TYPE=DATA, COLUMN=N5, FONT='ARIAL', JUSTIFY=LEFT, FOCEXEC=NONE, $ TYPE=DATA, COLUMN=N2, FONT='ARIAL', JUSTIFY=LEFT, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N6, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N3, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N4, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N8, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N7, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N5, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N2, FOCEXEC=NONE, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, STYLE=BOLD, $ TYPE=TABHEADING, LINE=2, OBJECT=TEXT, ITEM=2, SIZE=9, STYLE=BOLD, $ TYPE=REPORT, OBJECT=STATUS-AREA, JUSTIFY=LEFT, PAGE-LOCATION=BOTTOM, $ TYPE=REPORT, COLUMN=N6, SQUEEZE=0.555556, $ TYPE=REPORT, COLUMN=N8, SQUEEZE=0.888889, $ TYPE=REPORT, COLUMN=N7, SQUEEZE=1.027778, $ TYPE=REPORT, COLUMN=N5, SQUEEZE=0.666667, $ TYPE=REPORT, COLUMN=N2, SQUEEZE=0.777778, $ ENDSTYLE END
and the new working code:
TABLE FILE MONTCON PRINT MONTCON.SEG01.MONTH_KEY NOPRINT MONTCON.SEG01.MONTH MONTCON.SEG01.PURWAT/P12.2C AS 'Purch.' COMPUTE Accted/D12.2C = ( MONTCON.SEG01.Billed + MONTCON.SEG01.Adjusted + MONTCON.SEG01.ChgClcExp + MONTCON.SEG01.Inactive + MONTCON.SEG01.MetExp + MONTCON.SEG01.SvcOrdExp ) / 1000; AS 'Acct.' COMPUTE UnAccounted_MOG/D12.2C = UnAccted / 1000; AS 'Unacct''d Cons.' MONTCON.SEG01.UnActPct/D12.2% AS 'Unacct''d, %' MONTCON.SEG01.INCIDENT_COUNT AS 'IncCnt' MONTCON.SEG01.ACTHYDCNT AS 'ActHyd ' ON TABLE SUBHEAD "Loss by Month" " <+0>(Units in Million)" WHERE MONTCON.SEG01.YEAR EQ &YEAR; ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT AHTML ON TABLE SET WEBVIEWER ON ON TABLE SET WEBVIEWTARG OFF ON TABLE SET CACHELINES 100 ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = ENgradient_combine, INCLUDE = ENgradient_combine, $ GRAPHTYPE=DATA, COLUMN=N6, GRAPHCOLOR='RED', $ GRAPHTYPE=DATA, COLUMN=N3, GRAPHCOLOR='BLUE', $ GRAPHTYPE=DATA, COLUMN=N4, TARGET='_blank', GRAPHCOLOR='GRAY', $ TYPE=REPORT, FONT='ARIAL', JUSTIFY=CENTER, $ TYPE=DATA, COLUMN=N6, FONT='ARIAL', JUSTIFY=LEFT, FOCEXEC=NONE, $ TYPE=DATA, COLUMN=N3, FONT='ARIAL', JUSTIFY=LEFT, FOCEXEC=NONE, $ TYPE=DATA, COLUMN=N4, TARGET='_blank', FONT='ARIAL', JUSTIFY=LEFT, FOCEXEC=acctwatsize( \ YEAR_MONTH=N2 \ ), $ TYPE=DATA, COLUMN=N1, FONT='ARIAL', $ TYPE=DATA, COLUMN=N8, FONT='ARIAL', FOCEXEC=NONE, $ TYPE=DATA, COLUMN=N7, FONT='ARIAL', FOCEXEC=NONE, $ TYPE=DATA, COLUMN=N5, FONT='ARIAL', JUSTIFY=LEFT, FOCEXEC=NONE, $ TYPE=DATA, COLUMN=N2, FONT='ARIAL', JUSTIFY=LEFT, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N6, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N3, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N4, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N8, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N7, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N5, FOCEXEC=NONE, $ TYPE=TITLE, COLUMN=N2, FOCEXEC=NONE, $ TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, STYLE=BOLD, $ TYPE=TABHEADING, LINE=2, OBJECT=TEXT, ITEM=2, SIZE=9, STYLE=BOLD, $ TYPE=REPORT, OBJECT=STATUS-AREA, JUSTIFY=LEFT, PAGE-LOCATION=BOTTOM, $ TYPE=REPORT, COLUMN=N6, SQUEEZE=0.555556, $ TYPE=REPORT, COLUMN=N8, SQUEEZE=0.888889, $ TYPE=REPORT, COLUMN=N7, SQUEEZE=1.027778, $ TYPE=REPORT, COLUMN=N5, SQUEEZE=0.666667, $ TYPE=REPORT, COLUMN=N2, SQUEEZE=0.777778, $ ENDSTYLE ENDThis message has been edited. Last edited by: Sunilk,