Home » Developer & Programmer » Reports & Discoverer » Report Style
Report Style [message #282513] Thu, 22 November 2007 03:59 Go to next message
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




Re: Report Style [message #282519 is a reply to message #282513] Thu, 22 November 2007 04:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Report Style [message #282534 is a reply to message #282519] Thu, 22 November 2007 04:49 Go to previous messageGo to next message
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 159 times)
Re: Report Style [message #282536 is a reply to message #282534] Thu, 22 November 2007 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry can't download .doc file, post it in .txt

Regards
Michel
Re: Report Style [message #282542 is a reply to message #282536] Thu, 22 November 2007 05:10 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Is this Oracle Reports we're talking about?

MHE
Re: Report Style [message #282551 is a reply to message #282542] Thu, 22 November 2007 05:50 Go to previous messageGo to next message
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 145 times)
Re: Report Style [message #282560 is a reply to message #282551] Thu, 22 November 2007 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: Report Style [message #282665 is a reply to message #282560] Thu, 22 November 2007 23:08 Go to previous messageGo to next message
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.

Re: Report Style [message #282673 is a reply to message #282665] Thu, 22 November 2007 23:41 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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).
Re: Report Style [message #283681 is a reply to message #282513] Tue, 27 November 2007 23:23 Go to previous message
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:
  


Current Time: Sun Dec 04 20:28:15 CST 2016

Total time taken to generate the page: 0.10521 seconds