Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pacer3231
Starting Member
4 Posts |
 Posted - 2008-07-09 : 10:51:05
|
| Hi, Is there a way to select 1 or more "Accounts" from the drop down box in the preview of the report designer. I would like to be able to select 1 or more Accounts that would be used to generate the report. Is there a way to set the parameters up so that i can just click a check box or highlight them, and then perform the report on them?Thanks. |
|
|
pacer3231
Starting Member
4 Posts |
Posted - 2008-07-09 : 10:59:27
|
| I believe this would be done using the multivalue parameters, but I dont necessarilly want to use all of the values only some of the ones. This is where I would like the checkbox/highlight to come in so I dont have to use all of them. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-09 : 12:56:03
|
quote:
Originally posted by pacer3231
I believe this would be done using the multivalue parameters, but I dont necessarilly want to use all of the values only some of the ones. This is where I would like the checkbox/highlight to come in so I dont have to use all of them.
You can select only values you desire from the entire list in multivalue params. Didnt understand why you dont want to use it?? |
|
|
|
pacer3231
Starting Member
4 Posts |
Posted - 2008-07-09 : 15:29:43
|
| Its not that I dont want to. Its that when I select it no data is displayed in the drop down. I tried to manually type it in but if I put in more than 1 value the report either crashes or doesnt display anything. There is no data for me to select from in the drop down. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-10 : 01:43:17
|
quote:
Originally posted by pacer3231
Its not that I dont want to. Its that when I select it no data is displayed in the drop down. I tried to manually type it in but if I put in more than 1 value the report either crashes or doesnt display anything. There is no data for me to select from in the drop down.
how are you trying to populate the dropdown. Are you hardcoding values in parameter tab or are you mapping it to a created dataset? |
|
|
|
pacer3231
Starting Member
4 Posts |
Posted - 2008-07-10 : 08:45:32
|
| I am mapping it to the same dataset that I used to generate the report. One of the fields is account_name and I would like to select from that column. I am connecting to the only dataset that i have created. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-10 : 14:48:22
|
quote:
Originally posted by pacer3231
I am mapping it to the same dataset that I used to generate the report. One of the fields is account_name and I would like to select from that column. I am connecting to the only dataset that i have created.
Didnt understand how you're using same dataset for parameter and dat. wont it contain more more data then you require? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-12 : 11:46:57
|
| I am mapping it to the same dataset that I used to generate the report.There is no data for me to select from in the drop down.A Parameter is used to decrease the rows/specify one row in the dataset. The Parameter is used in the WHERE-Clause of the Statement that has to fill your dataset. So when the Parameter should be populated with values like account_name there is no way to get these values of the report-dataset because the report-dataset is waiting for the Parameter that the user has chosen. That is like a never ending story...You have to create a second dataset which only retrieve the needed values for your Parameter-Dropdown.GreetingsWebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
|
|
|
|
|
|
Select from drop down box