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

Can you please post your code?

Thank You

Ditto...

Also screen shots or output of the messed up report if possible.

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,

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.

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
END

This message has been edited. Last edited by: Sunilk,