I have problems with reports based on a "Transactions" table.  For instance, the reports and graphs don´t show all values in the field "State" and the aggregation of a column "Amount" is not given the same results compared with the same operation made directly over the table view.

The problem arouse after I added a column called "budget" to the table, which is the ID to link to a new table where we have another field called "budget amount" (money type).  After that I developed a new report based on "Transactions" Table but I needed the "budget amount" field to appear on that report also, so I added it on the report column seccion.  After that all my reports based on the "transactions" table the results are completely random.

Knowing that the Reports Module generates the reports using an automatic generated view,  I have the hypothesis that   such view is broken after I decided to include a new field to the report; Any ideas?

Please help us on this because this is a sensitive application for us!