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     issue with PRINT field NOPRINT

Read-Only Read-Only Topic
Go
Search
Notify
Tools
issue with PRINT field NOPRINT
 Login/Join
 
roseann
Member
posted
I wanna display report as follow:
---------------------------------
INFORMATION
NAME COUNTRY

this is the code i have:
------------------------
TABLE FILE MYHOLD
PRINT NAME
COUNTRY
BY ID NOPRINT
ON ID SUBHEAD
"INFORMATION" "NAME <10>COUNTRY"
WHEN ID EQ xxx;

If i put the NOPRINT in the PRINT fields (NAME & COUNTRY), the data does not show in the report. But if i leave the code as is now, i would see:
NAME COUNTRY
INFORMATION
NAME COUNTRY

I would appreciate any help. Thank you.
~R
 
Posts: 6 | Registered: November 16, 2005Report This Post
TryFocus
Gold member
posted Hide Post
Try this one

TABLE FILE CAR
PRINT COUNTRY
CAR
BY MODEL NOPRINT
ON TABLE SUBHEAD
"INFORMATION" "COUNTRY <+10>CAR"
ON MODEL SUBHEAD
"INFORMATION" "COUNTRY <+10> CAR"
ON TABLE SET PAGE-NUM OFF
ON TABLE SET ONLINE-FMT HTML
END

If this doesnt solved your problem.
Can you be more specific about the output ( sample structure)


Prod: WF 7.6.10 windows. -- MRE/Dashboard/Self Service/ReportCaster - Windows XP
 
Posts: 82 | Location: Chicago | Registered: September 28, 2005Report This Post
roseann
Member
posted Hide Post
hi TryFocus, thanks for the reply. The "ON TABLE SUBHEAD" in your code creates a Report Heading, which is not what i intended.

I am trying to do Sort Heading in the report with "INFORMATION" and "NAME and COUNTRY" when qualifier equal to xxx.


When i use PRINT NAME COUNTRY, the fieldname NAME and COUNTRY appears before the Sort Heading, which i dont want.

The report result i would like to get is:


INFORMATION
NAME COUNTRY
name1 country1
name2 country2

I appreciate any help. Thanks,
~R
 
Posts: 6 | Registered: November 16, 2005Report This Post
Leah
Virtuoso
posted Hide Post
Are you selecting on the id as well?
-SET &MODEL = '504 4 DOOR';
SET STYLEMODE = FIXED
TABLE FILE CAR
PRINT COUNTRY AS ''
CAR AS ''
BY MODEL NOPRINT
WHERE MODEL EQ '&MODEL'
ON MODEL SUBHEAD
"INFORMATION"
" "
"COUNTRY CAR"
" "
WHEN MODEL EQ '&MODEL'
ON TABLE SET PAGE-NUM OFF
ON TABLE SET ONLINE-FMT HTML
END
Gives:


INFORMATION

COUNTRY CAR

FRANCE PEUGEOT


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
roseann
Member
posted Hide Post
Thanks a lot of the help, Leah. It works.
 
Posts: 6 | Registered: November 16, 2005Report This Post
Leah
Virtuoso
posted Hide Post
You're most welcome, Rosanne


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report 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     issue with PRINT field NOPRINT

Copyright © 1996-2020 Information Builders