[ic] Generating a custom report
Andrei Gologan
interchange-users@icdevgroup.org
Thu Jan 16 07:45:00 2003
> At 02:07 PM 01/15/2003 +0100, you wrote:
> >Hi,
> >I try to generate a custom report. The code I use is:
> >
> ><TABLE>
> >[set first_done][/set]
> >[search-region more=1 search="
> > ra=yes
> > st=db
> > fi=orderline
> > ml=50
> > sp=admin/reports/test
> > tf=sku
> > to=x
> > "]
> >[search-list]
> >
> >[/search-list]
> ><TR><TD COLSPAN=10><HR></TD></TR>[more-list]
> ><TR>
> > <TD>More</TD>
> > <TD COLSPAN=9>[more]</TD>
> > </TR>
> >[/more-list]
> >
> >[/search-region]
> ></TABLE>
> >
> >but it allwys returns empty, no data is visible ..... it seems that the
data
> >is there , i can see it on the number of pages generated ...but i cant
see
> >it .... if i choose summary only = no it displays a page filled with
> >[item-data orderline]
> >
> >I am using the tool at the admininterface to generate it ...what am I
doing
> >wrong ?
> >I want to see statistics on the items that were sold ...
> >Same thing happens in the live demo 1 of interchange as well ....
> >
> >Thank you!
> >Andrei
>
> You might want to include some [item-*] tags to actually display the data
> from the search, i.e.:
>
> [item-data orderline sku]
> [item-data orderline quantity]
> [item-data orderline status]
>
> ... slightly faster would be to add return_fields spec to your search
terms:
>
> rf=sku,quantity,status
>
>
> Then you can do:
>
> [item-code]
> [item-param quantity]
> [item-param status]
>
ok, now i get data, this is great, but how can I group it ? so i want to see
totals for an username for one item, now it just displays the :
username - item - quantity ....if a customer orderd more than once the same
item, i get to lines ...and i only want to have one.
thank you !!
Andrei