How can i display left spaces in Fields

[Saima Gul]

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

[Saima Gul]

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 

[Saima Gul]

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?

[Kori]

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

[Kori]

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

[Saima Gul]

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