In OBIEE 184.108.40.206.0.
It has one combined report with two requests, in order to show the hierarchy structure, I add some spaces in front of content, however, when I print or exprt PDF , it will be disappeared. How to solve this problem?
One Method(Maybe it is BUG):
Column Properity-->Data Format-->Treat as html
Then in edit formula, input the following code:'<table><tr><td style="padding-left:20">'||"Time"."Per Name Half"||'</td></tr></table>'
When I print or exprt PDF, it will display HTML code in PDF.
Column Properity-->Data Format-->Plain text(don't break spaces)
Then in edit formula, input the following code: ' '||"Time"."Per Name Half"
When I print or exprt PDF, the spaces will be disappeared in PDF.
I try to do many methods , but do not find good solution to add some spaces in front of content of the second report for show hierarchy structure as below:
CombinedColumn(Year and Month Column Combined)
Note: '-----' on behalf of space
Is there any good suggestion or related method to solve this issue? Please help me to find it or give me better opinions .Thanks for your kindly help.
I think using agents this can be done; use agents to save a file in pdf format through vb/js code. That might preserve all custom formats.
If agent option is feasible for your requirements, just give a try.
Since this report is combined request which combined several columns, such as Year,Month, Day
I only configure one "Left indent in the style properties for the column " in result column.
I want to expected result:
'-----' represent ' '
To achieve this,
You can make use of column properties->Horizontal Alignment = Right and Vertical Alignment=Top, But you have multiple requests in your report. The approach is to differentiate different levels and apply conditional formatting. Try this approach,
1. Click on the combined request so that you can see "Add Result column" option in the left pane
2. Click on "Add Result Column", in the column formula type in your time dimension column (if the column is in first posiiton type saw_0)
3.Again Click on "Add Result Column" , in the column formula enter : case when LENGTH(saw_0) > 5 then 2 else 1 end
Here LENGTH(saw_0) > 5 will return only month records (i.e)200901,200902 etc
4.Now click on column properties of the new column added in step2, goto conditional formatting->Add Condition ->Select the column added in step 3 ->
Case when LENGTH(saw_0) > 5 then 2 else 1 end = 2 then format -> Horizontal Alignment = Right and Vertical Alignment=Top
This will indent the month column to right. This will work when exported to pdf.