Hi, there!

I need to show some colums at crosstab, but I've had some problems, the description of the situation is:

1) I execute the CR report from an asp page which sends me the parameters used to execute a SP at SQL Server;

2) The result from SP execution has values this respective months...

Here starts the problem :rooleyes:

This result has some months absent to some groups....

For example:

Group 1: Jan, Feb, Mar, Apr, Mai, Jun, Jul, Aug, Sep, Oct, Nov, Dez (all months)

Group 2: Jun, Jul, Oct, Dez (only this months)

So the Reports shows me:

Group 1: Jan Feb, Mar, Apr, Mai, Jun, Jul, Aug, Sep, Oct, Nov, Dez
1 2 4 6 7 3 1 3 4 5 6 7
Group 2: Jun, Jul, Oct, Dez
19 3 1 1
That's ok, but it isn't fine....

I need that report shows me:

Group 1: Jan, Feb, Mar, Apr, Mai, Jun, Jul, Aug, Sep, Oct, Nov, Dez
1 2 4 6 7 3 1 3 4 5 6 7

Group 2: Jan, Feb, Mar, Apr, Mai, Jun, Jul, Aug, Sep, Oct, Nov, Dez
19 3 1 1

or

Group 1: Jan, Feb, Mar, Apr, Mai, Jun, Jul, Aug, Sep, Oct, Nov, Dez
1 2 4 6 7 3 1 3 4 5 6 7

Group 2: Jan, Feb, Mar, Apr, Mai, Jun, Jul, Aug, Sep, Oct, Nov, Dez
0 0 0 0 0 19 3 0 0 1 0 1

How can I do that, without any change on the SP ? The table has no values at the absent months, better saying, the table doesn't have these months...

I'm using CR 8.

Thanks in advance,

João Luiz