LiveReport not indenting the same as SQL

James_Chambless

I have a SQL query that lists an indented folder heirarcy. The SQL is 'select ParentID, space((level-1)*4) + Name AS "Parent Folder"'. Each indented row is visably indented by 4 spaces. When I run the same query in a LiveReport the indentation is 'lost'; it appears as if only a single (1) space is being displayed.

I have tried several different techniques in order for the LiveReport to show the indentation without success.

Does anyone have a working example of indenting in a LiveReport? (Not a WebReport)

John W. Simon, Jr.

James, just a guess but since your report is being displayed as HTML, it is the HTML that is removing the whitespace.  I wonder if substituting " " in place of "space" would work?!?