Drill Down

[shanthiash]

Hi everyone. I'm new on Pentaho and I'd like to know if it is possible to build a drill-down report directly wih a query, not building a cube.

for example: I've got my query

select country, region, city, sum(amount)
from table1
group by country, region, city

and I'd like to get a report that allows me to drill between the different fields.
Could anyone tell me if it is possible and how can I do that?

THANKS & REGARDS,

[shanthiash]

hi any one is there??.... please reply......:confused:

[DMurray3]

Hi... I think your post would be best on the Reporting Forum.... Have you tried looking for a similar request there?

HTH... DMurray3

[shanthiash]

hi,

sorry,i didn't check that,... now only i saw that....

u gave idea to use pentaho cube??... without using of cube we can't

get the output in an Excel format???......