Recent content by banditx42

Yeah, I started out doing a manual crosstab and found it to be really cumbersome. I think my report is too big for that because I am doing monthly, weekly, and daily crosstabs. I am gonna try the periods table, I just hope I don't have to change my formulas too much. Thanks

I have set up a crosstabs to display summarized monthly totals in my report. The problem is, some groups have no data for some months, and therefore the crosstabs are a different size than the rest (only show july-oct rather than jan-oct). Is there any way to force the crosstab to show the...

I have set up a crosstabs to display summarized monthly totals in my report. The problem is, some groups have no data for some months, and therefore the crosstabs are a different size than the rest (only show july-oct rather than jan-oct). Is there any way to force the crosstab to show the...

Thanks, it finally worked. Why do these damn things have to be so picky

The problem with that method is that it includes a summary function and therefore you cannot perform further summary functions on the formula. What I need to do is subtract the max date from another date field for each group and then average the results from each group.

On a report I am working on I need to find the maximum date for a field within each group and then perform calculations using that date. Since I have to do a final average on those calculations I cannot use the built in summary to find the maximum date in the field. I have tried using the 3...