Group by clause in a query subject

[philelmousse]

Hi,

I have a query subject who returns that fields :

name toto toto

Category general general

Month 1 1

Amount 1000 2500

I would like to make a group by to have the sum of the amount for each month. But i dont know where create a group by clause in framework mananger

[MFGF]

Hi,

Provided you have modelled your data correctly in FM, this grouping should happen automatically when retrieving data in a report.

How are you generating these results - using the Test facility in FM, or from within a report built in a studio?

What usages are defined on the four query items in FM?

What determinants are defined on the query subject in FM?

Regards,

MF.

[philelmousse]

Hi, I have an issue in report studio with a chart who returns nothing so i presume this is an issue in framework manager.

My model is simple, I have a "Database layer" with a stored procedure wich returns me the fields for the reports. I also have a table and I created a join between that 2 queries subject.

I have also a "logical layer" to make the calculation for additionnal columns. I really dont understand why my chart is empty