I've been diving into SSRS after seeing Ryan and Paul's great presentations at the conference. I'm hoping someone can help me with a bit of formatting. Taking some tips from Paul's powerpoint, I've got a cell with this express:
="Totals for " & Fields!prod_desc.Value &":"
prod_desc is a show title. I'd like to italicize just that part of the expression. Any tips?
thanks
Brian
Don't know if it will work or not but try
="Totals for " & "<i>" & Fields!prod_desc.Value & "</i>" & ":"
Plus I think it may only work in SSRS 2008
Marty Jones
Director of Information Services
Omaha Performing Arts 1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham Sent: Thursday, September 08, 2011 1:56 PM To: Martin A. Jones Subject: [Tessitura Technical Forum] formatting in SSRS with vba
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Look at this link. I did get this to work.
http://sqlserverpedia.com/blog/sql-server-bloggers/using-different-formats-within-a-single-textbox-in-ssrs/
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Marty Jones Sent: Thursday, September 08, 2011 2:11 PM To: Martin A. Jones Subject: RE: [Tessitura Technical Forum] formatting in SSRS with vba
Perfect! Great article. Thanks Marty!
Thanks Marty, great info.
One question: I had a placeholder that had two parts to it so I had added a carriage return using ‘vbcrlf’
="Period: " & FormatDateTime(Parameters!Start_Date.Value,DateFormat.ShortDate) & " to " & FormatDateTime(Parameters!End_date.Value,DateFormat.ShortDate) & vbcrlf & "Portfolio: " & Parameters!Portfolio.Value
As soon as I switched the placeholder properties to HTML the carriage return stopped working. Does anyone know if there is a way to have this work with HTML switched on?
Peter Nelson
Business Analyst, Information Systems
T 02 9250 7180 M 0401 714 246
Sydney Opera House Bennelong Point
GPO Box 4274 Sydney NSW 2001 AUSTRALIA
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian GrahamSent: Friday, 9 September 2011 05:36To: Peter NelsonSubject: RE: [Tessitura Technical Forum] formatting in SSRS with vba
From: Marty Jones <bounce-martyjones7649@tessituranetwork.com>Sent: 9/8/2011 2:20:54 PM
Omaha Performing Arts1200 Douglas Street
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Marty JonesSent: Thursday, September 08, 2011 2:11 PMTo: Martin A. JonesSubject: RE: [Tessitura Technical Forum] formatting in SSRS with vba
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian GrahamSent: Thursday, September 08, 2011 1:56 PMTo: Martin A. JonesSubject: [Tessitura Technical Forum] formatting in SSRS with vba
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!Please consider the environment before printing this email.
Please consider the environment before printing this email.=====This message is intended for the addressee(s) named and may contain confidential information.If you are not the intended recipient, please delete it and notify the sender.Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
My cool colleague Adriana solved this for me.
Of course I can just use a standard HTML “<br>” code instead, and now have best of both worlds.
From: Peter Nelson Sent: Friday, 9 September 2011 09:43To: 'Tessitura Technical Forum'Subject: RE: [Tessitura Technical Forum] formatting in SSRS with vba
You can also separate the text into separate placeholders with different formatting if you wish, in lieu of using HTML formatting.
As the article mentions below, it recommends not going too crazy with HTML formatting or you will run into formatting issues in other formats like Word, Excel, and PDF. Most basic options (like <b>, <i>, <br> and even <ul/>) work just fine.
+Ryan Creps
+Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Peter NelsonSent: Thursday, September 08, 2011 8:06 PMTo: Ryan CrepsSubject: RE: [Tessitura Technical Forum] formatting in SSRS with vba