Do we need to include a time intelligence on month by month basis?

How can we get the splits of costs into monthly buckets?

Right now, it's the total sum repeated in...

check out the last posts here:

http://stackoverflow.com/questions/44376/add-alternating-row-color-to-sql-server-reporting-services-report

what version of SSRS do you have?

So, I got it to work with the help of a "Periods" look-up table that I created.

My main table, which showed the 12 monthly periods, had one column which was...

Thanks Yulika!

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=4095629&SiteID=1

hello!

I haven't tried this myself, as the customer said "don't worry about it...no huge deal right now"...but looks like someone got it to work.

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=2511056&SiteID=1

If the users click a link, add &rs:ClearSession=True to the end of the URL.

We had to do that with our reports since the data is changing constantly.

All, this did the trick ...and thanks for you help!

Declare @Temp Table(ColumnA VarChar(40), ColumnB VarChar(400))

insert into @Temp Values('AA.ProjectBuildTower','2222, 3333, 4444, 5555')

insert into @Temp Values('BB.ProjectBuildFence','X900, 6789, 9000, 9876')

Declare @Output Table(Header VarChar(40),...

Thanks for the replies!

I'm trying to use this example:

http://www.sqlservercentral.com/scripts/T-SQL+Aids/31871/

I've added it to my UDFs under that database under table valued Functions, but when I run the following SQL:

SELECT...

Ahh...will do!

Thanks for the heads up!

This did the trick:

CREATE FUNCTION dbo.ConcatOwners4(@ActID CHAR(50))

RETURNS VARCHAR(8000)

AS

BEGIN

DECLARE @Output VARCHAR(8000)

SELECT @Output = SUBSTRING(

(SELECT ',' + SAN.Authority AS "text()"

FROM Activity

...

Mark,

Thanks a ton...that did the trick!

UDF's sure are are great thing to have!

HYDNIZ,

Thanks...that was it. I was clicking the whole text box, and not the little green upper right triangle.

Thanks again!

Thanks to both of you for the posts!

I ended up using this certain report as "remote" mode instead of "local" mode in the reportviewer control since it had a parameter,...

Hey all!

I just ran into a little issue where you have two groups, and you'd need the 2nd grouping to alternate it's coloring.

I used the following and it worked:

= iif...