topic title or desccription might not be accurate by I will try to explain my situation.
I am creating a pricetable through a pricedatabase.
I am able to create the table using report option as I need to use X - Y axis.
Now I want to dynamically change the values of the tables based on user input on 2 fields. 1. Pages 2.Type
Like I want a text field "Pages" on the report page. When the visitor type 2 in pages the prices muliply by 2 and the table is shown.
Other is "type of services" which is a dropdown. Once selected the table is changed..
I am unable to implement because I can't add a custom field(text or dropdown) on report page.
I am able to do this manually by using AfterTableINitizaled
$query->replaceField("price", "price*'2");
$query->replaceWhere("price.typeid = 12");
but I want to do this as soon as the type is selected and or the pages are entereed.
Thanks in advance.
Regards