L
liora
I built a report base on query that contain all order
details(customer ID, customer name)
I want to ri=un this report by grouping the customer id
I add it to the group - add header and footer for this
group- at the header I put the customer name + Id at the
botom I want to enter sub report with summerize all sum of
amount in each currency for each customer.
I define a new query base on the report query - and make
it a sum query - "customer id" and "acc" as group by and
the "amount" as sum.
I define a sub report at the footer of customer id which
base on the sum query and the master field and child filed
is the "customer Id"
when I run the report nothing is written at the footer
but if I run the subreport a lone is seem ok.
Can any body explain me what the problem. I succeed doing
this before.
Liora
details(customer ID, customer name)
I want to ri=un this report by grouping the customer id
I add it to the group - add header and footer for this
group- at the header I put the customer name + Id at the
botom I want to enter sub report with summerize all sum of
amount in each currency for each customer.
I define a new query base on the report query - and make
it a sum query - "customer id" and "acc" as group by and
the "amount" as sum.
I define a sub report at the footer of customer id which
base on the sum query and the master field and child filed
is the "customer Id"
when I run the report nothing is written at the footer
but if I run the subreport a lone is seem ok.
Can any body explain me what the problem. I succeed doing
this before.
Liora