Group by months when a month doesn't exist. 1

[dgrazioso]

I need to group invoices by month. That part is easy: either group on the invoice date and change every month, or create a formula Month(Invoice Date) and group on the formula. The problem is that some customers have no sales for the month, so the report for that customer looks funky, as it is missing month names. I use the MonthName function to show:
Jan
Feb
Apr
Sept
Dec
This is annoying the end users. Thanks!!!

 

[bdreed35]

Take a look at this faq767-4532 It is the best way to get what you want.

If that is not a possibility, then here is a BOBJ whitepaper that will get you thinking in the right direction:

http://support.businessobjects.com/library/kbase/articles/c2002147.asp

~Brian

 

[dgrazioso]

Appreciate your quick reply. The BOBJ white paper looks like a possibility - I'll give it a try. Thanks for your help!

 

[synapsevampire]

If you have CR XI then you can use query in a command object to select all of the dates required and then LO join it to your table.

Try posting your Crystal version for better results.

-k

 

[chelseatech]

There was a series of articles in the early days of our Crystal Clear Newsletter looking at reporting from missing data.

This missing month problem was solved using Previous and Next functions to create the missing months as a string.

Download the back issues for details.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[dgrazioso]

I'm working with version 8.5. Good to know other versions offer more solutions. I'll check out the Newsletter. Thanks to ALL!!