No announcements
Found 320928 threads
-
0 Votesiif expression
Hello, This can be done by just concating the values, instaed of using IIF expression.Answered | 7 Replies | 4200 Views | Created by smandl - Tuesday, February 10, 2009 9:08 PM | Last reply by smandl - Wednesday, February 11, 2009 2:05 PM
-
1 Votes
iif expression
Here's what you can do: Let's assume that your dataset is named "DataSet1" and has two fields as ...Answered | 4 Replies | 2476 Views | Created by sql.anandan - Thursday, July 19, 2012 5:57 AM | Last reply by IceQB (MCITP, MCC) - Thursday, July 19, 2012 6:44 AM -
0 Votes
IIF expression
I assume that your data is something like this: id ABC DEF GHI1 'a' '' ''2 '' 'a' ''Of course this is a sample structure based on which I build the ...Answered | 6 Replies | 5071 Views | Created by Mike_Do - Thursday, April 15, 2010 4:27 PM | Last reply by Mike_Do - Thursday, April 15, 2010 5:43 PM -
0 Votes
IIF expression
SSRS: Adding Calculated Fields To Data Sets Besides, please refer to the link below to see how to use IIF function.Answered | 3 Replies | 1122 Views | Created by lrj1985 - Monday, February 10, 2014 7:50 AM | Last reply by Charlie Liao - Tuesday, February 11, 2014 2:35 AM -
0 Votes
Expressions: IIF and Replace Statments
After testing it in my environment, we can try to use the expression below to achieve your ...Answered | 4 Replies | 1108 Views | Created by Y_Tyler - Friday, November 15, 2013 6:15 PM | Last reply by Y_Tyler - Monday, November 18, 2013 11:15 PM -
0 Votes
IIF statement in expression with a list
Hello, I need to write an IIF expression but have the equal expression be in a list, something similar to: =IIF(First(Fields!Answered | 1 Replies | 3808 Views | Created by DL_Spokane - Wednesday, October 5, 2011 5:51 PM | Last reply by Igor Gelin - Wednesday, October 5, 2011 8:31 PM -
0 Votes
Summing an IIF Expression
Meaning in your IIF statment as you have used 0 , it would have got considered as int and the other addition may result in double or something. so try converting both values to same ...Answered | 4 Replies | 1390 Views | Created by SharonE8 - Friday, June 28, 2013 12:17 PM | Last reply by SharonE8 - Friday, June 28, 2013 1:43 PM -
0 Votes
IIF and IsNothing with SSRS Expression
In your scenario, this error means that the text box expression should be no syntax issue, the data might cause the error.Answered | 3 Replies | 10067 Views | Created by Jeffs1977 - Monday, June 22, 2015 2:24 PM | Last reply by 王者荣耀 - Tuesday, June 23, 2015 11:35 AM -
0 Votes
or operator in iif expression
The expression should be something like this =IIF(First(Fields!Answered | 1 Replies | 5323 Views | Created by tinafmills - Monday, January 17, 2011 4:53 AM | Last reply by M Mahendra - Monday, January 17, 2011 5:07 AM -
0 Votes
Iif with % in background expression
If so, =iif(Left(Fields!Answered | 4 Replies | 1023 Views | Created by DIEGOCTN - Thursday, October 24, 2013 4:08 PM | Last reply by DJAnsc - Thursday, October 24, 2013 7:24 PM -
0 Votes
Sum(Iif Expression
=COUNTDISTINCT(IIF(Fields!Answered | 7 Replies | 1921 Views | Created by Frankmlr - Friday, August 8, 2014 7:26 PM | Last reply by Frankmlr - Tuesday, August 12, 2014 12:46 PM -
3 Votes
Report Builder 3.0 IIF Expression
Back to the error message: The Value expression for the textrun 'FINALSIGN1.Paragraphs[0]' contains an error: [BC30455] Argument not specified for parameter 'FalsePart' of ...Answered | 29 Replies | 20330 Views | Created by dustin5378 - Monday, February 9, 2015 5:26 PM | Last reply by Guoxiong Yuan - Thursday, February 12, 2015 9:34 PM -
1 Votes
IIF in crosstab expression
4 And Month([DelDate])Answered | 2 Replies | 1341 Views | Created by Keith Gardner - Tuesday, December 4, 2012 3:32 PM | Last reply by Keith Gardner - Tuesday, December 4, 2012 4:07 PM -
2 Votes
Writing IIF Expression and getting error.
Hi fawad_siddiqui, As per my understanding, ‘ad’ is a calculated field with the expression: =iif(Fields!Answered | 4 Replies | 1787 Views | Created by fawad_siddiqui - Thursday, August 7, 2014 2:44 PM | Last reply by At5 - Monday, August 11, 2014 9:47 AM -
0 Votes
Need IIF expression to calculate the total
This thread at https://social.msdn.microsoft.com/forums/sqlserver/en-US/cb0d016b-83be-4720-8ffc-c4af48f4a5a0/ssrs-iif-syntax has a solution.Answered | 5 Replies | 953 Views | Created by SQL DBA1 - Friday, January 16, 2015 11:39 PM | Last reply by Vaibhav.Chaudhari - Sunday, January 18, 2015 6:56 AM -
0 Votes
"IIF" Expression on parameter in MDX query
Hi pmak, No, you should use this expression in your MDX query.Answered | 3 Replies | 1440 Views | Created by pmak - Wednesday, March 30, 2016 5:47 PM | Last reply by Simon_Hou - Thursday, March 31, 2016 1:14 PM -
0 Votes
multiple iif expression
Hi Tina, To debug this can you create different textboxes and pass you values to it to get the exact value what you getting in your expression.Answered | 6 Replies | 6439 Views | Created by tinafmills - Saturday, January 8, 2011 8:07 PM | Last reply by Pritam_Shetty - Sunday, January 9, 2011 4:15 PM -
0 Votes
Bamboozled by a very simple IIf expression.
Hi, Try this =IIF(ISNOTHING(Fields!Answered | 2 Replies | 3486 Views | Created by TomB1988 - Monday, September 14, 2009 9:32 AM | Last reply by TomB1988 - Monday, September 14, 2009 9:56 AM -
0 Votes
Report builder 2.0 IIF expression
Hi, =SUM(IIF(Fields!Answered | 4 Replies | 3829 Views | Created by conwal - Thursday, December 8, 2011 12:15 PM | Last reply by Asim Bagwan - Tuesday, December 13, 2011 10:10 AM -
0 Votes
Summing up Expression with Multiple IIF
See detailed information about the iif function at :Answered | 1 Replies | 941 Views | Created by lilutchay - Monday, November 19, 2018 6:28 PM | Last reply by Mitarai Queen - Tuesday, November 20, 2018 2:33 AM - Items 1 to 20 of 320928 Next ›
No announcements
