Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Annotate text SELECTIVELY in Value property of a textbox in Report Designer Expand / Collapse
Author
Message
Posted Tuesday, March 18, 2008 10:57 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:32 PM
Points: 1,862, Visits: 3,606
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 2
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
Posted Tuesday, March 25, 2008 7:42 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:46 PM
Points: 1,045, Visits: 2,725
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
Independent Business Intelligence Consultant
www.TimMitchell.net
@Tim_Mitchell

Post #474465
Posted Wednesday, March 26, 2008 8:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:32 PM
Points: 1,862, Visits: 3,606
Tim Mitchell (3/25/2008)
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


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 2
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 »

Add to briefcase

Permissions Expand / Collapse