Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Adjusting gap between Across Values and Data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Adjusting gap between Across Values and Data
 Login/Join
 
bflemi3
Silver Member
posted
Hi All,

I was wondering if it was possible to adjust the gap that is displayed between Across Values and the Data without having to forgo using Across all together and use Defines? 

From this:
                 Value1    Value2    Value3
Column1
XXX               123       199       399
YYY               990       488       875

To this:
Column1          Value1    Value2    Value3
XXX               123       199       399
YYY               990       488       875



Thanks for any and all help!

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


WebFOCUS 7.7
Windows
All Output (Excel, HTML, PDF)
 
Posts: 31 | Location: Maryland, USA | Registered: April 30, 2010Report This Post
Dan Satchell
Virtuoso
posted Hide Post
Here is a technique that removes the unwanted blank line. Depending on the complexity of your report, it may or not provide a workable solution. 

TABLE FILE CAR
 SUM SEATS/I5S AS ''
 BY BODYTYPE
 ACROSS COUNTRY
 ON TABLE SET ASNAMES ON
 ON TABLE HOLD AS HOLD1
END
-*
TABLE FILE HOLD1
 PRINT *
END


And here is another option. It replaces all column titles with a SUBHEAD for a dummy field. (This could also be done with HEADING and without the dummy field, but that approach might interfere with other report headings.) The drawback to this approach is that it requires that your output always have the same number of columns in the same order.

DEFINE FILE CAR
 DUMMY/A1 = ' ';
END
-*
TABLE FILE CAR
 SUM SEATS AS ''
 BY DUMMY NOPRINT
 BY BODYTYPE AS ''
 ACROSS COUNTRY NOPRINT
 ON DUMMY SUBHEAD
  "BODYTYPE<+0>ENGLAND<+0>FRANCE<+0>ITALY<+0>JAPAN<+0>W GERMANY"
 ON TABLE SET NODATA ' '
 ON TABLE SET STYLE *
  TYPE=SUBHEAD, HEADALIGN=BODY, $
 ENDSTYLE 
END


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
<JG>
posted
And the dynamic version

 TABLE FILE CAR
SUM
COMPUTE RHEAD/A25='<+0>'||COUNTRY;
ACROSS COUNTRY NOPRINT
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE
END
-RUN
DEFINE FILE CAR
 DUMMY/A1 = ' ';
END
-*
TABLE FILE CAR
SUM SEATS AS ''
 BY DUMMY NOPRINT
 BY BODYTYPE AS ''
 ACROSS COUNTRY NOPRINT
 ON DUMMY SUBHEAD
"BODYTYPE
-INCLUDE SAVE
"
 ON TABLE SET NODATA ' '
 ON TABLE SET STYLE *
  TYPE=SUBHEAD, HEADALIGN=BODY, $
 ENDSTYLE 
END
 
Report This Post
Dan Satchell
Virtuoso
posted Hide Post
A very nice solution JG.

I did find I had to make two minor changes to get your code to work in my environment. The negative spot marker removes an empty row that appeared below the column titles when I ran the code.

.
.
-MRNOEDIT -INCLUDE SAVE
<-1 "
.
.

This message has been edited. Last edited by: Dan Satchell,


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
<JG>
posted
quote:
<-1

Thanks Dan that's actually what was wanted.

Yes the -MRNOEDIT is required when running in MRE because the INCLUDE does not physically exist
when the procedure is parsed.

You also get the same problem when running in later versions of Report Caster.

The technique there is to use an & variable

-DEFAULTH &INCLUDE='-INCLUDE SAVE'

.
&INCLUDE.EVAL
.
 
Report This Post
bflemi3
Silver Member
posted Hide Post
quote:
Originally posted by Dan Satchell:
Here is a technique that removes the unwanted blank line. Depending on the complexity of your report, it may or not provide a workable solution. 

TABLE FILE CAR
 SUM SEATS/I5S AS ''
 BY BODYTYPE
 ACROSS COUNTRY
 ON TABLE SET ASNAMES ON
 ON TABLE HOLD AS HOLD1
END
-*
TABLE FILE HOLD1
 PRINT *
END


And here is another option. It replaces all column titles with a SUBHEAD for a dummy field. (This could also be done with HEADING and without the dummy field, but that approach might interfere with other report headings.) The drawback to this approach is that it requires that your output always have the same number of columns in the same order.

DEFINE FILE CAR
 DUMMY/A1 = ' ';
END
-*
TABLE FILE CAR
 SUM SEATS AS ''
 BY DUMMY NOPRINT
 BY BODYTYPE AS ''
 ACROSS COUNTRY NOPRINT
 ON DUMMY SUBHEAD
  "BODYTYPE<+0>ENGLAND<+0>FRANCE<+0>ITALY<+0>JAPAN<+0>W GERMANY"
 ON TABLE SET NODATA ' '
 ON TABLE SET STYLE *
  TYPE=SUBHEAD, HEADALIGN=BODY, $
 ENDSTYLE 
END


Thanks Dan,

I really like your first approach, it's so simple I didn't even think of that. My report is not complex so that should do the trick. Thanks again!

B


WebFOCUS 7.7
Windows
All Output (Excel, HTML, PDF)
 
Posts: 31 | Location: Maryland, USA | Registered: April 30, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Adjusting gap between Across Values and Data

Copyright © 1996-2020 Information Builders