Grouping by a Custom FIeld

rbuser

I have a report acessing data via Dade. My Data looks like this

Customer Date Amount
--------------------------------------
Cust1 1/1/2005 150
Cust1 10/1/2005 100
Cust1 15/1/2005 300
Cust1 1/2/2005 400
Cust2 1/1/2005 400

I am sorting this query by customer then by date. I want a report
grouped by costumer then by MONTH. So i created an ppVariable that
calculates the month from each data and I made a group by this variable.
The problem is that this group doesnt work. It never breaks when my
variable changes, I dont know if i have to change the calculation
behavior, please anyone can give me a tip? Look at my desired report

Customer: Cust1

Month Amount
----------------------
01/2005 550
02/2005 400
-----------------------

Customer: Cust2

Month Amount
----------------------
01/2005 400
----------------------

This report is based on the data on this email's top.

Thanks by now!

nardmoseley

Due to timing of when group break value gets checks and when Variable.OnCalc
fires, using the OnCalc event will not work.

Try using OnGetText to set the value of the Text parameter passed to the
event.



--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com

rbuser

Thanks a lot, but I solved it settings te OnGetBreakValue event of the
group and everything went fine too..

Best Regards


Nard Moseley (Digital Metaphors) escreveu:

nardmoseley

Yes, that is the other way to do it

--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com

rbuser

Could you not select the MONTH value from the date in your query?
Just a suggestion, i don't know which database you use.

Eric