I am having some trouble with a report that I need to break by month and count multiple columns.

If I set the break value to 30, it breaks the date element every 30 days in my report and this is not what I want.  I need to break by months.  If I set the break value to 1 or 0, it obviously just breaks when the day changes.  My date format is MM-DD-YYYY.

Also, I have multiple counts on 3 elements within this report.  They all return the same count regardless if there is info in the element or not. i.e.: 20 prospect records in the report with a NEW column that needs to only count the Y's in it (6 of them). 

Is there a way to accomplish the above ?

Thanks,

Louis

You may also be able to use ForceGroupBreak and break on anything you want, even if there is no column - any variable or LE in the report.

Mark:

I tried the ForceGroupBreak feature.  It works but does not deal with the Month break as per above. 

I will keep it in mind on other reports.

Have you encountered the count issue ?

Thanks,

Louis

I missed the count issue.......try this:

If you do @Sum(Boolean LEName) then all the TRUE values will be "counted" (TRUE=1). 

-------------------------------
Subsequent note:  The suggestion above was untested, and does not work as is.

To deal with the count issue, I did the following:

1. Created an invisible unbound number field (LE17) in the Group Body with the following code (LE11 is the boolean field):

IF LE11 = 1 THEN
{
     LE17 = 1
}
ELSE
{
     LE17 = 0
}

2.  Created a Sum calculation field in the Group Footer that sums LE17.

Now it only counts the required values.

Any inherent dangers in above ?

Thanks,

Louis