Click here to Skip to main content
15,890,336 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Good evening all,
i developed a report using rdlc.
i just show one table data in that.
fields are id int, name string, decimal amount.

data like the bellow..
id name amount
1 luxury- @5% 500
2 Service Charges -@6% 400

now i have to customize name field.
so i send a another parameter
if i send parameter is one the data is like above table.
if i send parameter is zero then data is like bellow.

id name amount
1 luxury 500
2 Service Charges 400

i don't know how to write condition and how to split name text field.
Thanking u..
Posted

1 solution

There are 'Expression' option available for every control. All you need is to use a iif statment in it.

Something like:
for luxary field
VB
="1 luxury:" & iif(Parameters!ParamName.Value == "1","@5% "&Fields!mydata.Value,  Fields!mydata.Value)


Try!
 
Share this answer
 
Comments
ajitha.pusapati 16-May-11 8:00am    
can u explain clearly.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900