Home » Developer & Programmer » Reports & Discoverer » Oracle Reports (Reports 6i)
Oracle Reports [message #308251] Sat, 22 March 2008 20:17 Go to next message
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 208 times)
Re: Oracle Reports [message #308266 is a reply to message #308251] Sun, 23 March 2008 01:49 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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.
Re: Oracle Reports [message #308377 is a reply to message #308251] Mon, 24 March 2008 03:02 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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 Go to previous messageGo to next message
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 Go to previous message
Littlefoot
Messages: 20901
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).
Previous Topic: inserting blank lines in d2k
Next Topic: where is debug option in report builder
Goto Forum:
  


Current Time: Sun Dec 11 00:19:00 CST 2016

Total time taken to generate the page: 0.04058 seconds