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     dense data or nodata

Read-Only Read-Only Topic
Go
Search
Notify
Tools
dense data or nodata
 Login/Join
 
Member
posted
Hey Everyone,

I've been trying for 2 days to get a report to work, and I hope someone here can help me out.

I need to dense data in a report. I'm using the nodata, and it works fine for the first set of data, but when I add another by field, it only denses the first by field.

What I need to end up with is something like this.

country bodytype car
england convertible jaguar
sedan jaguar
hardtop triumph
coupe NONE
roadster NONE
france convertible NONE
sedan peugeot
hardtop NONE
coupe NONE
roadster NONE

Any ideas would be greatly appreciated.
 
Posts: 15 | Location: Atlanta | Registered: July 19, 2005Report This Post
Expert
posted Hide Post
Will this do what you require:

SET NODATA=NONE
TABLE FILE CAR
SUM CAR
SALES NOPRINT
BY COUNTRY
BY BODYTYPE
ROWS 'CONVERTIBLE' OVER 'HARDTOP' OVER 'SEDAN' OVER 'ROADSTER'
BY CAR NOPRINT
END
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Member
posted Hide Post
wow, this looks great. I'll drop it in my code and see what happens. thanks so much!!!!!
 
Posts: 15 | Location: Atlanta | Registered: July 19, 2005Report This Post
Member
posted Hide Post
That code worked great. One last question. Can anyone think of a way to make the rows dynamic? My data changes too much for me to hard the rows.

I wish I had come here two days ago.
 
Posts: 15 | Location: Atlanta | Registered: July 19, 2005Report This Post
Expert
posted Hide Post
Hi Raini,

The following code should do it for you Smiler

SET NODATA=NONE
SET HOLDLIST = PRINTONLY
TABLE FILE CAR
BY BODYTYPE
ON TABLE SAVE AS BODYTYPES FORMAT ALPHA
END
-RUN
-SET &Rows = 'ROWS ';
-READ BODYTYPES, NOCLOSE &Bodytype
-REPEAT Read_It WHILE (&IORETURN EQ 0);
-SET &Rows = &Rows | '''&Bodytype.EVAL''';
-READ BODYTYPES, NOCLOSE &Bodytype
-SET &Rows = IF &IORETURN EQ 0 THEN &Rows | ' OVER ' ELSE &Rows;
-Read_It
-RUN
TABLE FILE CAR
SUM CAR
BY COUNTRY
BY BODYTYPE
&Rows
BY CAR NOPRINT
END
-EXIT

This message has been edited. Last edited by: Tony A,
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Member
posted Hide Post
'NOCLOSE' is a new one for me. I'm on 5.2.3 in a windows nt environmen. I don't think NOCLOSE works for me.

Other than that, I think the code is brilliant.
 
Posts: 15 | Location: Atlanta | Registered: July 19, 2005Report This Post
Expert
posted Hide Post
Hi Raini,

NOCLOSE is an option on a -READ statement that keeps the file open and the row pointers intact and has been around for a few years now.

It should function with 5.2.3 OK.
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Member
posted Hide Post
You're right. There is something going on with my data. I have to do a match to get the list, and somethere weird is happening after that.

Thanks so much!!!
 
Posts: 15 | Location: Atlanta | Registered: July 19, 2005Report 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     dense data or nodata

Copyright © 1996-2020 Information Builders