ganteng1 (10/14/2014)

---

Hi Everyone. I am trying to do a multi condition IIF Statment, but is returning "Doesn't Work.

Can someone please help. See code below. Thanks

=IIF(Fields!Material.Value="Copper"

AND Fields!Measure.Value = "MASSDRY"

AND Fields!Category.Value...

In SQL, you would want something along these lines. This is a function that uses does the same sort of thing.

CREATE FUNCTION [dbo].[sfn_SetEffectiveDate]

( @InputDateDATETIME )

RETURNS DATETIME

AS

BEGIN

-- We need to...

sunnyplace (8/21/2010)

---

I created the IIF function shown below, when I run the report it will work only on the fields where I have a due date, but if the due...

danielle476 (12/30/2010)

---

ssrs 2008 r2

I have a report where we alternate row colors using = IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")

is there a way to also highlight a specific...

sethmo38 (1/21/2011)

---

I am building a report that currently has one dataset ordered by ID that gives these results

ID Start Time ...

I am having a very similar problem. I'm attempting to use a Quirky update to populate the the "Previous" state of data, so I can identify changes over time....

Quick and dirty stored procedure psuedocode:

scan

Insert into Pietable

"freespace" as category,

FreeSpaceMB as drivespace,

endscan

scan

Insert into...

bump

Sorry 'bout that, I didn't complete my edits. They have the same dimensionality. The ONLY difference is whether or not I use the "calculated set" in the SUM,...

I found a method of doing it:

WITH

MEMBER [Measures].[DateSort] AS [Date Dimension].[DATE].CURRENTMEMBER.Properties('Key')

MEMBER [Measures].[ParameterValue] AS '[Date Dimension].[DATE].CURRENTMEMBER.UNIQUENAME'

SELECT NON EMPTY

{ [Measures].[DateSort]

, [Measures].[ParameterValue]

} ON COLUMNS,

NON EMPTY

ORDER(

...

I suppose that I could, except that I haven't done anything with MDX aside from feeding it straight into the reports. So how I'd go about doing what you...

The catch is, I'm want to sort on the DATES. There are no numbers associated with this data (in this instance), its simply the drop down for the user...

I'm not familiar with ToNumber, but it sounds like it may be the same as FormatNumber. Take a look at that.

IIF constructions in SSRS always evaluate...

Use the ReportItems collection...

=ReportItems!TextboxMyFirstGroupSum.value + ReportItems!TextboxMySecondGroupSum.Value + ReportItems!TextboxMyThirdGroupSum.value