asked 6 days ago
Hi,
I am trying to integrate our SQL data source with Flex monster using free trial. I have created simple project and trying to connect to index created using Admin panel.
Here is the sample code.
There is no clear example. So help to resolve will be appreciated.
Regards,
Gokul
⋅ 6 days ago
Hi,
I have done some progress and managed to build my report for Balance sheet. Now I want to have common filter for branch and Datekey for both sections. Please advise me how to achieve this.
Also how I can hide the filters shown for ACT_Level2, to ACT_Level4
⋅ 5 days ago
Hello, Gokul!
Thank you for your question.
We are glad to hear that you could create the necessary report layout. For implementing a shared report filter area for two tables, we recommend hiding the default filters for both tables by setting the showFilter and showReportFiltersArea grid options to false. Then, you can add a custom filter area with a single filter outside of Flexmonster. This filter area can be implemented in the following ways:
setFilter method to modify the filter configuration: https://jsfiddle.net/flexmonster/vms57Lyu/openFilter API call: https://jsfiddle.net/flexmonster/wz6dh5yb/The filters can be synced between the two tables using the reportchange event. This event will be triggered on every filter applied, allowing one to set a filter on a table when another is filtered. This approach would work independently of which field is used for filtering.
Please let us know if one of the approaches we have provided works for you.
Best regards,
Maksym