Andy Tang

iTrader: (3)

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

GaryK

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

Andy Tang

iTrader: (3)

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

I see there are a couple of versions.

stevem2k

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

Andy Tang

iTrader: (3)

LOL

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

SJ_Skyline

good stuff mate

GaryK

Andy,

Any recent version, professional edition will do ya!

Gary

jpor

iTrader: (1)

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.

Mutts Nutts

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/