you'll have to create your own interface to do that.

Mark Eytcheson (8/11/2008)

---

... I've set up a matrix with the following Row Group and Column Groups:

row group:

matrix1_purchaser - grouped on "PURCHASER"

column groups:

matrix1_PromiseYear - grouped on "PromiseYear"

matrix1_PromiseMonth - grouped on...

when using a matrix, all detail cells should use an aggregate function even if you know there's only one value. the matrix's subtotals will then be based on that...

the subtotal's calculation is based on the detail cell. change the detail cell to use sum(...) instead of first(...).

steve (8/11/2008)

---

I can understand using the high-values in the "TO" part of the range to eliminate extra code. However, I am interested in a specific value when I provide one...

no simple ones. as you've discovered, you can't access the intermediate summaries of a matrix. (in the...

Oy! Can the datasets be combined?

depends on how many reports he has to do and when they have to be done. since the sql is coming from existing code, making 'improvements' may open up...

you'll need group on the following expression to get the week:

CInt(datediff( day, [first date of report], [date column] ) / 7)+ 1

you do realize that if you'd go back to your original code and replace @holidayTbl with @HolidayTbl (as noted...

are the two matrices coming from 2 datasets or 1 dataset? if it's a single dataset, then create another matrix with a single row grouping that equates to whatever...

giontech (8/7/2008)

---

Is there a way to do sum distinct in reporting services?

I have a matrix with two column groupings and subtotals for each of them, but I can't find a...

i need an example or a report to understand your problem. is this what trying to get?

[font="Courier New"] |jun |jul |aug |total

aaa | 10...

Like Jack said, the problem is your variable names are changing case.

[font="Courier New"]select @holidaycnt = (select count(*) from @holidayTbl[/font]

should be

[font="Courier New"]select @holidaycnt = (select count(*)...

i use declare in all of my SSRS 2005 reports so it definitely can be used. have you defined any of the declared variables as report parameters? ...