I have a report that has a heading that spans the legnth of the page. The actual report only has two small columns. When I run the report, the columns are spaced with the first on the left side of the page, and the second on the right side of the page.
I want the second column to be right next to the first. Is there anything I can do?
Thanks,This message has been edited. Last edited by: Kerry,
Kevin ______________________ Production: WebFocus 7.6.11 on Win2K3 Server Test: WebFocus 7.6.11 on Win2K3 Server Formats: Excel2K, PDF, HTML
Kevin ______________________ Production: WebFocus 7.6.11 on Win2K3 Server Test: WebFocus 7.6.11 on Win2K3 Server Formats: Excel2K, PDF, HTML
October 15, 2009, 12:59 PM
Darin Lee
We probably need to see your code to figure out what the issue might be. Please include it inside the code tags.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
October 15, 2009, 01:37 PM
Tom Flynn
Probably missed a double quote, " , to close the HEADING line...
Here is my report code. I found in another post a setting for the styling code of HEADALIGN=INTERNAL, but that didn't seem to do anything.
TABLE FILE REPORTREADY1 SUM FOLLOW_ON/D15.2C!D AS '' BY FISCAL AS '' HEADING "* Overlap counting can occur - i.e., outbound call center may collect on a field compliance initiated collection." "** Includes 5 yrs of follow-on revenue in the following amounts. These amounts represent future compliance" " that would not have been realized but for these efforts." "*** Reported on an annual basis because the data is not available until conclusion of the aging cycle." WHERE BLANK EQ 'FOLLOW-ON'; WHERE (FISCAL EQ &FISCAL.(OR(FIND FY IN FISCAL_YEARS)).Select FYs.); ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE SET STYLE *
Kevin ______________________ Production: WebFocus 7.6.11 on Win2K3 Server Test: WebFocus 7.6.11 on Win2K3 Server Formats: Excel2K, PDF, HTML
October 15, 2009, 02:45 PM
Darin Lee
You forgot the rest of it! Since the problem is in the styling, we need to see the stylesheet too.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
can be eliminated down to the ENDSTYLE. Also, leave out the HEADLIGN=INTERNAL and the heading is left-aligned by default so there is no need to specify that.
Since you have no output type specified, I'm assuming it's just HTML, in which case you probably want a line that says ON TABLE SET HTMLCSS ON.
Best way to troubleshoot the problem is to remove the styling code and see if it looks OK (other than styles) and then add the pieces of code back in one at a time until you figure out what is causing the problem.
try this (and clean up the stylesheet a little) and let us know what you find out.
You also might try to -SET &ECHO=ALL; at the beginning and then view source to see if the code that is actually being run it what you're expecting.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
October 19, 2009, 02:01 AM
Tony A
quote:
I'm assuming it's just HTML
If it is HTML then you will always get a result that takes as much of the window as possible. To test this adjust the window size by grabbing the lower right corner and changing the size. You will see that the heading will change according to the window size.
All that HTMLCSS = ON does is to remove all the individual cell styling and apply it within <style> tags.
If you want to control the columns widths then use another format such as EXL2K or PDF.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
October 19, 2009, 06:03 AM
<JG>
You could always take the obvious approach and pad the report with blank columns
DEFINE FILE CAR
DUMMY/A20='';
END
TABLE FILE CAR
SUM
DCOST/D15.2C!D AS ''
DUMMY AS ''
DUMMY AS ''
DUMMY AS ''
DUMMY AS ''
DUMMY AS ''
BY COUNTRY AS ''
HEADING
"* Overlap counting can occur - i.e., outbound call center may collect on a field compliance initiated collection."
"** Includes 5 yrs of follow-on revenue in the following amounts. These amounts represent future compliance"
" that would not have been realized but for these efforts."
"*** Reported on an annual basis because the data is not available until conclusion of the aging cycle."
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=OFF,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=8,
$
TYPE=HEADING,
SIZE=9,
STYLE=BOLD,
JUSTIFY=LEFT,
HEADALIGN=BODY,COLSPAN=7,
$
ENDSTYLE
END