No announcements
Found 118246 threads
-
0 VotesSum iff with dateADD
= DATEADD(mm, - 3, GETDATE()), Cdbl(Fields!MonthlyDBTotal.Value), 0.0))/ 3) By the way, ...Answered | 2 Replies | 5468 Views | Created by LZee - Thursday, April 17, 2008 2:30 PM | Last reply by LZee - Thursday, April 17, 2008 7:23 PM
-
0 Votes
ssrs 2008 r2 complex iff statement
http://social.technet.microsoft.com/Forums/en-US/61bb7046-3dcd-48fc-b946-508284ac67c4/ssrs-2008-r2-complex-iff-statement?forumAnswered | 3 Replies | 2170 Views | Created by wendy elizabeth - Thursday, October 3, 2013 10:09 PM | Last reply by Charlie Liao - Friday, October 4, 2013 1:17 AM -
0 Votes
Adding people to groups based on employeeType
mathematical 1000000! number of operations (or something like that). I'm just glad we decided against letting it run for a couple of days since ...Answered | 14 Replies | 4491 Views | Created by pnold - Tuesday, April 3, 2007 6:48 AM | Last reply by Richard Wakeman - MSFT - Tuesday, April 3, 2007 10:48 AM -
0 Votes
IFF/ISEMPTY question
Hi all, What I'm trying to do is for every dimension/pivot have the below work, but it only seems to work on the highest level possible and not quite when you drill down. Basically ...Answered | 7 Replies | 5419 Views | Created by AkshayBM - Monday, March 17, 2008 1:18 PM | Last reply by Deepak Puri - Wednesday, March 19, 2008 5:57 PM -
0 Votes
Iff statement error
Hi All, I waswondering where I'm going wrong with the following query please. I'm trying to create a Report which has two different criteria (which ...Answered | 2 Replies | 3037 Views | Created by ti2 - Wednesday, March 7, 2012 11:38 AM | Last reply by ti2 - Wednesday, March 7, 2012 1:07 PM -
0 Votes
SQL Server 2012: IFF In Select Clause
80 THEN value else some valueAnswered | 5 Replies | 871 Views | Created by pianoboyCoder - Tuesday, November 24, 2015 10:07 PM | Last reply by Visakh16 - Wednesday, November 25, 2015 10:22 AM -
0 Votes
DateAdd Expressions and IFF Null? Help required
;,-12,Date())) So if 'Veh_Parts_Date' has a date but 'Veh_Tyres_Date' doesnt Then no information is returned. I need the IFF Null ...Answered | 7 Replies | 695 Views | Created by NHSTech - Friday, May 22, 2015 8:46 PM | Last reply by --CELKO-- - Saturday, May 23, 2015 8:21 PM -
0 Votes
employeeType user attribute isn't available from Get-User
Thanks. I ended up using: Get-QADUser –organizationalUnit $OU -Ldap ...Answered | 4 Replies | 16993 Views | Created by Matty_C - Tuesday, November 24, 2009 7:25 AM | Last reply by Matty_C - Thursday, November 26, 2009 7:28 AM -
0 Votes
Combine JOIN and IFF?
In report builder for VB Script, can I combine a JOIN for parameter and IIF. Eg. I have multiple values in a string '201607' and '201607' I want these both to display as June and July ...Answered | 3 Replies | 358 Views | Created by KittyCat101 - Monday, June 5, 2017 8:11 PM | Last reply by Jackson_1990 - Tuesday, June 6, 2017 4:26 AM -
0 Votes
Formula iff 1 then -
hai, This is my formula: (([Client].&[Realisation]/([Client].&[Classmin])) / ([Client].&[Classmax] - ...Answered | 2 Replies | 3525 Views | Created by MYMY2 - Wednesday, March 25, 2009 9:39 AM | Last reply by MYMY2 - Wednesday, March 25, 2009 11:45 AM -
1 Votes
=SUM with IFF
I have a simple =sum(Fields!something.Value) that brings back NaN. I'm thinging this is a null value but I try to add IIF(Fields!something.value = "NULL",0) but id SSRS ...Answered | 7 Replies | 1982 Views | Created by Unwind_1 - Wednesday, October 3, 2012 7:14 PM | Last reply by Syed Qazafi Anjum - Thursday, October 4, 2012 7:40 PM -
1 Votes
1 IFF expression
1,True part of the message =iif (Parameters!ContactDetails.Value =-1, ...Answered | 3 Replies | 436 Views | Created by cr_banks - Wednesday, June 3, 2015 10:14 PM | Last reply by Patrick Hurst - Thursday, June 4, 2015 1:24 PM -
0 Votes
Report Builder -- IFF statements
I have a field called ActionCode, it is 10 by default but then there is a second record made when it gets modified, 21, so there are two records with an identifier ID that links both of these values. ...Answered | 2 Replies | 10468 Views | Created by tapius - Monday, February 7, 2011 5:41 PM | Last reply by Tony Chain - Thursday, February 10, 2011 9:08 AM -
0 Votes
Datasets and iff statements
Hello experts, I have a report with four different datasets that slice certain record by different days of the week. I can do the ...Unanswered | 1 Replies | 4252 Views | Created by xtrout - Thursday, September 6, 2007 8:56 PM | Last reply by xtrout - Thursday, September 6, 2007 10:36 PM -
0 Votes
SRSS IFF problem
what is wrong in this statement? =IIF(Fields!PROPERTYID.Value = "DIECHNGE1 E,DIECHNGE2 E,DIECHNGE3 E" ...Answered | 4 Replies | 2540 Views | Created by alikhan_3 - Sunday, August 5, 2012 6:21 AM | Last reply by Syed Qazafi Anjum - Sunday, August 5, 2012 8:32 PM -
0 Votes
Active Directory User Attribute employeeType Windows Server 2016
Hello together, I only have one short question, I haven't found any more information on the Microsoft Sites, is the User Attribute "employeeTypeAnswered | 4 Replies | 1412 Views | Created by A._R.1 - Monday, October 22, 2018 12:55 PM | Last reply by Lavilian Li - Tuesday, October 23, 2018 9:36 AM -
1 Votes
Dynamic Distribution Group Filtered using EmployeeType AD Attribute
Nope, as this parameter is not supported for filtering. What you can do is populate some of the customattributeXX with the employeeType value, and use it instead.Answered | 2 Replies | 443 Views | Created by CLC_20 - Thursday, January 16, 2020 10:32 AM | Last reply by Eric_Yin - Thursday, January 23, 2020 10:23 AM -
1 Votes
Update Address Atributes with IFF Function?
IFF function or di I need to write a custopm expression? Thanks in advanced for your ...Discussion | 11 Replies | 2462 Views | Created by RoBuSU - Tuesday, August 7, 2012 8:50 AM | Last reply by Paul Wijntjes - Tuesday, August 14, 2012 12:39 PM -
0 Votes
SharePoint SQL Builder - Iff + Lookup function
0Answered | 1 Replies | 2243 Views | Created by Marcin C - Wednesday, September 12, 2012 9:22 AM | Last reply by Esmari - Wednesday, September 12, 2012 9:27 AM -
2 Votes
conditional iff on a field
I have the following expression that changes the color of a particular field: =IIF(Fields!indicator.Value = ...Answered | 6 Replies | 2801 Views | Created by duhaas - Thursday, January 14, 2010 6:22 PM | Last reply by duhaas - Thursday, January 14, 2010 7:37 PM
No announcements
