Sum and Count on report

temp_oct · December 11, 2003, 6:05pm

Hi, I’m wondering if we can do conditional sum or count on a report? For instance, I’ve created a report from business relation table, displaying new customer list based on a selectable time period. We have a column called ‘Sales source’ which indicate how we got those customers. If I want to count how many customers each source generated (based on the selected time range), how can I do that? I’m not using temp table in my report.[?] I am also need to sum the $ amount of each source [:0] . Any idea? [:D]

danang_ismu · December 12, 2003, 3:36am

hi, you can modify report in report’s fetch metode … if you can send me the XPO and some description about the problem maybe i can help regards, Danang Ismu .S.

temp_oct · December 12, 2003, 10:03am

That would be great! How can I send the XPO file to you?

danang_ismu · December 15, 2003, 2:18am

you can send me mail … danang_ismu@yahoo.com regards, Danang Ismu .S.

temp_oct · December 15, 2003, 6:24pm

I’ve sent the XPO

filiz · December 29, 2003, 11:19am

can you explain solution about this problem ?

danang_ismu · December 30, 2003, 7:11am

hi filiz, this is my solution but this not exactly like the requirements … : - i’ve made getNum method ← this one is to get the num of the vendor for each city - i’ve made getTotalLineAmount ← this one is to get total for each line amount … i think i’m bad in explaining something … but i’ve u need the xpo file just tell me your mail address and i’ll send it to you … regards, Danang Ismu .S.