Click here to Skip to main content
15,891,033 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hello everyone,

i am having a report in ssrs 2005.
in that report i am making a link for one column.
in that column some values are 0 and some values are greater than 0.
link is coming for every values.
my question is how to create a link for those cells that are having values greater than 0. i mean how to write the expression in ssrs.

thanks,
rumki
Posted

1 solution

Well, all you need is to write expression.

Instead of providing the link directly, use an iif condition there and based on the value set the link.

Look here for samples and examples of expressions:
Expression Examples (Report Builder 3.0 and SSRS)[^]
A brief introduction to expressions in SQL Server 2005 reporting services[^]

Just google for more, if needed.
 
Share this answer
 
Comments
debalina2 9-Mar-11 23:59pm    
thanks Sandeep.
i got my solution from one of the above site.
Sandeep Mewara 10-Mar-11 0:02am    
:) Good to know.

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