DevOps, CI/CD and Automation

Hello Room,

I have come to know that in this forum there is a solution for every problem. I am beating about the bush since past several days and also visiting this forum, but I could not find a solution specific to my problem. My problem is that I want to pass parameters in reports. There are 3 total parameters (excluding system parameters) Let us take here only user parameters.

vcompany
vlocation
vcustomername

these are the 3 parameters belonging to company, location, customername. Now when a user login the company year and location is automatically assigned to that user through get_application_property built in from the forms 10g. it is ok upto here. I made a test report it is running fine showing all these 3 parameters. all the 3 parameters are appearing in a list item type in parameter. I have given a sql query to retrieve list for all the 3 parameters from oracle reports.

Now here goes the real metal problem. When a user run the report he is assigned a particular company and location. that authorisation I can capture in forms for data security. When I pass this parameter to the reports from forms I want only the user applicable companyname and location to be displayed or rather selected in parameter and no other location or company name should be allowed to type. It should be in list type as usual. The third parameter will be selected by the user manually, like for example he will select any customer from the list to see the report of that customer. So it means the user can see report of any customer but only for the company and location he is assigned for. I hope you got it.

How is this possible. I want a secured url also wherein I want hidden url parameters. There is one more problem, my report file is physically placed in the local network in a shared folder, so I need to access this file physically and not through find_report_object command, as I am not attaching this report to forms layout. How to achieve this. I had been struggling and all my work or migration process is stuck to bottom. I cannot move ahead. Please anybody help.

Thank you in advance. If you could post the whole code applicable to my scenario, I would highly appreciate that :) the variables are coname and locname with whom I am passing to the reports parameters. but the values of the parameters remains unchanged even after passing parameter and i can see all the list in the parameter. Please display the code from start to end here. thank you.

PS: Please do not show me any pdf. I am tired of reading pdf's :) Most of the coding is clear to me. coding is not a problem. but I am not finding a code specific to my problem :)