OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Report Style

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report Style [message #282513]

Thu, 22 November 2007 03:59

MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI

Member

Hi,
iam having a problem in doing a report.

BD_DEALER_VOL_BROK_ARP07_TO_OCT07 is a table with the following structure.

BD_DEALER_VOL_BROK_ARP07_TO_OCT07

BR_ID VARCHAR2(20)
BR_NAME VARCHAR2(100)
DL_ID VARCHAR2(20)
DL_NAME VARCHAR2(100)

DL_VOL_APR07 NUMBER(30,4)
DL_VOL_MAY07 NUMBER(30,4)
DL_VOL_JUN07 NUMBER(30,4)
DL_VOL_JUL07 NUMBER(30,4)
DL_VOL_AUG07 NUMBER(30,4)
DL_VOL_SEP07 NUMBER(30,4)
DL_VOL_OCT07 NUMBER(30,4)

There will be many Branches, for each Branch there will be some 5 or 10 dealers.

I want a report in the below format

BR_ID: 1
BR_NAME: chennai

DL_ID DL_NAME VOL_APR07 VOL_MAY07 VOL_JUN07 VOL_JUL07 VOL_AUG07 VOL_AUG07 VOL_SEP07
1001 xxxxx 125 145 178 789 896 789 8963
1002 YYYYY 47 475 456 78 455 55 89

I tried this report using Report style group below, it takes lot of time for designing the report to get in the above format, is there any way of getting this report easily.
Please give me an idea to work out this report

Report message to a moderator

Re: Report Style [message #282519 is a reply to message #282513]

Thu, 22 November 2007 04:25

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you:
- read and follow OraFAQ Forum Guide, especially "How to format your post?" section. Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button
- post your Oracle version (4 decimals)
- post a test case (create table and insert statements)

I'll show you how to do this in SQL.

Regards
Michel

Report message to a moderator

Re: Report Style [message #282534 is a reply to message #282519]

Thu, 22 November 2007 04:49

MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI

Member

Sorry for not posting the query properly.
Iam sending it as an attachment

Attachment: BD.doc
(Size: 31.50KB, Downloaded 1131 times)

Report message to a moderator

Re: Report Style [message #282536 is a reply to message #282534]

Thu, 22 November 2007 04:52

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Sorry can't download .doc file, post it in .txt

Regards
Michel

Report message to a moderator

Re: Report Style [message #282542 is a reply to message #282536]

Thu, 22 November 2007 05:10

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Is this Oracle Reports we're talking about?

MHE

Report message to a moderator

Re: Report Style [message #282551 is a reply to message #282542]

Thu, 22 November 2007 05:50

MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI

Member

iam talking about oracle reports builder 6i only,
iam attaching a text file

Attachment: Doc.txt
(Size: 1.01KB, Downloaded 1099 times)

Report message to a moderator

Re: Report Style [message #282560 is a reply to message #282551]

Thu, 22 November 2007 06:30

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I have asked:

Quote:

create table and insert statements

Not the same result table you already posted.

But as this is a Reports question and not a pure SQL one, I move the topic in the correct forum.

Regards
Michel

Report message to a moderator

Re: Report Style [message #282665 is a reply to message #282560]

Thu, 22 November 2007 23:08

MEEENAR
Messages: 72
Registered: May 2005
Location: CHENNAI

Member

is there is any style to be choosen in the report wizard to get the report in the above format.

Report message to a moderator

Re: Report Style [message #282673 is a reply to message #282665]

Thu, 22 November 2007 23:41

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't know.

There are quite a few styles available, so - test each and every of them and see what happens. (I'm not trying to be smart here, I simply don't know the answer. But I also think that it is YOU who should test it when there's no answer to the question).

Report message to a moderator

Re: Report Style [message #283681 is a reply to message #282513]

Tue, 27 November 2007 23:23

informkar
Messages: 4
Registered: November 2007
Location: tvm

Junior Member

hi,

i wanna clarify one thing..
r u using reports builder or not..?
if yes then there is a group by option in the tool.
you can make use of that option..

[Updated on: Tue, 27 November 2007 23:24]

Report message to a moderator

Previous Topic:	want to increase the viewport size of report paramtere form
Next Topic:	How to adjust two pages reports shrink to fit one page in report printing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 00:17:19 CDT 2024