Grouping on date for multiple date fields

[gbscobel]

I am working with Crystal XI, I'm fairly experienced with the program itself but have no experience with Stored Procedures or advanced programming like that so I'm not sure there's an answer for me or not.

I am linking to a Btrieve database table that has 3 distinct dates and I need to get a monthly count for each one summarizing how many records have a date that falls in each month for a user selected year. It would look something like this:

Lease Exp Move Out Renewal Renewal %
January 5 3 2 40%
February 3 5 1 33%
.
.
.
Totals

The problem is I have no idea how to get all three of these independant dates to summarize off of any defined dates in the database and I have no ability to add tables to the dataset. I know you can't group based on parameter values. Is there any answer for this that doesn't involve a knowledge of SQL programming of is it possible for somebody to provide sample code with an explanation of how to incorporate it into my report to make this work? I'm desperate as I have a client who needs this and I committed to it before realizing this problem existed. Any help would be greatly appreciated.

 

[lbass]

You could create separate conditional formulas or running totals for each month per category, i.e., create 36 running totals and place them in the report footer. Each running total would use a formula in the evaluation section:

month({table.date1}) = 1 //for January

Then you could use a formula for the percentage where you reference the appropriate running totals.

-LB

 

[gbscobel]

Let me give that a shot, that sounds like it might work in my situation. Thanks very much, is it okay to leave the thread open just to make sure I don't have any further questions?

 

[lbass]

Threads are not manually closed by users, and are auto-closed only after a certain number of months.

-LB

 

[gbscobel]

Thank you so much! That's going to work perfectly, I really thought I was sunk. You are the man!!