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     [CLOSED] Multi level Drill-through

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Multi level Drill-through
 Login/Join
 
Mike_Kontosacia
Member
posted
Hello,
I need to build a compound PDF report to be scheduled through ReportCaster, that has 3 or more level deep drill-through.
I have created the sample report below. I have no problem drilling through from the first report to the second, but drill-through from from the second to the third is not working.

I've found an example of multi level drill-through topic on this forum and copied and tried the code which did not work either.
http://forums.informationbuild...841079851#4841079851

I am not sure what I am missing. Any help would be appreciated.

Thanks,
Mike

-*1st report
TABLE FILE CAR
SUM AVE.DEALER_COST AVE.RETAIL_COST
BY COUNTRY
BY CAR
ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=CAR, DRILLTHROUGH=DOWN(COUNTRY CAR),COLOR=RED, $
ENDSTYLE
END
-*2nd report
TABLE FILE CAR
SUM AVE.DEALER_COST AVE.RETAIL_COST
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL
ON COUNTRY PAGE-BREAK
HEADING CENTER
"Country:"Car:ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=HEADING,LINE=1,ITEM=2,DRILLTHROUGH=FIRST(COUNTRY CAR ),COLOR=BLUE, $
TYPE=DATA, COLUMN=MODEL, DRILLTHROUGH=DOWN(COUNTRY CAR MODEL),COLOR=RED, $
ENDSTYLE
END

-*3rd report
TABLE FILE CAR
SUM AVE.DEALER_COST AVE.RETAIL_COST
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL NOPRINT
BY BODYTYPE
ON MODEL PAGE-BREAK
HEADING CENTER
"Country:"Car:"Model:ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET STYLE *
TYPE=HEADING,LINE=3,ITEM=2,DRILLTHROUGH=FIRST(COUNTRY CAR MODEL),COLOR=BLUE, $
ENDSTYLE
END

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


WebFOCUS767, RC,RL,Self-Service,MRE
 
Posts: 10 | Registered: November 12, 2010Report This Post
Mike_Kontosacia
Member
posted Hide Post
Please note that the syntax in my Heading is correct in my code, but it didn't copy over well here, so that is not an issue. Thanks


WebFOCUS767, RC,RL,Self-Service,MRE
 
Posts: 10 | Registered: November 12, 2010Report This Post
Mike_Kontosacia
Member
posted Hide Post
No one commented yet. Confused Frowner


WebFOCUS767, RC,RL,Self-Service,MRE
 
Posts: 10 | Registered: November 12, 2010Report This Post
Tom Flynn
Expert
posted Hide Post
1. Put your code within the red code tags </>

2. Use the Search function for "PDF Drill"

3. Example


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Mike_Kontosacia
Member
posted Hide Post
 
-*1st report
TABLE FILE CAR
 SUM AVE.DEALER_COST AVE.RETAIL_COST
BY COUNTRY
BY CAR
 ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
 TYPE=DATA, COLUMN=CAR, DRILLTHROUGH=DOWN(COUNTRY CAR),COLOR=RED, $
ENDSTYLE
END
-*2nd report
TABLE FILE CAR
   SUM AVE.DEALER_COST AVE.RETAIL_COST
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL
ON COUNTRY PAGE-BREAK
HEADING CENTER
"Country:<COUNTRY"
"Car:<CAR"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=HEADING,LINE=1,ITEM=2,DRILLTHROUGH=FIRST(COUNTRY CAR ),COLOR=BLUE, $
TYPE=DATA, COLUMN=MODEL, DRILLTHROUGH=DOWN(COUNTRY CAR MODEL),COLOR=RED, $
ENDSTYLE
END

-*3rd report
TABLE FILE CAR
   SUM AVE.DEALER_COST AVE.RETAIL_COST
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL NOPRINT
BY BODYTYPE
ON MODEL PAGE-BREAK
HEADING CENTER
"Country:<COUNTRY"
"Car:<CAR"
"Model:<MODEL"
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET STYLE *
 TYPE=HEADING,LINE=3,ITEM=2,DRILLTHROUGH=FIRST(COUNTRY CAR MODEL),COLOR=BLUE, $
ENDSTYLE
END


WebFOCUS767, RC,RL,Self-Service,MRE
 
Posts: 10 | Registered: November 12, 2010Report This Post
Tom Flynn
Expert
posted Hide Post
Sorry! Pointed you in the wrong direction.

If you have Dev Studio, click on Help, Contents, Search: Drillthrough
You can also get reference material via the links in the upper right.

Basically, there is a Drillthrough rule, per the manual:
Only one Drill Through behavior can be specified per report.

So, I commented out your first drillthrough in Report 2 and it worked...

  
TABLE FILE CAR
 SUM AVE.DEALER_COST AVE.RETAIL_COST
BY COUNTRY
BY CAR
 ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET STYLE *
 TYPE=DATA, COLUMN=CAR, DRILLTHROUGH=DOWN(COUNTRY CAR),COLOR=RED, $
ENDSTYLE
END
-*2nd report
TABLE FILE CAR
   SUM AVE.DEALER_COST AVE.RETAIL_COST
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL 
ON COUNTRY PAGE-BREAK
HEADING CENTER
"Country:<COUNTRY"
"Car:<CAR"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
-*   TYPE=HEADING,LINE=1,ITEM=2,DRILLTHROUGH=FIRST(COUNTRY CAR MODEL),COLOR=BLUE, $
TYPE=DATA, COLUMN=MODEL, DRILLTHROUGH=DOWN(COUNTRY CAR MODEL),COLOR=RED, $
ENDSTYLE
END

-*3rd report
TABLE FILE CAR
   SUM AVE.DEALER_COST AVE.RETAIL_COST
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL NOPRINT
BY BODYTYPE
ON MODEL PAGE-BREAK
HEADING CENTER
"Country:<COUNTRY"
"Car:<CAR"
"Model:<MODEL"
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET STYLE *
 TYPE=HEADING,LINE=3,ITEM=2,DRILLTHROUGH=FIRST(COUNTRY CAR),COLOR=BLUE, $
ENDSTYLE
END


Tom

This message has been edited. Last edited by: Tom Flynn,


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Mike_Kontosacia
Member
posted Hide Post
Thank you Tom for looking into this. Now the problem is that I cannot go back to the first report. Is there any technique to accomplish this?
Please note that the users of this report would not have any link back to our WebFOCUS servers.


WebFOCUS767, RC,RL,Self-Service,MRE
 
Posts: 10 | Registered: November 12, 2010Report This Post
Tom Flynn
Expert
posted Hide Post
Copy the revised code above, it now works as expected. I had added BY MODEL NOPRINT in the 1st report, incorrectly.

First time I have ever used Drillthrough...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Mike_Kontosacia
Member
posted Hide Post
But that shows measures at the model level in the first report, similar to the second report.


WebFOCUS767, RC,RL,Self-Service,MRE
 
Posts: 10 | Registered: November 12, 2010Report This Post
Tom Flynn
Expert
posted Hide Post
It's your code, not mine!

Take out the BY MODEL NOPRINT and use BY MODEL in Report 3!

Here's the manual.

Best wishes...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report 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     [CLOSED] Multi level Drill-through

Copyright © 1996-2020 Information Builders