Making text bold in a table cell

I want to build a string to be displayed in a table cell using an
expression, I want to make some parts of the string bold. Can I do this..?
here's an example, in my table cell I have the following expression:
= "Cause:" + Fields!Cause.Value
I want to make the text string "Cause:" bold
TIA,
DanIt's all or nothing in the current release - this attribute can be set at a
cell level, not to a part of string in the cell.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:%23H8vxFBfEHA.248@.TK2MSFTNGP12.phx.gbl...
> I want to build a string to be displayed in a table cell using an
> expression, I want to make some parts of the string bold. Can I do this..?
> here's an example, in my table cell I have the following expression:
> = "Cause:" + Fields!Cause.Value
> I want to make the text string "Cause:" bold
>
> TIA,
> Dan
>|||Formatting only part of the string (i.e. rich text) isn't in the current
version. On the wishlist for a future version.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:%23H8vxFBfEHA.248@.TK2MSFTNGP12.phx.gbl...
> I want to build a string to be displayed in a table cell using an
> expression, I want to make some parts of the string bold. Can I do this..?
> here's an example, in my table cell I have the following expression:
> = "Cause:" + Fields!Cause.Value
> I want to make the text string "Cause:" bold
>
> TIA,
> Dan
>

Making SQL 2005 Developer accept the connection string for SQL express edition

Hi, I have installed on my laptop SQL server 2005 Developer edition, I can change ANY of the settings of the SQL server and OS.

I am writing code with a team using continuous integration where the connection string is the following:
"Provider=SQLNCLI;Server=.\SQLEXPRESS;Database=Secret;Trusted_Connection=Yes;"

is there a way (create an alias,rename server, other?) to make my local dev SQL server accept the connection string above, as at the moment I have to rename the connection string every time before checking in code and after downloading the latest version from the code repository.

any advice or tips will be greatly appreciated

Thanks

JW.Hi,

setup an alias using the SQL Server Configuration manager. Configure a new alias to listen to .\sqlexpress and redirect to the installed dev server.

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de

Making a term found in a string the subject

Hi,
I am trying to make a term from a string into the subject and then be
able to count the occurences of this.
using:
Where (Fail_Desc like '%C[1-999]%' or Fail_Desc like '%U[1-99]%')
Which would output:
Fail_Desc
Replace Capacitor C123
Replace Capacitor C145
Replace Capacitor C123
Replace Device U12
And I would like it to look like:
Failing Component Qty
C123 2
C145 1
U12 1
Any ideas would be much appreciated, thanks.
Phil--Try this:
select substring(Fail_desc, patindex(fail_desc,'%C[1-999]%'),5)
'Failing Component, count(*)
from myTable
group by fail_desc
--if that group by doesn't take... use this
group by substring(Fail_desc, patindex(fail_desc,'%C[1-999]%'),5)|||On 21 Jan 2006 07:52:25 -0800, philipbennett25 wrote:

>Hi,
>I am trying to make a term from a string into the subject and then be
>able to count the occurences of this.
>using:
>Where (Fail_Desc like '%C[1-999]%' or Fail_Desc like '%U[1-99]%')
>Which would output:
>Fail_Desc
>Replace Capacitor C123
>Replace Capacitor C145
>Replace Capacitor C123
>Replace Device U12
>And I would like it to look like:
>Failing Component Qty
>C123 2
>C145 1
>U12 1
>
>Any ideas would be much appreciated, thanks.
Hi Phil,
Try if this works:
SELECT Component, COUNT(*) AS Qty
FROM (SELECT SUBSTRING(Fail_Desc,
PATINDEX('%C[1-9][0-9][0-9]%', Fail_Desc),
4)
FROM test
WHERE Fail_Desc LIKE '%C[1-9][0-9][0-9]%'
UNION ALL
SELECT SUBSTRING(Fail_Desc,
PATINDEX('%U[1-9][0-9]%', Fail_Desc),
3)
FROM test
WHERE Fail_Desc LIKE '%U[1-9][0-9]%') AS x(Component)
GROUP BY Component
If this is not what you want, then please check www.aspfaq.com/5006 for
a description of the best way to post better specifications.
Hugo Kornelis, SQL Server MVP|||Hey,
Thanks for that, it was a huge help. The funny thing about this is that
when I run the query it returns a bunch other stuff as well as the 'C%'
or the 'U%' is this normal?
Thanks
Phil|||On 27 Jan 2006 05:13:32 -0800, philipbennett25 wrote:

>Hey,
>Thanks for that, it was a huge help. The funny thing about this is that
>when I run the query it returns a bunch other stuff as well as the 'C%'
>or the 'U%' is this normal?
>Thanks
>Phil
Hi Phil,
No, that should not happen. Can you post a repro script (i.e. a short
script that I can run in my test DB to reproduce the behaviour - it
should include CREATE TABLE and INSERT statements, plus the offending
SELECT of course).
Hugo Kornelis, SQL Server MVP