April 16, 2015 at 6:43 am
hi everyone
i'm new in ssrs i have a problem
i have a 2 dataset for exemple
dataset1:select * from table A
dataset2:select * from table B
I want to make a dropdownlist with specify value
1-show table A (who list all attribut of my dataset1)
2-show table B (who list all attribut of my dataset2)
how can i do this an thank you very much 🙂
April 21, 2015 at 2:48 pm
If I am understanding your question properly, you might want to look here:
https://technet.microsoft.com/en-us/library/aa337169(v=sql.100).aspx]
The link discusses how to setup dependent parameters in SSRS.
A.J.
DBA with an attitude
April 23, 2015 at 1:40 am
Adam Wilbur (4/21/2015)
If I am understanding your question properly, you might want to look here:https://technet.microsoft.com/en-us/library/aa337169(v=sql.100).aspx]
The link discusses how to setup dependent parameters in SSRS.
https://technet.microsoft.com/en-us/library/aa337169(v=sql.100).aspx WORKING URL
April 27, 2015 at 10:47 pm
In your scenario, you need two dropdown-list to display the data from two datasets, right?
In current version of SSRS, dropdown-list is on available on report parameter pane. You cannot use it in Report body. To display the data from dataset, you can use table, martrix, list, chart and guage. Please refer to the link below to see the details.
Anyway, if you want to display it on dropdown list, you can add two parameters in your report. Please refer to the link below.
https://technet.microsoft.com/en-us/library/aa337396(v=sql.105).aspx
April 27, 2015 at 10:48 pm
In your scenario, you need two dropdown-list to display the data from two datasets, right?
In current version of SSRS, dropdown-list is on available on report parameter pane. You cannot use it in Report body. To display the data from dataset, you can use table, martrix, list, chart and guage. Please refer to the link below to see the details.
https://technet.microsoft.com/en-us/library/aa337396(v=sql.105).aspx
Anyway, if you want to display it on dropdown list, you can add two parameters in your report. Please refer to the link below.
https://technet.microsoft.com/en-us/library/aa337396(v=sql.105).aspx
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply