Report Studio or FM Causing the Problem?

[UcfMike]

I've run into this type of problem several times, and I've never found an answer/reason for it. I've been able to come up with various solutions / work arounds, but nothing more.

Here is the problem. I have a column in a report, and I want to total it. I have several Groups in the list. When I total the column, I get a total for the report for every group. If I create a seperate column that reads

total ( [some data item] ) it also returns the report total.

Now I've tried using the for statements, changing the aggreation and roll-up aggregation. The only way I've found to make it work it to set the report query to Auto-Sumarize = NO, unfortunately this screws up the calculations for every other column in my report.

Any thoughts?

Thanks

 

[Thingking]

The problem you are having is do the functionality of ReportNet auto summation function. I am not clear what it is you are trying to do. Do you have any grouping in your report? Two ways to address your problem:
1) Ungroup Data
2) Group Date

Both ways I believe you will have to create separate calculated columns which you can hide if they are not need in the report. This way the calculated column summation only affects the column and not the report. But keep in mind this columns is independent of the other columns and will have to be added manually prior to completing the report.

 

[UcfMike]

We fixed the problem by changing our model in FM. Basically we combined two query subjects that we had kept seperate in other packages. This solved the problem.

Thanks for the advice ThingKing. I will try that just to see the affect.