Home » Developer & Programmer » Application Express & MOD_PLSQL » IR Report Group by issue (Oracle Apex 4.1)
IR Report Group by issue [message #556089] Thu, 31 May 2012 04:43 Go to next message
dilipdd
Messages: 12
Registered: June 2006
Location: Mumbai
Junior Member
Hi,
I have application built in Oracle Apex 4.1.
It has several Interactive Reports.
IR having functions like Sort, Filter, Grouping etc.
All these are working fine except Group By function.
I can select Group by function, even select column and function like sum/count in group by.
But when I pressed 'Ok', I can't see the report with Group by function implemented.
Screen remains as it is as Function-Group by dialogue box remains opened.

Can anyone tell me about this issue.

Thanks.
Re: IR Report Group by issue [message #556092 is a reply to message #556089] Thu, 31 May 2012 04:53 Go to previous messageGo to next message
Littlefoot
Messages: 19346
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I have just created a sample interactive report (select * from emp). I set the GROUP BY function by JOB column. I also chose a SUM function to be applied to SAL values. This is the result:

./fa/10200/0/

It seems to be OK (i.e. I got what I expected).

If possible, create a test case and explain exactly what you did so that we could try it. Or, even better, do that on apex.oracle.com and provide login credentials so that we could have a look and, hopefully, assist.
IR Report Group by issue [message #556094 is a reply to message #556089] Thu, 31 May 2012 05:13 Go to previous messageGo to next message
dilipdd
Messages: 12
Registered: June 2006
Location: Mumbai
Junior Member
In the image you will see when I pressed button 'uitvoeren' screen remains as it is, not showing Group by result in the report.
Everything is in Dutch on screen.

Thanks.

./fa/10201/0/


[EDITED by LF: inserted image into message body]
  • Attachment: ir_issue.JPG
    (Size: 136.31KB, Downloaded 281 times)

[Updated on: Thu, 31 May 2012 05:21] by Moderator

Report message to a moderator

Re: IR Report Group by issue [message #556096 is a reply to message #556094] Thu, 31 May 2012 05:27 Go to previous messageGo to next message
Littlefoot
Messages: 19346
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Uitvoeren" would be "Apply", right?

So, when you press it, nothing happens? Huh, no idea ... Version I tested it on is 4.1.1.00.23; which one is yours?
Re: IR Report Group by issue [message #556098 is a reply to message #556096] Thu, 31 May 2012 05:29 Go to previous messageGo to next message
dilipdd
Messages: 12
Registered: June 2006
Location: Mumbai
Junior Member
Same version.

And it's happening in all IR reports of the applications.
I guess it's related to some Apex settings , may be Scheme,Template or CSS. Any clue?
Re: IR Report Group by issue [message #556106 is a reply to message #556098] Thu, 31 May 2012 05:42 Go to previous message
Littlefoot
Messages: 19346
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps you could check on OTN Apex forum. Posting frequency there is MUCH higher than here; also, use its search facility - maybe someone else already had the same problem and managed to solve it (or - maybe you hit a bug).
Previous Topic: How to store the Emp_name instead of username in application Item
Next Topic: How to refer the tabular form field
Goto Forum:
  


Current Time: Fri Aug 01 03:29:45 CDT 2014

Total time taken to generate the page: 0.22075 seconds