how to remove blankspaces from oracle reports

in Oracle Development and Fusion Middleware; hi... i'm having doubt in oracle reports. i passed one sql query for reports and then implemented text in form ...
+ Post Reply + Post New Topic
Results 1 to 6 of 6
  1. #1
    tamizhatp is offline Junior Member
    Points: 120, Level: 2
    Join Date
    26 Jun 2012
    Posts
    4
    Points
    120

    how to remove blankspaces from oracle reports

    hi... i'm having doubt in oracle reports. i passed one sql query for reports and then implemented text in form letter. my form letter content will be the following way:
    /*form letter---------------*/
    &<name>
    &<addr1>
    &<addr2>
    &<addr3>
    &<city>
    My patient having problem in.....(content in my form letter).
    /*--------*/
    now i'm not havind value in addr2,addr3. in output(pdf file) it showing blankspaces i want solution to remove blankspace and city value have to display next to addr1. i need solution for this. please guide me....


  2. #2
    Bharat's Avatar
    Bharat is offline Forum Guru
    Points: 27,150, Level: 97
    Join Date
    26 Dec 2011
    Location
    Vijayawada, India
    Posts
    1,452
    Points
    27,150

    Re: how to remove blankspaces from oracle reports

    Hi ,

    Use the following option as shown in below screenshot. For the fields what ever you feel they don't get text then we can set this option to remove that extra line.

    So try to use this option for address2 and address3 fields. By this if they both don't have text then they will be removed and the city will be moved up.
    Attached Images
    Last edited by Bharat; 09-17-2012 at 07:04 AM.
    Regards,
    Bharat G.

  3. #3
    tamizhatp is offline Junior Member
    Points: 120, Level: 2
    Join Date
    26 Jun 2012
    Posts
    4
    Points
    120

    Re: how to remove blankspaces from oracle reports

    can u explain brefily. i'm not having clear idea in tat

  4. #4
    Bharat's Avatar
    Bharat is offline Forum Guru
    Points: 27,150, Level: 97
    Join Date
    26 Dec 2011
    Location
    Vijayawada, India
    Posts
    1,452
    Points
    27,150

    Re: how to remove blankspaces from oracle reports

    Are you using BI Publisher reporting or Oracle Reports?
    Regards,
    Bharat G.

  5. #5
    tamizhatp is offline Junior Member
    Points: 120, Level: 2
    Join Date
    26 Jun 2012
    Posts
    4
    Points
    120

    Re: how to remove blankspaces from oracle reports

    oracle reports.. I'm trying dis for last two weeks. i'm not get any idea in this problem. I'm really waiting for ur valuable reply.....

  6. #6
    Bharat's Avatar
    Bharat is offline Forum Guru
    Points: 27,150, Level: 97
    Join Date
    26 Dec 2011
    Location
    Vijayawada, India
    Posts
    1,452
    Points
    27,150

    Re: how to remove blankspaces from oracle reports

    Hi ,

    Please check the below attached .rdf file to find out the solution. The file was compressed. Please unzip that and open with your oracle reports and try to implement this solution in your issue (.rdf file).
    Attached Files
    Regards,
    Bharat G.

Other Solutions
  1. Oracle SQL Remove Special Characters
    By ksjj in forum SQL PL/SQL
    Replies: 6
    Last Post: 05-13-2014, 08:29 AM
  2. remove node from xml using oracle 9i
    By nrupa in forum SQL PL/SQL
    Replies: 3
    Last Post: 04-24-2012, 10:47 PM
  3. Replies: 1
    Last Post: 01-06-2012, 04:06 AM
  4. Remove metadata from database
    By mzainal in forum Oracle Database
    Replies: 2
    Last Post: 08-10-2009, 01:13 PM