Filter reports on product

Summary

We want to filter some answers-reports on productcategory

Content

We have a couple of pages where we display the grid-widget. Users can set the product form a list. This is saved into a custom field and referenced within certain widgets. We also use the p-url param if necessary.

<rn:container report_id="100066">
<rn:widget path="reports/Grid" add_params_to_url="p" static_filter="p=#rn:php:$prodfilter#" />
<rn:container report_id="100066">

($prodfilter is declared in the template-file and displays the curently active product id. In case product 8 is active and I check the widget attributes using alt+i I see the static_filter as p=8)