Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Report alignment issues..please help

OnenessboyJun 25 2011
Hi Experts,

Can somebody help..

I have following issues in reports:

.I have a report which runs on web in both formats of PDF's and Excel

Issues are

1. In PDF formatl, all columns are being displayed but alignment is the issue.. Since our report should be A4 based. How to increase paper margins..because currently i am not able to drag that black thick coloured line further..? where to adjust and change report layout size..

2. One more thing is that when i run the pdf report, it starts printing from left without leaving any gap(landscapre mode) and its leaving lots of space on the right.. How can i make equal of both left and right margins.

3. When I am running excel report and its rnning fine saving in a xls.. but alignment is the issue...

4.some of the values which are varchar2 data from database... displaying right and some are left aligned.... for example.. if its ABCD then its aligning properly to right. But if it is EFGHEIJK the its doing left alignment... there is no code written for conditional formatting..but what could be the issue.. since the values are direct from table in database..why this is happening

5. and In excel there is a data column which i manipulated as for example to_char(to_date(20100217,'yyyymmmdd'),'dd-mm-yyyy') and this is coming properly in pdf but not excel..in excel its says something like17-02-10,, yYYY is being displayed only as 10... is there any workaround (not manual))

6. And in reports, if we create a field and database column is source for it, i would like to know whether there is any option in property column of the field to set width of the filed..
so that i can reduce of the width in layout to acommidate more column in the report. Because I really not knowing for 8 character database column, how much bigger field i have to create.....

please help..
thanks
asp
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2011
Added on Jun 25 2011
0 comments
495 views