So at Verifacto we use a web app to show case our current reports. We have already have a working section that is the standard reports section where we show various reports. Here each report corresponds to a mydbrportal report which we have created earlier manually . so we are linking it by adding it in a php file and mentioning its procedure name
now are plan is to have an option to create custom reports in frontend. That is end users can create new reports with columns that they can pick from a dropdown belonging to different tables in backend.
Now question is if end user creates a new custom report with n columns , how do we dynamically generate this report in mydbr portal and can we link it by adding it in the same php file as earlier using report's procedure name.
So if 5 custom reports are created one by one by end user in frontend I want to dynamically generate corresponding 5 matching reports on mydbrportal.
would appreciate your response on this topic?