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

ABOUT REPORT IN REPORT BUILDER Expand / Collapse
Author
Message
Posted Tuesday, September 17, 2013 5:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 14, 2013 12:26 AM
Points: 3, Visits: 19
HOW TO GET parameter value as null when we keep as null and show the text what we enter in textbox in report tiltle
for example

=IIF(IsNothing(Parameters!CUST_CODE.Value), "All" , "" ) what should we write in second " "
plz i need help



thank you
Post #1495445
Posted Thursday, September 19, 2013 4:58 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 1:42 PM
Points: 3,103, Visits: 1,343
How about :

=IIF(IsNothing(Parameters!CUST_CODE.Value), "All" , "Report : Parameter value is " + Parameters!CUST_CODE.Value )

Fitz
Post #1496308
Posted Tuesday, September 24, 2013 4:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 14, 2013 12:26 AM
Points: 3, Visits: 19
THANK YOU
Post #1497750
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse