Grouping summary

[balooka]

Hi

 

I'm currently working on a database where photo's are ordered on a website and need to be managed (via .csv imports) in FM12. This is all working pretty well so far but my problem is with the reporting/summary.

 

The setup is that a FMdb (iPad/FMgo) generates the data that is imported into the site CMS where customers can order specific prints. That works fine. The modified data is exported (CSV) from the CMS and imported into another FMdb, that is related to the initial FMdb (where the data is generated). This second FMdb is the one that will generate invoices and ordertickets and so on.

 

The structure is:

 

VENUE (keyA) -> GROUP (keyA) | (keyB) -> ARTIST (keyB) | (keyC) -> PHOTO (keyC)

 

When I generate an orderticket I use summary sort like: 

 

-VENUE

-- GROUP

--- ARTIST--> PHOTOS

 

 

Which is perfect! But... If an artist has multiple images and also orders multiple it will list all ordered items like above. So Artist1 order 5 images and I'll and up with 5 lines (--- ARTIST--> PHOTOS). That is fine for the orderticket but not for the invoice (unspecified for a reason).

 

Is there a way to only show one instance of Artist1, where the costs are grouped. So even if Artist1 has ordered 10 photo's of 1 dollar each, it will not list 10 lines, but just one with a value of 10 dollar? If I make a selfjoin on the PHOTO-table I can see in the portal that the amounts are added nicely to one sub-summary, but in the report I have no clue on how to omit all the instances but one with the summarized (sp?) price...

 

I hope this made sense, my English isn't all that

 

Thanks a lot!

[balooka]

Meh - scrap the above post... I've been staring at these files way too long. Did a new report this morning and works without a hitch... seems I overlooked a sub-summary completely and focussed on the wrong one for an hour.

 

Aloha!