Prev: SQL 2008 x64 SP1 SSRS
Next: SSRS 2005 matrix using rows as headings
From: Patrice on 18 Mar 2010 11:45
Hello all,

Let's start with a matrix report that groups my data by area, status,
company and project. Now the problem is that it creates numerous columns and
actually :
- I don't care about the project sub totals but would still like to know
which projects are involved.

That is basically I would like to group my data by area, status, company. It
shows the total for all projects as I would like. But now I would like to
add a 4th level that would show only a single column per company and that
would show all the project codes contributing to this company :

I tried to concatenate data using a custom method but the problem is that
aggregation happens before my method being called. The last option I see
would be do that directly in my server side but would be curious if someone
could find something for SSRS...

Thanks in advance.

--
Patrice




From: Patrice on 18 Mar 2010 12:42
> That is basically I would like to group my data by area, status, company.
> It shows the total for all projects as I would like. But now I would like
> to add a 4th level that would show only a single column per company and
> that would show all the project codes contributing to this company.

What seems to work :
- added a 4th level
- the cell includes a table that uses the same datasource. Seems to be
already filtered. Adding a grouping allows to avoid duplicates.

That said it is likely that calculating these values as a single field
inside the stored proc that extracts my data would be likely a more standard
solution and would make me fill more in control...
--
Patrice





 | 
Pages: 1
Prev: SQL 2008 x64 SP1 SSRS
Next: SSRS 2005 matrix using rows as headings