If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to hide blank cells in a list?

Started by elroy, 17 Feb 2011 02:23:40 AM

Previous topic - Next topic

elroy

Hi all,
I used the search function of this forum but I didn`t find anything that could help.

Okay, I have the following problem:
http://www.fotos-hochladen.net/view/problemjfsy1erm2v.jpg

The list based on one query. Every column has it`s own data item. This data item contains a condition:
CASE Name
WHEN 'AB' THEN (convert(char(8),start,108))
END
This case construction has the consequence that some cells getting blank.

I found different solutions but no one worked entirely:

1. I created a filter in the query ([ABStart] <> ' ' and [ABEnd] <> ' ' and [ABDifference] <> ' ' .. and so on)
2. Used the aggregat function and show only the minimum or maximum value. But there can be 2 rows on one date and with this solution i will loose one value.

Have you any ideas to solving the problem?
Please write as soons as possible :)

Thanks and Regards,
elroy

Lynn

I've done this sort of smushing together (that's a technical term) by making a query reference to the base query and then pointing the list to the referenced query.

ReportQuery2 <-- BaseQuery1

In this situation you can create expressions in ReportQuery2 that use aggregate functions with a "for" clause to scrunch things up (another technical term) the way you need. Honestly I always have to play around to get what I'm after so I can't say for sure what exact expressions you need. The main point here is that specifying the scope of the aggregation in an expression can give you more control than just the aggregate property on a data item alone.

Hope this is in some way useful :)