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]
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.
That would be great! How can I send the XPO file to you?
you can send me mail … danang_ismu@yahoo.com regards, Danang Ismu .S.
I’ve sent the XPO
can you explain solution about this problem ?
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.