January 28, 2025 at 5:05 pm
Hello,
I have an SSRS report, version 2019, that has two parameters, which will call for three different datasets.
Parameter: Country -> cascading from the first parameter. Values are generated from the following datasets.
Sample values for DS_Europe -> EUROPE, Germany; EUROPE, France... etc.
Situations:
1. When selecting a drop-down from the parameter, (Continent), the values will be pointed to a specific dataset. For example, if the parameter drop down is EUROPE, the value shown in the country box or field will be European countries from the DS_Europe dataset.
2. Unfortunately, there are no DB links between the datasets to combine them into a single one. They are from different sources. We can gather the name of the countries.
3. I am not sure whether I can use the lookup function, since there are no common fields or values on the datasets.
4. I am not sure whether I can create a query to combine all three datasets since I can pick only one datasource on the dataset.
5. On the Report Parameter Properties -> Available Values -> Specific Values; (See attchment)
Try to add the Value in the "Label" such as ASIA. However, I am not able to write the Value Expression. When selecting the datasets items that I wanted, i.e. DS_Europe, the values available are all aggregated, such as First or Sum. Not sure of how to put the values in there.
I do wonder whether it can be done in SSRS 2019. Need some suggestions. Thanks.
January 29, 2025 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply