Home » Developer & Programmer » Reports & Discoverer » How to print Matrix Report in a Single Page (Oracle Developer, 6i, Windows XP)
How to print Matrix Report in a Single Page [message #404243] Thu, 21 May 2009 02:02 Go to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Respected Moderators and Members,

I have created a Group Matrix Report. The report is not being printed in a single page.

My data and tables are as follows and report and expected format is attached in file.

CREATE TABLE sales (partycode VARCHAR2(10), sale_date DATE, target NUMBER(10,2), sale NUMBER(10,2));

INSERT INTO sales values ('0001', TO_DATE('01-01-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('02-02-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('05-03-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('01-04-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('01-05-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('01-06-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('01-07-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('05-09-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('05-11-2008','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('01-01-2009','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('05-02-2009','DD-MM-YYYY'), 0, 0);
INSERT INTO sales values ('0001', TO_DATE('09-05-2009','DD-MM-YYYY'), 0, 0);
commit;

SELECT
       partycode                      PARTYCODE,
       to_char(sale_date,'YYYY')      Year,
       to_char(sale_date,'MM-MONTH')  Momth,
       target                         TARGET,
       sale                           sale
  FROM  sales 
  ORDER BY 1,2;


Quote:





I would be very grateful if somebody please provide me help in detail, about how to print the report in single page, please.

Best Regards-

G. Hossain
Re: How to print Matrix Report in a Single Page [message #404249 is a reply to message #404243] Thu, 21 May 2009 02:11 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

I want the report to be printed as attached file.

Regards.
Re: How to print Matrix Report in a Single Page [message #404338 is a reply to message #404249] Thu, 21 May 2009 07:26 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

hi,
Open property pallete of the frame R_G_PARTYCODE in your report. You have set the Print Direction "Down". make it Across/Down. This is the only thing required for your report to be printed on a single page instead of multiple pages.

regards,
Saadat Ahmad

[Updated on: Thu, 21 May 2009 07:26]

Report message to a moderator

Re: How to print Matrix Report in a Single Page [message #404382 is a reply to message #404338] Thu, 21 May 2009 10:38 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Thank you very much for your kind reply. I would be very grateful if you kindly change my attached REPORT/RDF file accordingly and send me back. Your help is cordially appreciated.
Best regards.
-G. HOSSAIN

[Updated on: Thu, 21 May 2009 10:41]

Report message to a moderator

Re: How to print Matrix Report in a Single Page [message #404390 is a reply to message #404382] Thu, 21 May 2009 11:10 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

Well done my dear.
Why you don't bother to try what I suggested to you?
Anyway I'm attaching the report and the screenshot.
Re: How to print Matrix Report in a Single Page [message #404393 is a reply to message #404390] Thu, 21 May 2009 11:13 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

and here's teh screenshot.
  • Attachment: Change.JPG
    (Size: 181.11KB, Downloaded 129 times)
Re: How to print Matrix Report in a Single Page [message #404460 is a reply to message #404393] Thu, 21 May 2009 20:23 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Dear S. Ahmed,

I left office yesterday noon. So, I am away from the computer that has oracle installed. Today is my office closed. I have been replying you from my mobile phone since I left office yesterday noon.

Before posting/creating this topic yesterday, I had tried to change the print direction property of several REPEATING GROUPS, below R_G_PARTYCODE, to ACROSS and ACROSS/DOWN, except R_G_PARTYCODE. At that time it was not accepting the change in PRINT DIRECTION property, so I requested you to do this.
I shall inform you about the result tomorrow when my office opens.

Heartyest Regards-

Mohd. Golam Hossain

[Updated on: Thu, 21 May 2009 20:26]

Report message to a moderator

Re: How to print Matrix Report in a Single Page [message #404704 is a reply to message #404460] Fri, 22 May 2009 22:49 Go to previous message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Dear Saadat Ahmad Bhai,

Thank you very much for your kind solution. Your solution worked fine! Before posting this topic I was wrong to try to set the print direction property of MATRIX R_G_YR to across/down.

Best regards with heartyest gratitude.

Mohd. Golam Hossain

[Updated on: Fri, 22 May 2009 22:49]

Report message to a moderator

Previous Topic: Oracle Report File in Cache Directory
Next Topic: How to centeralized Repeating frame
Goto Forum:
  


Current Time: Tue Dec 06 04:52:35 CST 2016

Total time taken to generate the page: 0.12900 seconds