This content has been marked as final. Show 28 replies
You can do it in couple of ways -
1. In SQL report query like -
2. You can do it in the report page. Go to edit page >>Click on edit report column under the page region >>click on edit column one >> Under the HTML expression type -
SELECT COL1||COL2 "Full Name", COL3||COL4 "Adress" FROM TABLE_NAME
#COL_1# #COL_2##COL_1# and #COL_2# will translate the col1 and col2 value from the report. Change these parameters according to your report column name. Now you can untick (show) the col2 from report column edit to hide. Do the same for other column.
Hope this helps.
I believe that you can use the method you originally mentioned if you set your column to a Standard Report Column. The html in the column value will be rendered as HTML, and, in your case, a new line should be created.
EDIT: After I did a bit of testing I had to put a space character in my SQL to get it to render:
The other thing you can do is put your
SELECT col1, col2, col3||' <br/>', col4 FROM table
in your Column Formatting field for the column you want.
Edited by: AustinJ on Jul 18, 2011 10:06 AM
Thanks for the input! Well I am trying the following
still doesnt seem to be working. Which field exactly is the "Column Formatting field"?
Yes, I was referring to the HTML Expression on the Column Formatting.
Interestingly enough when I use:
Then the BR appears, however, if I use:
Then the BR does not. Hence, I put a space character after the br tag and then it does put in the additional line.
Incidentally, i use the & nbsp; syntax to insert the space.
Thanks for your help! Neither of those options seem to work. What am I doing wrong?
I have a Reports Region form a SQL Query
I have all of the columns set to "Standard Report Column"
I have "Strip HTML" set to No
I have tried using the HTML Expression as you have suggested below. I have tried putting the
in the query. But none of these options seem to create a newline for each row.
Do I need to create a Custom Region to get this functionality?
I have create a test workspace maybe someone can show me there how it is done?
currently there is a
in the job column it appears to do a newline but inside the column. I want the job column to be on the line below ename and empno
Please, let me restate the original question in my own words so that I can make sure I understand the requirements.
In the SQL output you have records and columns (I will refer to these as SQL.records and SQL.columns)
In the HTML table that is produced by the report you have rows and columns (HTML.rows and HTML.columns, repectively)
Now, for every SQL.record that is to be displayed, you would like to have two HTML.rows created. The first HTML.row contains some, but not all values from the SQL.record. The second HTML.row contains the remaining values of the SQL.record, in their appropriate HTML.columns, that were not displayed in the previous HTML.row.
Is this what you are attempting to achieve?