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 Go to next message](/forum/theme/orafaq/images/down.png) |
m_golam_hossain
Messages: 89 Registered: August 2008 Location: Uttara, Dhaka, Bangladesh
|
Member |
![m_golam_hossain%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
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;
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 #404460 is a reply to message #404393] |
Thu, 21 May 2009 20:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
m_golam_hossain
Messages: 89 Registered: August 2008 Location: Uttara, Dhaka, Bangladesh
|
Member |
![m_golam_hossain%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
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
|
|
|
|
Goto Forum:
Current Time: Mon Aug 19 23:56:09 CDT 2024
|