hi .. i had try different ways to get a right report

this is how my portal look .. what i want is a report that shows me how much i sell from each reference ... from all customer ... i have try subsumary report but when i run it... it doesnt show anything ... what i am doing wrong??

thank for your help

Break each timeslot into it's own related record! When summarizing or seaching do it from the most atomic table. When searching use the GTRR(FS) backward thru the relations (in plural)

--sd

thanks for your time...

im very new in this ... can you explain me more about how to do it? i dont understand very well ...

when i search .. example for the reference "777" fm shows me 3 custumer than have that reference ... but when i put the search in a report it shows me the 3 customer and the first product they order .. it doesnt focus in the reference "777" ..

Hopefully will I find some time tomorrow to make you a template showing my suggestion.

--sd

thanks for your help...

here a attached a sample application ...

what i want is to find specific product and know how much i sell in that product ... from all the orders i took ... and then print...

i hope you can help me

thank you

prorders.zip

Ok this is a little different than I thought at first sight - the upload of JMO's template explained a lot. You must you explain why you wish to make cross-tab summaries in a portalized view?

Next issue is that you join table records seems to need a field for size as well.

Finally should you investigate this technique:

http://edoshin.skeletonkey.com/2006/12/crosstab_report.html#more

As you see would I strongly suggest you somehow gets the portalized idea of yours out of the head. Not that it isn't feasible but the extra measures to get it into a portal are not worth it in my humble opinion.

--sd