While we are discussing reports.....

[Guest Tbrown]

Has anyone seen a report that could possibly list all plans and their total value as of a certain date? I've been bouncing this idea around in my head for a while, and I'm not sure that it is doable, at least reasonably. If you did it through Crystal, you could generate it in Crystal, but you would still have to have the data for all plans in the temporary tables and that wouldn't be practical when you are talking about alot of plans.

Anyone have any thoughts on this?

Tim

[nancy]

I actually asked Corbel about this and was told that it can't be done at this time. It would be very helpful in analyzing plans and completing RFPS and questionnaires.

[Tom Poje]

Such a report almost actually exists, if but one small modification could be made.

Consider the 70 1/2 report, which can be run globally - all plans.

It will list company name, the names of all ees 70 1/2 and their ending account balances

and then a totals line.

so, suppose you supress the footer that contains the list of ees.

you would be left with company and end bal totals - unfortunately, just for those age 70 1/2. it pulls a field

MINDISTRBALAMT - which is apparently the end bal for only those 70 1/2.

so, all they would have to do is modify the 70 1/2 feature to pull all ees instead of just those 70 1/2, and use ENDBAL (or whatever field)

wishful thinking?

[Guest Corey Matis]

In our company we use a combination of Crystal Reports and Excel to create this information for all plans. I use a combination of two crystal reports, one that queries all plans for the date range needed, and one that produces the needed accounting information. Excel is used to read all the plan information produced and generate the final report data using visual basic. The process is outlined below.

1. Use the first report to create a date range plan list for batch reporting. ( This report contains the PlanID, PlanName, & ErID.)

2. Create a parameter file in Batch Reporting using the list created above. (This can run unattended by creating a DOS batch program to run it.)

3. Use the second crystal report (like a summary ofd accounts) in batch to produce the data.

4. Print the batch information to an Excel File and designate a file location. (All plans export have a _1.xls extension.)

5. Use a VBA macro in Excel to read all plans in the directory and store the data needed in a spreadsheet.

We are currently using this process to export all asset, participants, and fund information to our management and fund trading partners.

By the way it takes about fifteen minutes to run 425 plans through this process.

[Guest John Taylor]

At version 8.2, there is a new Query report that lists balances for all plans as of a given date, and it runs pretty quickly. I ran it on a small database with 57 plans in 10 seconds.