[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