adding drill down to an existing report

[Goha]

I want to know if anyone knows how to add drill down functionality to an existing report? Here is my issue...

my report contains several fields here are some of them

passenger_name toll+parking other_fees Total_Price

these 4 fields are layed out as seen. however the last four are money values and toll+parking and other_fees are formulas containing sub-fields.

I want the result to look like the following:

passenger_name @toll+parking @other_fees Total_Price
-------------- ------------- ----------- -----------
jane doe 10.00 30.00 40.00
john smith 25.00 50.00 75.00
tolls 12.00 misc 5.00
parking 13.00 phone 5.00
service 40.00
jack frost 20.00 20.00 40.00




Thanks in advance........

 

[synapsevampire]

Looks like you could group by name, create summaries for the fields you need summed and place them in the group header.

Place the breakdown detail fields (tolls, etc.) in the detail section.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[Goha]

tolls, parking, misc, phone and service are all seperate fields within the table. they are not calculated. grouping is not the issue here I know how to do that and what is to be done. however the issue is that this is the first time i do drilldown and the help files regarding drilldown are terrible. I want to know the steps on how it is done. Also is there any documented placed on the web where i can get info on how to do drilldown.

Thanks in advance...

Goha

 

[lyanch]

To do a drill down report, you need to get the report to look like it would if all the "drill downs" are open on the main report. Then right click on the sections that you want to hide until drilled down and check "Hide - drill down okay". The drill down will then open in a new tab. You can have several layers of drill down, ie, a group drill down, and a detail drill down.

Lisa

 

[Goha]

Lisa,

I did all that. now how do i drill down on an object?

group1 - passenger --> Total
group2 - date - drill down ok -->details of the total

now i run the report i do not see group2 only group one. and i cannot drill down on it by double clicking it.

am i doing it wrong if so what is the correct way??

 

[basil3legs]

It sounds like you have chosen Suppress (No Drill-Down) rather than Hide (Drill-Down OK). In the details section there are 2 seperate settings, Suppress and Hide, If you have the section Suppressed, the Hide settings are irrelevent.