| Author |
Topic |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-05-25 : 09:58:29
|
| I noticed that there's an option to allow the user to do update from the data layout when you build your query. I wonder if it's possible to create like some sort of a button or msg "UPDATE" and when the user clicks it, will run the update. Is it possible to do it this way? I'm just not sure how it will know when to execute the query. Like how would it call the query when the user clicks on the value "UPDATE" from the textbox.Any ideas? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-25 : 12:21:27
|
| Reports are for displaying of data only. If you want to update data, build that into your application.Tara |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-05-25 : 13:48:09
|
| That's what I was afraid of and assumed. In FoxPro, we can have reports that has executable buttons where we can do Updates and stuff. I guess that's the limitation with RS. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-25 : 13:50:26
|
| It's not a limitation. Reports are for displaying data only. FoxPro is a programming language, so that's why you can do it there.Tara |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-05-25 : 13:55:30
|
| Righ, but would be nice if that can be incorporated in there. |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-05-25 : 13:57:43
|
| One thing I did notice is that in the Data Display for queries or where you build queries, it allows having Updates. I'm just not clear why it allows update queries from there. Is it that it can update once a user clicks on the report? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-25 : 14:01:17
|
| The reason why it allows updates is that it is just like Query Analyzer. It allows you to build and run queries. I'm pretty sure the data tab was grabbed from Enterprise Manager's query tool. And I disagree with it being nice to be included in Reporting Services. That's is not what reports are for. That is the job of the application. If you want your reports to update data, then it shouldn't be a report in the first place.Tara |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-05-25 : 14:09:29
|
| True and I agreed too, but I'm like one of those who likes everything in one package and in one place. Since we are using RS Manager for security on reports, it would incorporate nicely with our reports environment.But I do agreed that a report application is for displaying reports only. All I'm saying is that if it can allow more extensive programming then just with the custom code feature that we have available to us, it make things more flexible. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-25 : 14:14:33
|
| Well it does allow extensive programming to be incorporated into your reports. Just wrap the code into a .NET assembly and load that into your report. We are calling some very complex .NET assemblies to do some calculations that aren't possible in RS in about 5 of our reports.Tara |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-05-25 : 14:33:12
|
| Never worked with .Net assembly before, might be something to look at. |
|
|
|
|
Update records with RS?