Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
runnerpaul
Starting Member
24 Posts |
 Posted - 2011-07-06 : 05:42:15
|
Hi,I'm trying to write a report and I would like to Have a column heading as follows:quote:
Risk Reference & OwnerRisk Title & Description
I was trying the likes of the following SQL but just havnt got it working yet:SELECT 'ID' + a.CustomRiskRef + CHAR(10) + a.Name + '(' + b.Name + ')' + ' ' + a.Description AS "Risk Reference & Owner" + CHAR(10) + "Risk Title & Description" FROM ...Can anybody please advise how to do this?CheersPaul |
|
|
Ranjit.ileni
Posting Yak Master
183 Posts |
Posted - 2011-07-06 : 05:49:03
|
What exactly you want?.... please give DDL with SAMPLE Data and expected outcome for Quick solution...quote:
SELECT 'ID' + a.CustomRiskRef + CHAR(10) + a.Name + '(' + b.Name + ')' + ' ' + a.Description AS "Risk Reference & Owner" + CHAR(10) + "Risk Title & Description" AS "Risk Reference & Owner" FROM ...
--Ranjit |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-07-06 : 05:59:18
|
http://www.kodyaz.com/articles/reporting-services-add-line-break-between-words-custom-code.aspx
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
runnerpaul
Starting Member
24 Posts |
Posted - 2011-07-06 : 06:44:45
|
Sorry,I wasnt very clear. I need the entire column name to appear as:quote:
Risk Reference & OwnerRisk Title & Description
Its just that I want "Risk Title & Description" to appear below "Risk Reference & Owner".CheersPaul |
|
|
|
|
|
|
Using carriage return in column names