September 12, 2007 at 1:17 pm
I know a lot of people disagree with this concept of allowing a user to execute a procedure from within a report, but I'd like to know anyway. What is the best way to something like this:
Say I create a report that that acts like a main menu report, whereby a user can go to it and choose from several options listed in a table column. The options may be...
a) a link to another report (no big deal, right?) or
b) a link that executes a procedure
(i.e., the procedure may kick off a DTS program that pulls new data from the ERP system, or exports a query to a file, or sends an email, etc.
(b) is what I'd like input on: what is the best way to execute a procedure from the user clicking on a cell?
smv929
September 14, 2007 at 1:38 am
you might find this useful:
http://www.sqlservercentral.com/columnists/jspink/areporttodisplayandedituserrights.asp
September 14, 2007 at 7:58 am
Jon, thanks. I've seen that article and it's exactly the concept I'm talking about. I was hoping for some more detail and examples. It basically described an overview of the technique. Thanks.
smv929
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply