I am working on a report that needs to allow the parameter selection of Services only for a specific Company.  In this test instance, there are 5 Companies in the Company Table, and each Company has 5 services each.

CompanyID is being passed via runtime to the application, so as a parameter, we are already getting CompanyID.

When the report is being run through runtime, I need the report to only list services associated with the CompanyID that is being passed at runtime.


Sample Setting.

Company Table (5 records)
-------------
CompanyID
Company_Name

Services Table (25 records)
--------
ServiceID
CompanyID
Service_Name


So far we have only been able to get this to work by setting the CompanyID to a dropdown, and creating a cascading parameter that then lists the services for that company, but this is a major security flaw as it will allow Company A to select Company B's services, and then run the report on their data.

The report is being called via runtime through a .NET and VB application, and its passing CompanyID to the report.  

I will offer a consulting fee through PayPal to anyone who can help us successfully get this to work!  

The app itself is a closed source program we are licensing, so I am not able to do so.  The user is presented with a report library, a long list of reports they can run.  They select the report, and click Run.  Doing that passes their CompanyID parameter along with it.

Yes the company ID is being set as a parameter.  I think my only option here is to list all the companies, then cascade and list all their services, and when run, if an alternate company and services are selected, it will bring up no results.  I was really hoping to eliminate listing all the companies and their services, but it looks like that may be my only option.