Creating reports with Tsql

Question

Post reply

Creating reports with Tsql

fosco

Grasshopper

Points: 22
More actions
December 8, 2007 at 9:31 am

#377370

Hi,
Can anyone help me, how can I generate reports on an sql server 2000 standard server using t-sql, without reporting services.

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

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

Ravi Patel-554358 SSC-Addicted Points: 471 More actions · Answer 1

What kind of reports do you need? Please be more specific. What type of data are you trying to extract out?

What kind of flexibility do you need with it?

Jeff Moden SSC Guru Points: 1004177 More actions · Answer 2

sp_MakeWebTask is one way...

Hundreds of other ways using OSQL, OpenRowset, etc to fill spreadsheet templates, make simple text files, etc, etc.

--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)

TimothyAWiseman SSCrazy Eights Points: 8819 More actions · Answer 3

fosco (12/8/2007)
Hi,
Can anyone help me, how can I generate reports on an sql server 2000 standard server using t-sql, without reporting services.

Can you be a little more specific?

In general what I often do is create a temp table with the information I want in the report and then use DTSrun to extract it to a spreadsheet. That involves going out of T-SQL pure, but in most real life situations that is not a problem.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/

fosco Grasshopper Points: 22 More actions · Answer 4

Thanks for the replies, we have an application that actually creates the reports in pdf format, but the data is on sql server 2000 standard backend, when the application users make a request for a report, I would then need to write t-sql query, which the application will use to retrieve this data from the database. Hope this sheds more light!

TimothyAWiseman SSCrazy Eights Points: 8819 More actions · Answer 5

I may be missing something. From what I understand, all you need to do is write the query itself, in which you case you just write the query. If the report creating application needs it in an actual table, you can just use select into to create that table and then delete the temp tables after it is done. If you use a standard naming convention, you could create a job to delete them on a regular basis automatically.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/

Jeff Moden SSC Guru Points: 1004177 More actions · Answer 6

fosco (12/8/2007)
Thanks for the replies, we have an application that actually creates the reports in pdf format, but the data is on sql server 2000 standard backend, when the application users make a request for a report, I would then need to write t-sql query, which the application will use to retrieve this data from the database. Hope this sheds more light!

I agree with Timothy... just write the query and call it from your app.

--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)