What Version You are on? have You explored OOTB report console?
On Press of A button you want to generate a report on Screen or in some File?
Or Just to see the requests in window based on supplied Qualification?-Use SPLIT WINDOW
I am using 7.6.04. I have a backend form and a control panel form which are created as per the requirement. On the control panel, I need to provide a button for the generation of the report, the report should contain the data from the backend form, and the report should get generated in a file.