June 23, 2008, 02:33 PM
LuminitaACROSS and BY styling
Hi,
I don't even know how to explain this, I am trying to "line up" the heading for a report, something like this:
TABLE FILE CAR
SUM DEALER_COST
ACROSS COUNTRY NOPRINT
ACROSS CAR AS ''
BY MODEL
ON TABLE SET PAGE-NUM OFF
END
What I would like to see is the word "MODEL" on the same line as the CARs (JAGUAR, etc). I'm sure there is a way to do that, but I can't figure it out.
Thanks,
Luminita
June 23, 2008, 03:04 PM
mgrackinI will try to keep this as short as possible. You can't do it with just a simple command. the rest of the line to the right of MODEL is actually where the TITLEs should go for the columns of data, in your case DEALER_COST. By default, WebFOCUS suppresses TITLEs when there is only one verb object (SUM is the verb, DEALER_COST is the object). Even though the TITLEs are suppressed, the space is still reserved (unfortnately). There are a lot of internals of processing in play here that make WebFOCUS do this.
There is a trick to force TITLEs to appear but I do not know of a way to get rid of the blank line and put MODEL on the same line as the CAR values.
Change your SUM statement to the following to get TITLEs to appear.
SUM DEALER_COST AS 'Whatever' DEALER_COST NOPRINT
June 23, 2008, 03:10 PM
Francis MarianiAs Mickey says, there's no easy way.
In your report, if it's obvious what the BY field is, you could suppress the column title:
TABLE FILE CAR
SUM SALES
ACROSS SEATS AS ''
BY COUNTRY AS ''
ON TABLE SET PAGE-NUM OFF
END
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
June 24, 2008, 11:08 AM
LuminitaHi,
Thank you so much for your help, no wonder I had a hard time getting this to work :-)
I ended up "tweaking" the Excel template to make it display what I want it to display and it works like a charm.
Thanks,
Luminita