Simple and fast front end for user to execute a stored procedure after keying a variable

Question

Simple and fast front end for user to execute a stored procedure after keying a variable

Robin_D

Mr or Mrs. 500

Points: 502
More actions
November 25, 2009 at 4:19 am

#98346

Hi.
Let me start by saying I am not an application programmer. I've also searched long an hard for this before posting so please be gentle on me if something is blindingly obvious.
What I need is a quick and efficient way of an end user entering a single parameter (4 char code), before executing an existing stored procedure and returning the results to screen. Something similar to the the execution box that you get if you right click and execute the stored procedure within server management studio would do fine although its over complex. As this is a busy customer service role, speed is of the essence but this is an irregular query in an otherwise busy department. Loading Server Management Studio on this machine is not realistically an option.
I've looked at doing it from a batch file but there appears to be no way of prompting and capturing the variable, plus no easy method of displaying the result. (Current balance and the list of transactions that it relates to). It would appear from my research that VB is perhaps the way to go but having spent about an hour with Visual Studio, I am able to create the screen but for the life of me, cannot find out how to show the result set or put in the the call to a SQL server. As stated above, I am not an application programmers so its all 'Greek' to me. All indications are that I should use DataGridView but this will only let me use a data source on the local machine whereas its on a networked server! I'm sure some spotty 16 year -old would have it sussed in five minutes but I do not have hours to earn a new tool/language!
I don't mind spending a few quid if there is something out there that readily does the job, but I can't find anything through Google. (Probably using the wrong search terms:unsure:). Any advice gratefully received.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Take a look at SQL Reporting Services. It comes free with SQL Server 2000 and later. Drag and Drop report designer and the end user goes to a web page, enters the parameter, clicks a button, and there's your data.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Robin_D Mr or Mrs. 500 Points: 502 More actions · Answer 2

Robin_D

Mr or Mrs. 500

Points: 502

November 25, 2009 at 8:51 am

#1084115

Sounds good to me.

Thanks ...... Robin

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

Okay, heres a search of this site for reporting services articles. There are a bunch.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jeff Moden SSC Guru Points: 1004600 More actions Follow · Answer 4

You could always do this in a spreadsheet with a pushbutton macro to read a cell (or an input message) and return the results to the spreadsheet.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Robin_D Mr or Mrs. 500 Points: 502 More actions · Answer 5

Thanks guys.

Using Excel is not ideal as the load time for the application is so long. Having a browser already open is a better option.

I've got a long way with this and now have my report ready with the exception of one thing, a total of the final column! All my searches seem to indicate that I should be able to right click the field and get an add totals field but it does not appear.

I'm using SQL 2005 and building the report in Business Server Intelligence Studio.

I tried adding another text box at the bottom of the column, but it does not move down as the number of rows varies. Any idea's on what I'm missing please? (Grey cells probably!). I've looked at the code behind the report, but can't make much head or tail of it let alone to see how, what or where I'd need to add something to get iit to do the simplest of things being to add up the page!

Many thanks ....... Robin

Robin_D Mr or Mrs. 500 Points: 502 More actions · Answer 6

I've found it. Table footer was what I required! Simple when you know how! :blush:

Thanks again guys.

Robin

Simple and fast front end for user to execute a stored procedure after keying a variable

Cookies on SQLServerCentral