How can i display left spaces in Fields

6 posts, 0 answers
  1. Saima Gul
    Saima Gul avatar
    36 posts
    Member since:
    Mar 2010

    Posted 18 Mar 2010 Link to this post

    Hi
    My data contain some spaces in fields . Actually i want to show rows with indentation. For example i have created a parent account and its child accounts. i want to show childs to be indented right by adding spaces in it so that it is clear for user to increase readability of report. data is ok in query result but when i try to view it in report all rows are left aligned omitting spaces which i have added in row data.
    How can i get this? I want report shows data like this
    Assets
    Current Assets
    Bank Accounts
    UBL
    Cash Accounts
    Other Assets
    Liability
    Short Term
  2. Saima Gul
    Saima Gul avatar
    36 posts
    Member since:
    Mar 2010

    Posted 19 Mar 2010 Link to this post

    I solved my problem by this method
    Previously i was using blank space in my query like 
    Select accountno,space(accountdepth)+accounttitle from acc
    i replace it with this one

    Select accountNo, replicate(' ',accountDepth)+accountTitle from acc

    and my problem is solved in the sense that it looks ok on screen 
  3. DevCraft banner
  4. Saima Gul
    Saima Gul avatar
    36 posts
    Member since:
    Mar 2010

    Posted 29 Apr 2010 Link to this post

    By using above mentioned technique it looks ok on screen
    but if i try to print this report it shows   which i have added in my query. Is there any soln of this problem that it looks same on screen and in print too?
  5. kfrancis
    kfrancis avatar
    69 posts
    Member since:
    Dec 2008

    Posted 07 Dec 2010 Link to this post

    I'm also having this issue. I can replace the spaces with &nbsp and it will make the report look okay, but if I go to export the report - it literally prints out the &nbsp's.

    -- Kori
  6. kfrancis
    kfrancis avatar
    69 posts
    Member since:
    Dec 2008

    Posted 07 Dec 2010 Link to this post

    Oops, just figured it out - wrap any mono-spaced section with <pre></pre> and it will view correctly in the report viewer and not print the html when you export it.

    -- Kori
  7. Saima Gul
    Saima Gul avatar
    36 posts
    Member since:
    Mar 2010

    Posted 28 Jan 2011 Link to this post

    Hi Kori
    I can not understand where to place <pre> tag as if i used it in expression it returns error 'An error has occured while processing Report '':
    Incorrect syntax near '<'.' if i place it in query it still return this error
    Can you plz explain how can i do that i shall be gratefull to you
Back to Top
DevCraft banner