[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
===============================================================