Focal Point
[SOLVED] acrossvalue width

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2811056003

September 26, 2008, 01:20 PM
Bethany
[SOLVED] acrossvalue width
Does anyone know how to set the width of the acrossvalue so that the output of the code below will show Coffee Grinder wrapped so that it appears:

Coffee
Grinder

SET ONLINE-FMT = PDF 
TABLE FILE GGSALES
SUM UNITS
BY REGION
ACROSS CATEGORY AS ' '
ACROSS PRODUCT AS ' '
WHERE CATEGORY EQ 'Gifts';
ON TABLE SET PAGE-NUM OFF
ON TABLE SET STYLE *
ENDSTYLE
END


Thanks,
bethany

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


Server Environment: Win2K3 Server WebFOCUS 7.13 Apache Tomcat standalone application server
September 26, 2008, 02:27 PM
GinnyJakes
Bethany,

Check this out:

There are two articles by Mickey Grackin, a frequent poster, on styleing at this link:

http://www.informationbuilders.com/support/developers/index.html
Look under the Formatting Reports section.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
September 26, 2008, 02:42 PM
mgrackin
Bethany, Ginny;

I do not address this issue in my articles.

The short answer is that you cannot make an ACROSS VALUE wrap the way you would like it to with just FOCUS language syntax.

Let me dig around using the SEARCH on Focal Point for what I think might help you and then I will post a link.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
September 26, 2008, 02:50 PM
mgrackin
Bethany,

Try this post by Warren Hinchliffe. this might give you what you need. It requires you to download some code from the FP site but it might give you what you are looking for.

https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/8381082572


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
September 26, 2008, 03:47 PM
Bethany
Thanks for the suggestions.


Server Environment: Win2K3 Server WebFOCUS 7.13 Apache Tomcat standalone application server