Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Reports

Author  Topic 

JacobPressures
Posting Yak Master

112 Posts

Posted - 2005-05-26 : 09:39:24
Is there a way to create reports or automate the creation of reports to some extent?

I would like to query the DB and pull all the retrieved info out and place it on an Excel spread sheet if possible without having the tweak the information. If I run ever query (one by one) and then placed it on a spreadsheet or word document, it could take me all day.

I don't know if SQL Server will allow me to do this internally or whether i would have to place the info into a spread sheet. I'm not familiar with SQLserver. I'm using Access right now and will be moving to SQL server soon hopefully.

If this can be done, is it a very involved learning curve?

What are you suggestions?

Thanks!

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-05-26 : 09:57:52
See if this is helpful
http://sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

JacobPressures
Posting Yak Master

112 Posts

Posted - 2005-05-26 : 14:18:59
I think it might be helpful. Do you use a Jet Engine for SQL Server? I thought Jet was Access.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-05-27 : 00:47:47
quote:
Originally posted by JacobPressures

I think it might be helpful. Do you use a Jet Engine for SQL Server? I thought Jet was Access.



I didnot use jet for SQL Server. It is for Excel. See that code again

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -