| Author |
Topic |
|
JonnyToppa
Starting Member
8 Posts |
 Posted - 2011-12-16 : 04:28:49
|
| HelloI have a single instance of SQL 2008 Express installed and wish to allow user generated views with simple filtering, via a web site/ browser. Any suggestions as to the best method or product to achieve this?Thanks for your help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-16 : 06:30:13
|
| sounds like what you need are webpages with filters which enable you to show db data after applying the filter------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
JonnyToppa
Starting Member
8 Posts |
Posted - 2011-12-16 : 23:13:38
|
| OK visakh16, thanks for your reply, I probably should have been more specific.I need to allow clients to access SQL 2008 express remotely and select which tables they wish to view and save, with basic filtering on selected fields,read only, via web site, using a simple UI such as drop down menus or such ( obviously not SSMS). I have no programming experience ( dummies c# books only) and was wondering if SSRS or Sharepoint could easily provide this functionality or a custom website is the go.Any advice appreciated. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-17 : 02:02:15
|
| why should you open up tables themselves to end users?didnt understand the purpose of all thisif the intention is to allow users to see and save data to their machines, then you can very well show data on webpages and give a export option. Giving them direct access to tables requires lot of additional effort like what all access you need give them etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
JonnyToppa
Starting Member
8 Posts |
Posted - 2011-12-17 : 06:54:02
|
| HelloIm wanting the client to view table data only, as a view, with client selecting fields and applying basic filtering. With respect to my question about SSRS and Sharepoint, so your recommendation is that these products cannot deliver this functionality and the best option would be a custom website? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-17 : 07:16:41
|
quote:
Originally posted by JonnyToppa
HelloIm wanting the client to view table data only, as a view, with client selecting fields and applying basic filtering. With respect to my question about SSRS and Sharepoint, so your recommendation is that these products cannot deliver this functionality and the best option would be a custom website?
ok..if you're planning to use SSRS then fine. You can write sql procedures to return whatever data you want to make available to users and add parameters to procedure to make it interactive. The users will be able to select values for parameters from reports and then on rendering they'll be able to see required data filter on the basis of their selections. They will even have ability to export data to other formats like Excel,PDF,CSV,XML etc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
JonnyToppa
Starting Member
8 Posts |
Posted - 2011-12-17 : 07:43:16
|
| That sounds great, thanks for your help. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-17 : 07:56:43
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
User defined Views