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 |
|
SoCalCybergal
Starting Member
1 Post |
 Posted - 2008-07-30 : 13:49:25
|
| Hi - I am very very new to this so forgive me if its a ridiculous question...I have a report setup for a user that has an account number parameter. Basically I want to allow them to specify a list of account #'s (from 50-250 accounts), however the account #'s change all the time.so my question is: how can I allow an end user to change the list of accounts (so they dont have to run the report one by one)Can i link it to a table in an Access database that is on the network? Or import a csv file? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-30 : 13:53:50
|
| You can allow users to either enter the values as comma seperated list in the parameter box provided. But in that case they need to manual enter them all.A much easier alternative is to provide a multivalue dropdown to report with all the account nos which allows users to select several account numbers at one go from dropdown. But for this you need to create a dataset to feed the dropdown with account no values. And you will writing code at backend to retrive this account no from table to dataset.If the data is in access table you may import it to sql table using export/import wizard or OPENDATASOURCE and then use the sql table in query for dataset population. |
 |
|
|
|
|
|
Import parameters