nigthmare with finding data in portal

[mmonsalveg]

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

[Søren Dyhr]

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

[mmonsalveg]

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" ..

[Søren Dyhr]

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

--sd

[mmonsalveg]

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

[Søren Dyhr]

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