Reporting in SQL Server 6.5

[Ali Alhussein]

Hi, I have created a couple of queries and places them in a store procedure. so when I want to have a specific report I run the store procedure and view the result. This is not efficient for me , I am looking to have a drop down list of some report in a GUI . I thought of creating a vb from with combobox and them calling the store procedure. is this the right way ... if so, what other consideration would I think of

regards
Ali

[Karl Rottmann]

On 12/18/98 9:47:05 AM, Ali Alhussein wrote:
> Hi, I have created a couple of queries and places them in a store
> procedure. so when I want to have a specific report I run the store
> procedure and view the result. This is not efficient for me , I am looking
> to have a drop down list of some report in a GUI . I thought of creating a
> vb from with combobox and them calling the store procedure. is this the
> right way ... if so, what other consideration would I think of

regards
Ali

Have you tried using The Query Designer of Crystal reports, maybe your answer is there.

Good Luck

[Jeramie Mercker]

On 12/18/98 9:47:05 AM, Ali Alhussein wrote:
> Hi, I have created a couple of queries and places them in a store
> procedure. so when I want to have a specific report I run the store
> procedure and view the result. This is not efficient for me , I am looking
> to have a drop down list of some report in a GUI . I thought of creating a
> vb from with combobox and them calling the store procedure. is this the
> right way ... if so, what other consideration would I think of

The best way I've found to report on data (from any modern data source) is through the use of Seagate Software's Crystal Reports. It's pretty much an industry standard in reporting - and will give reports to you in a much nicer format that that of a raw SQL query.