Is the text containing the word "cancelled" static (or there are a limited number of versions of it)?

Might be that I don't know enough about SSRS, but I think you...

Joe,

Do you only want to format the word "cancelled"?

This highlights the whole field:

=IIF(InStr(LCase(Fields!AcctStatus.Value),"cancelled")>0,"Red","Black")

(but it depends on what you attach the formatting to).

Looks like he's trying to pass multiple values into a stored procedure without using a TVF, or something like DelimitedSplit8K().

This worked for me:

USE tempdb;

GO

CREATE TABLE test (testID int identity,

clientID int);

GO

INSERT...

You would execute your stored procedure inside the WHILE loop.

WHILE @CurrDate<@EndDate

BEGIN

EXEC myStoredProc @Param1, @CurrDate;

SET @CurrDate = DATEADD(wk,1,@CurrDate);

END

=DATEADD( "d", -1, DATEADD("q", DATEDIFF("q", 0, TODAY()),0))

TODAY() is a .NET expression. The equivalent T-SQL is GETDATE()

Scott,

Pretty good post for a rookie, but you're missing part of the question. We can't see your computer, so we can't see your database or the tables in it, so...

<kidding>

DelimitedSplit, Tally table... it's all Jeff Moden voodoo... =)

Looks like DelimitedSplit8K and a "conversion table" would do the job.

the DelimitedSplit8K would split out the string into individual characters, and then you could join that to the conversion table

(OriginalChar...

Sounds like you have the wrong column in your cube. You have to do the date math on a date column, not a text column. If you fix that,...

How do you do distinct in DAX against the column from the 'one' side, so that it deamplifies what is happening due to the join on the 'many' side?

DISTINCTCOUNT(RELATEDTABLE('TableName')) ?

http://www.sqlservercentral.com/blogs/juggling_with_sql/2011/12/26/dynamic-sorting-in-ssrs/

http://blog.stevienova.com/2012/04/27/dynamic-sorting-using-parameters-in-ssrs/

http://stackoverflow.com/questions/9381726/sort-table-by-parameter-reporting-services-2008

Welcome to SSC.

Since you're new, I'll go easy on you. =)

Thanks for the data, but it's not in a format we can use. If you could provide some CREATE TABLE...

Sounds like you need a Calendar table. Then you can link that to your data table and then group by the Calendar columns. There's a handy Calendar table...

Sounds like you can get the answer by using a cross join and then an EXCEPT or an outer join... but one question first...

Do your tables have primary (unique) keys?...

If you want rows to now show...