ReportNet, formatting Column Title 2

[ChillAPAC]

I have a custom column title in ReportNet, I'm concatenating text and query items:
'Current Week' || to_char([Current Week Starting Date],'mm/dd/yyyy') || ' - ' || to_char([Current Week Ending Date],'mm/dd/yyyy')
This works but it is coming through as:
Current Week 11/06/2005 - 11/12/2005 (all on one line).

The column title should look like:
Current Week
11/06/2005 - 11/12/2005

How can I insert a carriage return after the 'Current Week' text? Or is there another way to force a carriage return in the column title?

Thanks,

 

[KingCrab]

Try adding a + '<br> ' +?

 

[ChillAPAC]

Thanks for the suggestion.
I've tried:
<br>
'<br>'
|| <br> ||
+ <br>
+ '<br>' +
+ <br> ||
and several variations, all return an error. I've been unable to pass the html through. They come back with a parsing error.

 

[KingCrab]

Unlock your layout and add a HTML Item right before your column title

The HTML Item would be something like "Current week<br>"

 

[ChillAPAC]

Great, this works.

Current Week <br>

Thank you!!

 

[vzak]

What if user wants to use PDF format? Would HTML tags work?

 

[ChillAPAC]

I ran a quick test, it exports to excel ok but NOT to PDF.

Bill

 

[KingCrab]

How about adding a char(13) instead?

'Current Week' + char(13) || to_char([Current Week Starting Date],'mm/dd/yyyy') || ' - ' || to_char([Current Week Ending Date],'mm/dd/yyyy')

 

[ChillAPAC]

Adding "+ char(13)" returns an error message:

QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0446 Oracle returned an error message.
ORA-00936: missing expression
UDA-SQL-0450 An unexpected error encountered during the "prepare" operation.

I only need the excel export so I'm good to go. Thanks for your assistance.

Bill

 

[KingCrab]

ahh.. Oracle would be chr(13)

So, I think to fix this you have to do a couple things.

Add a TEXT item containing "Current Week"
Add a HTML item containing "<br>"
Add you data item with a leading chr(13)+

This seems to keep the display correct in HMTL, excel, and PDF

 

[vzak]

The easiest way to do this is to insert to blocks. For the top block insert text item with text 'Current Week'.
The bottom block will have '11/06/2005 - 11/12/2005'. Don't forget to align properly.
Vlad

 

[searching4best]

Use Table.

Insert table with 2 rows and one column.
Insert "Current Week" in first row.
Insert dates in second row.
Thats it.
Align it accordingy.