We are implementing a new SQL database, but I need to get one of the guys up to speed on how to create reports from this.

Can anyone recommend a course (be it Microsoft or otherwise) or a good training centre in Surrey that would be able to help?

Is it worth looking at Crystal Reports to carry out the reporting or will the SQL elements be fine?

Cheers
Andy

 

Yes you should look to go down the Crystal route first for reporting as SQL on its own will not do the reporting layout just give you the data you need. Crystal uses SQL for more complex reports to return result sets anyway so it would be a good place to start and learn. Next get some 'SQL for dummies' books very good intro to SQL.

Gary

 

Cheers Gary. Is there a particular version of Crystal to look at?

I see there are a couple of versions.

 

Don't give me that "i'm all new and working really hard" rubbish tango , we know it's just a front

 

LOL

TBH it's been a while since I been so happy to have a challenge at work!!

 

good stuff mate

 

Andy,

Any recent version, professional edition will do ya!

Gary

 

Can heartly recommend 'SAMS Teach yourself SQL in 10 minutes'.
Came in handy when I had to do a crash course in SQL report writing for Informix.

 

Hi Andy,

Inavlauable link in my toolkit is: http://www.microsoft.com/technet/pro...s/rptsvcs.mspx

We're just starting test deployments of SQL 2005 ... theres some quality free training that I have been through:

https://www.microsoftelearning.com/e...rPriceId=66793

https://www.microsoftelearning.com/sqlserver2005/