nm, i figured it out. i thought you needed a group in the table for the below script to work but apparently not.....

=iif(RunningValue(Fields!descr.Value & Fields!sequence.Value,CountDistinct,Nothing) Mod 2, "lightBlue", "White")

I cant group it because the user needs to see all the details of each row (i didnt list all the columns). How do I increment for each change?

anyone???

It works! Always nice to end the week this way =)

Yea I just discovered the ReportItems collection. I will test it out.

link to sub-report

excellent!

Jack Corbett (5/5/2009)

---

Yes it is possible, but you will have to either use Dynamic SQL or use a temporary table to hold the results form the query against each database...

Sergiy (4/28/2009)

---

is250sp (4/28/2009)

---

I have 3 tables. First table contains employee information called Employees. Second table contains the earning codes called Erncd. Third table has the actual earnings...

Thanks, I've already built it in SRS as a matrix report and it works beautifully, its just the other limitations of SRS that frustrate me and eventually the end user....

select 'John' as name ,'1234' as emplid

into #employees

select 'REG' as erncd, 'A' as status into #erncd

union

select 'OT' as erncd, 'A' as status

union

select 'OTH' as erncd, 'I' as status

select '1234' as...

help please???

In your SQL script, you can use CAST or CONVERT to return just the date, not date/time, and use that field in your grouping.

Or (and I have never...

thanks, that worked!

Oh I had that section commented out because...