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     How do I create subreports / nested reports?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How do I create subreports / nested reports?
 Login/Join
 
Member
posted
From my searching, it seems this functionality is not possible. I am hoping someone can prove me wrong.

I understand that subreports are replaced by the drilldown ability, which is fine if the user is at a computer. However, I need a report that can be printed and then 'used' in that form. This may mean walking through a warehouse and checking various items in stock.

For each main row, I want to show a set of details about that item. Then I want to show several lists of information related to that main row. In Access, this is simple subreport functionality.

Thanks in advance.
 
Posts: 9 | Location: Victoria, Australia | Registered: September 27, 2005Report This Post
Expert
posted Hide Post
its version 7.? and they call it 'accordion' reports. look at Cyril Joy's post below, titled 'expandable'
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Virtuoso
posted Hide Post
There are techniques for doing subreports if the output is pdf. I'm pretty sure that you can do similar stuff in html, but it would be a lot harder!

I can post an example later if you need it.
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Member
posted Hide Post
I am currently on version 5.3.3. Can you point me to somewhere I can see some example output from a expandable or accordian report?

dhagen, I would be very keen to see some examples of the techniques you are refering to. I am currently using html output, although it would not be an issue to use pdf.
 
Posts: 9 | Location: Victoria, Australia | Registered: September 27, 2005Report This Post
Virtuoso
posted Hide Post
Here is a quick example. The idea is to run each sub-report as a seperate report, and append the results together in a hold file. It is important to account for all columns in the final report in each extract. You assign a blank to alphas, or zero supress the numerics. In the final report, you can have columns over write one another, because only the sub-report's columns will have values to display.


Here is the source:
 
TABLE FILE GGSALES
SUM
COMPUTE C_SORT/I5 = 1;
UNITS
DOLLARS
BUDUNITS
BUDDOLLARS
COMPUTE C_CAT/A11 = ' ';
COMPUTE C_DOL/I8S = 0;
COMPUTE C_BDOL/I8S = 0;
BY REGION
BY ST
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS MYSUB FORMAT ALPHA
END
FILEDEF MYSUB CLEAR
FILEDEF MYSUB DISK mysub.ftm (APPEND
TABLE FILE GGSALES
SUM
COMPUTE C_ST/A2 = ' ';
COMPUTE C_SORT/I5 = 2;
COMPUTE C_UNITS/I8S =0;
COMPUTE C_DOLLARS/I8S =0;
COMPUTE C_BUDUNITS/I8S =0;
COMPUTE C_BUDDOLLARS/I8S =0;
COMPUTE C_CAT/A11 = MAX.CATEGORY;
COMPUTE C_DOL/I8S = DOLLARS;
COMPUTE C_BDOL/I8S = BUDDOLLARS;
BY REGION
BY CATEGORY NOPRINT
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE HOLD AS MYSUB FORMAT ALPHA
END

TABLE FILE MYSUB
PRINT
C_UNITS IN 20 AS ''
C_DOLLARS AS ''
C_BUDUNITS AS ''
C_BUDDOLLARS AS ''
C_CAT IN 15 AS ''
C_DOL IN 25 AS ''
C_BDOL IN 35 AS ''
BY REGION AS ''
BY C_SORT NOPRINT
BY C_ST AS ''
ON REGION SUBHEAD
" "
"Region<12>State<23>Units<30>Dollars<40>Bud Units<50>Bud Dollars"
ON C_SORT SUBHEAD
" "
"<15>Category:<26>Actuals<36>Budgets"
WHEN C_SORT EQ 2;
ON C_SORT SUBFOOT
" "
WHEN C_SORT EQ 2;
ON TABLE SET ONLINE-FMT PDF
ON TABLE SET STYLE *
TYPE=SUBHEAD, LINE=2, STYLE=BOLD+UNDERLINE, $
ENDSTYLE
END
Below is what the hold file would look like before the final report:
  
REGION C_ST C_SORT C_UNITS C_DOLLARS C_BUDUNITS C_BUDDOLLARS C_CAT C_DOL C_BDOL
------ ---- ------ ------- --------- ---------- ------------ ----- ----- ------
Midwest IL 1 307581 3924401 310071 3866856
Midwest MO 1 297727 3761286 297081 3646838
Midwest TX 1 299737 3714978 299955 3680679
Northeast CT 1 302440 3782049 301367 3832202
Northeast MA 1 301909 3707986 301605 3818397
Northeast NY 1 312326 3902265 311387 3926322
Southeast FL 1 310302 3923215 311983 3870405
Southeast GA 1 330283 4100107 334645 4247587
Southeast TN 1 294647 3687057 295619 3689979
West CA 1 610570 7642261 610362 7586347
West WA 1 321469 4010685 320419 4055166
Midwest 2 Coffee 4178513 4086032
Midwest 2 Food 4338271 4220721
Midwest 2 Gifts 2883881 2887620
Northeast 2 Coffee 4164017 4252462
Northeast 2 Food 4379994 4453907
Northeast 2 Gifts 2848289 2870552
Southeast 2 Coffee 4415408 4431429
Southeast 2 Food 4308731 4409288
Southeast 2 Gifts 2986240 2967254
West 2 Coffee 4473517 4523963
West 2 Food 4202337 4183244
West 2 Gifts 2977092 2934306
Hope this helps.

This message has been edited. Last edited by: <Maryellen>,


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 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     How do I create subreports / nested reports?

Copyright © 1996-2020 Information Builders