Home » Developer & Programmer » Reports & Discoverer » Selected Rows (Discoverer 10g)
Selected Rows [message #377725] Wed, 24 December 2008 11:53 Go to next message
jfrano
Messages: 11
Registered: January 2007
Location: New York
Junior Member
I've written a report that returns values of a test when the results are >300. However, I'm having difficulty, with the user request to only show, those patients that have had 3 or more results (>300), within a week.

# Name, MRN, Event Date, Test Result

1 JoeD 145 1-jan-2008 00:15 325
2 JoeD 145 2-jan-2008 11:59 344
3 JoeD 145 15-Jan-2008 05:22 355
4 JohnR 332 1-Feb-2008 19:22 344
5 JohnR 332 9-apr-2008 10:59 422
6 JohnR 332 10-Apr-2008 11:22 322
7 JohnR 332 10-Apr-2008 15:29 344
8 JohnR 332 11-Apr-2008 18:22 443
9 JohnR 332 17-Apr-2008 18.21 387

So in this case I would want to see row #5,6,7,8
Any suggestions to achieve this??

Thanks

[Updated on: Wed, 24 December 2008 12:03]

Report message to a moderator

Re: Selected Rows [message #377790 is a reply to message #377725] Thu, 25 December 2008 02:58 Go to previous message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
retrieve count(*)>3 while grouping data week wise.
Previous Topic: Matrix report (oracle builder 9i )
Next Topic: Capturing Page number and total pages for use in format trigger
Goto Forum:
  


Current Time: Sun Dec 11 04:21:30 CST 2016

Total time taken to generate the page: 0.06833 seconds