Solved

I want to give a text box values based on the value a field. How would i do so?

Posted on 2015-01-13
3
77 Views
Last Modified: 2015-01-13
For example if Field!PONumber  contains a c i want it to show one set of text otherwise i want it to show other text
0
Comment
Question by:vbnetcoder
3 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40546565
=IIf(InStr(Field!PONumber.Value, "c") > 0, "Yes","No")
0
 
LVL 15

Accepted Solution

by:
Haris Djulic earned 500 total points
ID: 40546569
HI,

where is this textbox? if you are bulding SQL for report you can use CASE function like this

Select ( case when Field!PONumber like '%c%' then 'TEXT' else 'TEXT2' end) as textbox_text

Open in new window

0
 

Author Closing Comment

by:vbnetcoder
ID: 40547470
ty
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Data source in SSRS 2 60
SCCM Reporting 5 77
Report Builder 3.0 3 52
How to get time difference in minutes and seconds only between 2 dates 2 55
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question