We use a software system (VB / .NET) that calls Crystal Reports from within the application to produce a report based on the selected report. When the report is called, CompanyID is automatically passed to the report so that we can run reports specific to that company.
What we are having extreme difficulty doing, is having a parameter selection based on the CompanyID being passed.
For example, there are 5 companies within the DB. Each company has 5 services specific to that company we would like to run reports on. We are getting passed the CompanyID, and we want to only display services in a parameter selection box that go along with that CompanyID.
We tested with cascading parameters, using a dropdown to pick the CompanyID, and we can successfully get it to only display that specific company's services, but this won't work as it allows company A to look at Company B's service reports. It needs to only be specific to the passed CompanyID.