Linking Problem

[azwaan]

i'm creating a report which summarises content in a employee database.the summarised content is in a columnar format , with groups of columns summarising attendence, turnover and recruitment for the specified date range.

the report is grouped by dept and then by section.
i have hidden the details sections , showing only the group footers so that i can generate the summaries.

the problem is in generating the budget summaries from the budget table.most of the detail line fields are from the attendance table , which has a record each for an employee for a specific date.

employees are budgeted for each section and then within that for each employee category such as executive, staff etc.

the budget table has the following structure
BudgetYR,Jan,feb,....Dec,Section,Category

the problem is that when i include a formula or field which has anything to do with the budget file..all the data in the report goes haywire (extremely large figures).i suspect this has to do with the structure of the budget table.cos for a particular year the budget file contains approximately 300 records.

because all the fields in the report are in the same line , this poses a problem even if i put a subreport for the budget figures.there are more than 60 sections so..there is no way i can use shared varibles.

how do i get about doing this?
thanks in advance

 

[dgillz]

You need to use running total fields rather than summaries to get your totals. This is due to the many-to-one relationship in the tables in question.

Try to insert a running total field, evaluate on change of group, reset on change of group. You will need to do 2 more running totals to get your 2nd group total and your grand total.

Let me know if you have any questions. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[azwaan]

well..i tried putting running totals , but still there's a change in the other summary figures..the grand totals increase by about 20%.

i have the running totals to evaluate on a formula ..ie..
{Budjet.DepartmentCode}={Department.DepartmentCode}
and reset on change of the group.

the budget table has been linked to the employee table using deptcode and categorycode.

 

[dgillz]

If I understand the problem, you should not use ANY summary operations in this type of report. They should all be replaced with running totals. I believe that your evaluate time should be on change of group and not on a formula.

Did any of the running totals you tried give you the expected results? Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com