If you are unable to create a new account, please email support@bspsoftware.com

 

Question regarding if statement for conditional formating in report studio

Started by madhu3117, 06 Jul 2013 05:54:03 PM

Previous topic - Next topic

madhu3117

say there are 5 columns

1.) riskconvergence date
2.) penddate
3.)issue status
4.) issue name
5.) issue description

i need a condition where
if risk convergence date between first of (pendate)month) and (pendate))
then green
else if (issue status)=pending
then pink
else
yellow



how i did it is

if ((risk convergence date) between (_first_of_the_month(pendate)) and (pendate))
then ('green')
else if (issue status)=pending
then ('pink')
else ('yellow')


i want all columns of the list should formatted from above condition .plz help its urgent and thanks in advance