Annotate text SELECTIVELY in Value property of a textbox in Report Designer

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Annotate text SELECTIVELY in Value property...

Annotate text SELECTIVELY in Value property of a textbox in Report Designer

Rate Topic

Display Mode

Topic Options

Author

Message

Marios Philippopoulos

Posted Tuesday, March 18, 2008 10:57 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825, Visits: 3,484

Here is what I want to do:

In the Value property of the textbox in VS Report Designer I have:

="Members of NT Group: " & Fields!NTGroup.Value

I want it to show up in the Browser as:

Members of NT Group: SEC_group1

Is that possible and how?

thanks!
Marios

__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation

Post #471023

Tim Mitchell

Posted Tuesday, March 25, 2008 7:42 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:12 PM
Points: 1,034, Visits: 2,611

I don't think you can do what you describe if you only use one control. Controls are rendered as a whole rather than character-by-character.

Is there any reason you can't use a separate control for your static text?

Tim

Tim Mitchell
SQL Server MVP
www.TimMitchell.net
@Tim_Mitchell

Post #474465

Marios Philippopoulos

Posted Wednesday, March 26, 2008 8:45 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825, Visits: 3,484

Tim Mitchell (3/25/2008)

If separate controls are the only way to do this, I can live with that.
I was just wondering whether there were any VB-like controls that would do the same thing.

Thank you for the response.

__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation

Post #474787

« Prev Topic | Next Topic »

Permissions