the basis of grouping is activity but if we take the min and max values of date with activity grouping then we will get two values only but wat we want is
the min and max value of every session
say
activity A is done on 3rd,4th ,5 th of march and then activity B started and then activity A is ...
Search found 8 matches
- Wed Apr 18, 2007 9:23 am
- Forum: Oracle Forms & Reports
- Topic: selecting date ranges for a single activity
- Replies: 2
- Views: 1827
- Mon Apr 16, 2007 5:07 am
- Forum: Oracle Forms & Reports
- Topic: selecting date ranges for a single activity
- Replies: 2
- Views: 1827
selecting date ranges for a single activity
a table having two columns one activity and second date
and data is
ACTIVTY DATE
A 01-MAR-07
A 02-MAR-07
A 03-MAR-07
A 15-MAR-07
A 16-MAR-07
A 17-MAR-07
A 18-MAR-07
RESULT REQUIRED
A 1-MAR-07 TO 3-MAR-07
A 15-MAR-07 TO 18-MAR-07
PLZ HELP
and data is
ACTIVTY DATE
A 01-MAR-07
A 02-MAR-07
A 03-MAR-07
A 15-MAR-07
A 16-MAR-07
A 17-MAR-07
A 18-MAR-07
RESULT REQUIRED
A 1-MAR-07 TO 3-MAR-07
A 15-MAR-07 TO 18-MAR-07
PLZ HELP
- Sat Apr 22, 2006 4:08 pm
- Forum: Oracle Forms & Reports
- Topic: can we scroll report with arrow keys
- Replies: 1
- Views: 2370
can we scroll report with arrow keys
can we scroll report with arrow keys
- Fri Apr 21, 2006 6:08 am
- Forum: Oracle Forms & Reports
- Topic: "genrate to file" option in reports runtime error
- Replies: 7
- Views: 5706
- Fri Apr 21, 2006 5:57 am
- Forum: Oracle Forms & Reports
- Topic: "genrate to file" option in reports runtime error
- Replies: 7
- Views: 5706
- Fri Apr 21, 2006 5:11 am
- Forum: Oracle Forms & Reports
- Topic: "genrate to file" option in reports runtime error
- Replies: 7
- Views: 5706
- Wed Apr 19, 2006 2:51 pm
- Forum: Oracle Forms & Reports
- Topic: "genrate to file" option in reports runtime error
- Replies: 7
- Views: 5706
- Tue Apr 18, 2006 7:29 am
- Forum: Oracle Forms & Reports
- Topic: "genrate to file" option in reports runtime error
- Replies: 7
- Views: 5706
"genrate to file" option in reports runtime error
generate to file option in reports runtime is givving an error
"un implementd error"
what should i do
"un implementd error"
what should i do