Drill down in free hand sql report

building reports desktopintelligence
1

Hi,

I have developed a thick client report using free hand sql. Now I want to implement drill down functinality in this report. Is it possible to drill down in free hand sql report?

Also in the same report, the data is displayed in different tables in one tab. So if I drill down in one table and go to next level then I want data to be driiled to next level in remaining tables also. How to achieve this.

I am using BO 6.5

Thanks in advance.

vmk03 (BOB member since 2008-10-08)

2

Click on Analysis - Hierarchies, and create a new hierarchy based on the dimension objects in your query. You can then use that hierarchy for drilling.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)