If a cross tab row is null

[k1234]

Hi everyone,

 

I am using cross tab in my report, where in i have one row group. The query returns one null row also, So my prob is "i dont want to get that group(null row) in my cross tab".

Please if anybody can help me in this that would be great.

Thanks in advance............

[lucianc]

Use the "increment when" expression of the crosstab dataset to skip the null row.

HTH,

Lucian

 

Code:

<crosstab>  ...  <crosstabDataset>    <dataset>      <incrementWhenExpression>Boolean.valueOf($F{..field..} != null)</incrementWhenExpression>    </dataset>  </crosstabDataset>

[k1234]

Hi yaa...

 

Thank you for the information...

 

the null row is got deducted but i have some column groups also with the row group element as null....if i use this expression i got that column group also deducted.

[ktalarico]

I have the same problem.  Did you ever find the solution?

[k1234]

hi ktalarico,

 

I have not find any solution yet for this, if u find any solution please let me know.

 

Thanks in advance..

[lucianc]

k1234
Wrote:

Hi yaa... Thank you for the information... the null row is got deducted but i have some column groups also with the row group element as null....if i use this expression i got that column group also deducted.

I don't undeerstand the case.  Can you provide a concrete example (i.e. what data is sent to the report, what are the crosstab row and column groups, what is the dataset increment when expression, what output do you get and what output do you expect)?

Regards,

Lucian