| Oracle Reports [message #308251] |
Sat, 22 March 2008 20:17  |
babuanna
Messages: 28
Registered: October 2007
|
Junior Member |
|
|
Hi,
How do I split up the dates as in the report using oracle reports 6i attached below?
If a contract date is spanning more than a month, it should be split up in the respective months for the same contract amounts.
Thanks a lot in advance.
-
Attachment: jon.xls
(Size: 13.50KB, Downloaded 1190 times)
|
|
|
|
|
|
| Re: Oracle Reports [message #308377 is a reply to message #308251] |
Mon, 24 March 2008 03:02  |
babuanna
Messages: 28
Registered: October 2007
|
Junior Member |
|
|
Hi All,
I have rephrased the question.
The following is the output of a required report:
"CutomerNo" "Empno
No" Start Date End Date salary ($)
xpeo Margin(1) 1/01/2007 15/01/2007 5000
125091 6/01/2007 22/01/2007 6000
125092 12/01/2007 28/01/2007 7000
EndMar(2) 27/01/2007 31/01/2007 8000
Sum(Jan) 26000
Margin(2) 1/02/2007 15/02/2007 8000
125091 6/02/2007 22/02/2007 6000
125092 12/02/2007 28/02/2007 7000
EndMar(3) 27/02/2007 28/02/2007 8000
sum(Feb) 26000
Sometimes, the employee dates may span for more than a month, like in this case, the contract No EndMar(2) and Margin(2) are both the same empno spanning for more than a month.
In such a circumstance, we need the report to actually split the contract like in the example above in bold above.
The database contains only one record in the table and it shows
as
empno 123
st dt 27/1/2007
end dt 15/2/2007
sal 8000
How do I do a split in oracle reports. Please help.
|
|
|
|
| Re: Oracle Reports [message #308415 is a reply to message #308377] |
Mon, 24 March 2008 04:41 |
 |
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Data you provided is unformatted and, thus, unreadable. As a moderator, I can format it using the [code] tags, but it would remove bold formatting so noone could follow your words (and I'm not in the mood to completely rewrite your message).
As there's only one record in the database (from the bottom of your post), how did you manage to get all those lines in the report? I'm really sorry, but I can not help you.
It would be nice if you could provide CREATE TABLE and INSERT INTO sample data so that we could create our own testing environment. Also, follow other suggestions from the Guide and properly format desired output. Finally, explain HOW to get output from the input.
|
|
|
|
| Re: Oracle Reports [message #308450 is a reply to message #308251] |
Mon, 24 March 2008 06:36 |
babuanna
Messages: 28
Registered: October 2007
|
Junior Member |
|
|
Hi Littlefoot,
I am sorry I could not understand your earlier question. I was unable to attach it as an Excel sheet or word document becuase of your comments.
"Please, read OraFAQ Forum Guide to learn how to properly ask a question. This especially regards attaching files like XLS or DOC which are potentially dangerous; some/most forum members can not (due to firewall settings and company restrictions) and/or do not want to download and open such files."
I tried looking at the OraFAQ Forum Guide but it did not contain any clue on attaching documents.
Hence, I tried pasting the report sample in the actual body instead of attaching an XLS or DOC file. But whatever I did the formatting did not work properly.
Can you please advise as to how I should be attaching the XLS file so that atleast the formatting could be more clearer and better?
Thanks.
|
|
|
|
| Re: Oracle Reports [message #308540 is a reply to message #308450] |
Mon, 24 March 2008 14:21 |
|
Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
Read "How to format your post?" section of the OraFAQ Forum Guide; use [code] or [pre] tags to properly format data you want to display. These tags will preserve formatting. See examples of their use by following the "BBcode is ON" link left from the message window (into which you enter a new message).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
