[ic] Generating a custom report

Ed LaFrance interchange-users@icdevgroup.org
Wed Jan 15 12:08: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]

- Ed L.


===============================================================
New Media E.M.S.              Technology Solutions for Business
463 Main St., Suite D         eCommerce | Consulting | Hosting
Placerville, CA  95667        edl@newmediaems.com
(530) 622-9421                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (530) 622-9426 Fax
===============================================================