I have a report where I group data by product type.
For example,
Model No: 123699
Location: USA
Order from: Portugal
Model No: 563336
Location: USA
Order from: China
Model No: 8696633
Location: France
Order from: Italy
I need to set up 2 parameters. (1) Select countries (2) model numbers
(1) I set up one parameter where the user excludes out the countries they don't because generally they need most of them.
(2) My problem is setting up parameter 2. The user usually has a list of specific model numbers that they want to see on the report. The list is generally more than 100 model numbers. Is there a way for a user to upload a text file containing a list of 100 model numbers into a parameter.
Originally I thought I could have them copy and paste the model numbers into the select expert but they can't use it since I placed a read only on the report.
Any ideas? I'm trying to prevent the user from entering each model number one at a time.
Best Regards again.
For example,
Model No: 123699
Location: USA
Order from: Portugal
Model No: 563336
Location: USA
Order from: China
Model No: 8696633
Location: France
Order from: Italy
I need to set up 2 parameters. (1) Select countries (2) model numbers
(1) I set up one parameter where the user excludes out the countries they don't because generally they need most of them.
(2) My problem is setting up parameter 2. The user usually has a list of specific model numbers that they want to see on the report. The list is generally more than 100 model numbers. Is there a way for a user to upload a text file containing a list of 100 model numbers into a parameter.
Originally I thought I could have them copy and paste the model numbers into the select expert but they can't use it since I placed a read only on the report.
Any ideas? I'm trying to prevent the user from entering each model number one at a time.
Best Regards again.