[CLOSED] Multi level Drill-through

February 24, 2011, 03:01 PM

Mike_Kontosacia

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,

February 24, 2011, 03:05 PM

Mike_Kontosacia

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

February 25, 2011, 09:52 AM

Mike_Kontosacia

No one commented yet.

February 25, 2011, 10:02 AM

Tom Flynn

1. Put your code within the red code tags </>

2. Use the Search function for "PDF Drill"

3. Example

February 25, 2011, 10:06 AM

Mike_Kontosacia

 
-*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

February 25, 2011, 10:38 AM

Tom Flynn

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,

February 25, 2011, 11:00 AM

Mike_Kontosacia

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.

February 25, 2011, 11:01 AM

Tom Flynn

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...

February 25, 2011, 11:20 AM

Mike_Kontosacia

But that shows measures at the model level in the first report, similar to the second report.

February 25, 2011, 11:23 AM

Tom Flynn

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...