APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interactive report: How to display "count" column on total data set?

887361Sep 9 2011 — edited Sep 11 2011

Hi,
I'm a relative newbie to APEX and would appreciate some help with the following:

I have an interactive report that will usually contain around 8000 rows.
I need to report the total number of distinct values in one of the columns - but I need to get around the limitation of APEX where it only counts the number of rows displayed on the screen.
I thought to create a separate region and use a separate SQL query to show the full total regardless of the number of rows displayed - however, I've now got the problem of not being able to access the interactive report "query", so, for example, if someone running the report adds a filter, I need the total to report with this new filter applied.

Does anyone know if I can:
a) get around the the limitation of only counting the number of rows displayed?
or, if not,
b) how to access the interactive report "query" that is being run?
or
c) any other way of doing this!?

I do hope this makes sense. Thanks in advance for any help....
Helen