I need to generate 3 reports for my case log. I have tried to create the script but it's not doing what I need/ want it to do.

I need my report to sort: Assigned Cases, Investigator Assigned and Month - in descending order.

Next report should sort: Closed Cases, Investigator Assigned and Month - in descending order

Finally the last report I need it so show me: Open Cases, Investigators and Month.

I need to generate 3 reports for my case log. I have tried to create the script but it's not doing what I need/ want it to do.

I need my report to sort: Assigned Cases, Investigator Assigned and Month - in descending order.

Next report should sort: Closed Cases, Investigator Assigned and Month - in descending order

Finally the last report I need it so show me: Open Cases, Investigators and Month.

Two things here:

1. The sorts must be in the order that you want the break fields. This would indicate three separate sorts here.

2. The subsummary parts in the report should also be in the correct order.

If you want top and bottom section, ie headers for each subsummary and corresponding data below, the body should be nested between the duplicate subsummary parts.

Eg:

Header

Assigned Cases - heading

Investigator Assigned - heading

Month -, heading

Body - records

Month - Month data

Investigator Assigned - Investigator assigned data

Assigned Cases - Case Data

Grand Summary - Overall data

Footer

Hopefully I am not making this more complicated for you than it really is.

HTH

Dave McQueen

I don't suppose I could let you take a look at my database?

I built the reports but they are not coming out like I want them to.

I don't suppose I could let you take a look at my database?

Sure.

Send it through to [email protected] or post it to a site and give me a URL. It sounds like you are 95% there and are just missing some little thing.

Dave McQueen