why is my result getting multiplied by 10????

[catchingup]

i have a CR11 report i am writing, pulling info fro a SQL table.
i have the following setup as far as groups and rows:

GroupHeader1a (grouped by Project #) - headings
GroupHeader1b - more headings and misc info
Detail level - BUDGET AMOUNTS
GroupFooter1 - blank
Report Footer - Sum of Budget Amounts

For some reason the Sum is multiplying by 10 (should result in $1,260,415 and I'm getting $12,604,150)

I unhid the detail level and can see that it is going through the detail listings 10 times which is why the Sum is off, but have no idea why it would be going through the table listings 10 times?

The only thing I have in the selection formula is a parameter which requires the user to enter a project number (set as --- {?Job Number} = {Projects.Number} )

Any ideas?

 

[synapsevampire]

I think that you're confusing what is termed row inflation with Crystal doing something inappropriately.

The repeated rows in the Details are probably the result of joining to a table that has numerous values per entity joined.

btw, you can't see that Crystal is going through the detail listing 10 times, Crystal doesn't fabricate data (which is unfortunate for certain cases), what you are seeing is that the database is returning 10 rows at the details level for that group.

-k

 

[lbass]

Try using a running total instead where you use sum of {table.budget}, evaluate on change of group: Project #, reset never.

Place the running total in the report footer.

-LB

 

[catchingup]

Thanks for the helpful tips.....i finally figured out that I didn't have a filter in place to limit the contracts it was pulling budget amounts from, so it was pulling the amounts for everything - 10 times (b/c there were 10 contracts).

Thanks again!
:-D