k1234 Posted January 28, 2009 Share Posted January 28, 2009 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............ Link to comment Share on other sites More sharing options...
lucianc Posted January 28, 2009 Share Posted January 28, 2009 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> Link to comment Share on other sites More sharing options...
k1234 Posted January 28, 2009 Author Share Posted January 28, 2009 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. Link to comment Share on other sites More sharing options...
ktalarico Posted July 21, 2009 Share Posted July 21, 2009 I have the same problem. Did you ever find the solution? Link to comment Share on other sites More sharing options...
k1234 Posted July 23, 2009 Author Share Posted July 23, 2009 hi ktalarico, I have not find any solution yet for this, if u find any solution please let me know. Thanks in advance.. Link to comment Share on other sites More sharing options...
lucianc Posted August 20, 2009 Share Posted August 20, 2009 k1234Wrote: 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now