We are trying to use Webfocus to create a report that we will then use Report Caster to distribute to various people.

The report has been set up as a pdf and I have been trying to format it to both look good and fit on one page horizontally.

Horizontally, after a battle with the WRAP and SQUEEZ command, I have been successfull.

Vertically I am having an issue.

The default sets the page at 20 lines. To be honest, the report seems to go more than 20 lines but there is still a bunch of white space at the botton..ie I can fit more lines. I altered the code to: tried to: LINES-PER-PAGE=35 but nothing happened...I got no more or less lines per page. Whats the secret!


TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
LINES-PER-PAGE=35,
$
TYPE=DATA,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N3,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N7,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N2,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N9,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=ROWTOTAL(*),
FONT='ARIAL',
SIZE=8,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
BACKCOLOR=RGB(205 205 205),
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
BACKCOLOR='WHITE',
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR='WHITE',
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR='WHITE',
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
$
TYPE=REPORT,
COLUMN=N3,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
$
TYPE=REPORT,
COLUMN=N7,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
$
TYPE=REPORT,
COLUMN=N9,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
WRAP=2.000000,
$
TYPE=REPORT,
COLUMN=ROWTOTAL(*),
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
$
ENDSTYLE

This message has been edited. Last edited by: <Kathryn Henning>,

Have you played with the page margins ?

May give a bit more space.

Something I've dont before to give a hint as to what is reserving the space, and can therefore be targeted, is setting the background colour for different components, so you can seewhat they use.

Can you show me syntax for setting margins?

to be more specific...is there certain code for pdfs or just do something like this:

LEFTMARGIN=0.055556,
RIGHTMARGIN=0.055556,
TOPMARGIN=0.041667,
BOTTOMMARGIN=0.041667

Also, did I miss where I can set (or default) margins using the GUI?

...tried
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ORIENTATION=LANDSCAPE,TOPMARGIN=0.05,

$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
LINES-PER-PAGE=45,
$
.
.
.

and got:
Unknown error occurred. Agent on reporting server EDASERVE may have crashed or request was halted by the operator. Please investigate reporting server log.

Where exactly would I place the Margin settings?

I don't know why you're getting an agent crash, but this is from the doc:

Creating Reports With WebFOCUS Language > Laying Out the Report Page > Setting Page Margins

Syntax: How to Set Margin Size
This syntax applies to a PDF, PS, or HTML report with internal Cascading Style Sheet.

[TYPE=REPORT,] [TOPMARGIN={value|.25},] [BOTTOMMARGIN={value|.25},]
[LEFTMARGIN={value|.25},] [RIGHTMARGIN={value|.25},] $
where:

TYPE=REPORT
Applies the margin size to the entire report. Not required, as it is the default.

TOPMARGIN
Sets the top boundary of the report content.

BOTTOMMARGIN
Sets the bottom boundary of the report content.

LEFTMARGIN
Sets the left boundary of the report content.

RIGHTMARGIN
Sets the right boundary of the report content.

value
Is the size of the specified margin. The report content displays inside the margin. If printing a report, specify a value compatible with the printer's print area. For example, if the print area has 0.25 inch margins all around, set the margins to 0.25 inches, or larger.

The default value for all margins is 0.25 inches.

Thanks! I am trying that now. I am now struggling with the fact that sometime it runs and sometimes it throws this error:

Unknown error occurred. Agent on reporting server EDASERVE may have crashed or request was halted by the operator. Please investigate reporting server log.

I contacted out IS team to see if something is going on or if somehow my code is interpeted in differnt ways for some reason causing a random failure.....Ehhhh!

anyone want to a crack at this. This code yeild a report EVRY time no matter how I run it:
SET ALL=PASS
DEFINE FILE ANALYZER_INVOICE_VW
LocationGrp/A10=IF ANALYZER_INVOICE_VW.INVOICE.Location_Number EQ '11' THEN 'OFFICE' ELSE 'OTHER';
END
TABLE FILE ANALYZER_INVOICE_VW
SUM
ANALYZER_INVOICE_VW.CPTCODES.UNITS AS 'Units'
ANALYZER_INVOICE_VW.CPTCODES.wRVUs
BY ANALYZER_INVOICE_VW.PROVIDERS.BillingProviderSUI NOPRINT
BY HIGHEST LocationGrp NOPRINT
BY LOWEST ANALYZER_INVOICE_VW.PATIENT.PAT_NM AS 'Patient Name'
BY ANALYZER_INVOICE_VW.PATIENT.PAT_MRN AS 'MRN'
BY LOWEST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum AS 'CC'
BY LOWEST ANALYZER_INVOICE_VW.DATES_INVOICE_LEVEL.Date_Of_Service AS 'DOS'
BY LOWEST ANALYZER_INVOICE_VW.PROVIDERS.RendProviderName AS ' Rend Prov Nm'
BY LOWEST ANALYZER_INVOICE_VW.CPTCODES.Procedure_Code AS 'Cpt'
BY LOWEST ANALYZER_INVOICE_VW.CPTCODES.Procedure_Name AS 'CptName'
BY LOWEST ANALYZER_INVOICE_VW.CPTCODES.Current_RVU99 AS 'Current,wRVu'

ON LocationGrp SUBTOTAL AS '*TOTAL'
HEADING
"PATIENT WRVU DETAIL REPORT"
"" FOOTING
"LVPG CONFIDENTIAL INFORMATION"
WHERE ANALYZER_INVOICE_VW.CPTCODES.Procedure_Code NE '""';
WHERE ANALYZER_INVOICE_VW.INVOICE.Group_Number NE '20' OR '100';
WHERE ANALYZER_INVOICE_VW.PROVIDERS.BillingProviderReportingName EQ &BillProvNm.(OR(FIND TBLMSTR_PROVNBRNPIRPTNAMEXREF.TBLMSTR_PROVNBRNPIRPTNAMEXREF.RPTPROVNAME,TBLMSTR_PROVNBRNPIRPTNAMEXREF.TBLMSTR_PROVNBRNPIRPTNAMEXREF.RPTPROVNAME IN tblmstr_provnbrnpirptnamexref)).Select Billing Proivder/s.;
WHERE ANALYZER_INVOICE_VW.DATES_INVOICE_LEVEL.Inv_Cre_Period_Rolling_Months EQ -1;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET BYDISPLAY ON
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

END



This codes sometimes runs and some time yeilds the EDA server message posted earlier. Does anyone see anything in the REPORT area that might be causing this? That is the only difference between the two fexes...

SET ALL=PASS
DEFINE FILE ANALYZER_INVOICE_VW
LocationGrp/A10=IF ANALYZER_INVOICE_VW.INVOICE.Location_Number EQ '11' THEN 'OFFICE' ELSE 'OTHER';
END
TABLE FILE ANALYZER_INVOICE_VW
SUM
ANALYZER_INVOICE_VW.CPTCODES.UNITS AS 'Units'
ANALYZER_INVOICE_VW.CPTCODES.wRVUs
BY ANALYZER_INVOICE_VW.PROVIDERS.BillingProviderSUI NOPRINT
BY HIGHEST LocationGrp NOPRINT
BY LOWEST ANALYZER_INVOICE_VW.PATIENT.PAT_NM AS 'Patient Name'
BY ANALYZER_INVOICE_VW.PATIENT.PAT_MRN AS 'MRN'
BY LOWEST ANALYZER_INVOICE_VW.INVOICE.Billing_Area_ReportingNum AS 'CC'
BY LOWEST ANALYZER_INVOICE_VW.DATES_INVOICE_LEVEL.Date_Of_Service AS 'DOS'
BY LOWEST ANALYZER_INVOICE_VW.PROVIDERS.RendProviderName AS ' Rend Prov Nm'
BY LOWEST ANALYZER_INVOICE_VW.CPTCODES.Procedure_Code AS 'Cpt'
BY LOWEST ANALYZER_INVOICE_VW.CPTCODES.Procedure_Name AS 'CptName'
BY LOWEST ANALYZER_INVOICE_VW.CPTCODES.Current_RVU99 AS 'Current,wRVu'

ON LocationGrp SUBTOTAL AS '*TOTAL'
HEADING
"PATIENT WRVU DETAIL REPORT"
"" FOOTING
"LVPG CONFIDENTIAL INFORMATION"
WHERE ANALYZER_INVOICE_VW.CPTCODES.Procedure_Code NE '""';
WHERE ANALYZER_INVOICE_VW.INVOICE.Group_Number NE '20' OR '100';
WHERE ANALYZER_INVOICE_VW.PROVIDERS.BillingProviderReportingName EQ &BillProvNm.(OR(FIND TBLMSTR_PROVNBRNPIRPTNAMEXREF.TBLMSTR_PROVNBRNPIRPTNAMEXREF.RPTPROVNAME,TBLMSTR_PROVNBRNPIRPTNAMEXREF.TBLMSTR_PROVNBRNPIRPTNAMEXREF.RPTPROVNAME IN tblmstr_provnbrnpirptnamexref)).Select Billing Proivder/s.;
WHERE ANALYZER_INVOICE_VW.DATES_INVOICE_LEVEL.Inv_Cre_Period_Rolling_Months EQ -1;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET BYDISPLAY ON
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
LINES-PER-PAGE=20,
$
TYPE=DATA,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N3,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N7,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N2,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=N9,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
COLUMN=ROWTOTAL(*),
FONT='ARIAL',
SIZE=8,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
BACKCOLOR=RGB(205 205 205),
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
BACKCOLOR='WHITE',
$
TYPE=HEADING,
LINE=2,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR='WHITE',
$
TYPE=HEADING,
LINE=3,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR='WHITE',
$
TYPE=FOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
$
TYPE=REPORT,
COLUMN=N3,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
$
TYPE=REPORT,
COLUMN=N7,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
$
TYPE=REPORT,
COLUMN=N9,
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
WRAP=2.000000,
$
TYPE=REPORT,
COLUMN=ROWTOTAL(*),
FONT='ARIAL',
SIZE=8,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
$
ENDSTYLE
END

WebFOCUS 8206.08
Windows, All Outputs

FYI...The line of code causing the issue is:

WRAP=2.000000,

With this line in place, running the report sometimes yeilds an error sometimes does not. Removing the code messes up my formatting BUT it ALWAYS runs....

I want to wrap this column...WHAT IS THE APPROPRIATE SYNTAX TO USE FOR MY PDF KEEPING THE COLUMN AT 2" WIDE?



thanks!

CLOSED - STARTING NEW THREAD