Tuesday, September 09, 2008

Sydney SQL Server User 9th September 2008

Quite an interesting night based around SQL Server Reporting Services 2008…..

The pizza was plentiful…Cholesterol levels rose quite a bit last night.

Grant from Angry Koala, gave away some of his little koala bears for answers to some of his questions!
Interesting Marketing ploy!
Maybe MacroView needs to give away a lot more cubes!

The exciting news is that in October a SQL Server 2008 feature Pack will come out with lots more goodies such as report builder with a nice office 2007 look and being almost the same as the report designer!
Business users should get exciting.
There will be some other exciting new extras in this so will let you guys know…..
Hopefully will go through all this in the sql code camp in October etc…
There should be a lot more feature packs so that nice enhancements can be delivered faster and easier….

The new report designer is much nicer and changed quite a bit.
The tablix controls means smarter simpler and more powerful reporting without code gymnastics!

Big reports run smarter – eg. Only render the first page so they won’t bring the server to it’s knees!

Also the outputs to Excel are better along with the new output to Word. Nice!!!
Apparently one of the uses is to generate and send monthly invoicing etc….

The rich text stuff was only briefly flashed on the screen, but everything is so much nicer that you won’t want to do anything with the “old” stuff…

Two tips of the day:
1: Setting the interactive size for height and width to zero means it will fit the whole screen – e.g. no next page stuff.
The page size settings apply to printing…..

2: Name all reports starting with a number e.g. R001 – New Prospects.
That way every time a client ( or internal user ) calls about a report, it is really easy to figure out which one.
And what with the long names you use, many users will also get to know their favourite reports by number as well!

Coming up:
Next Wednesday at Microsoft, Adam Cogan at the .net user group will go over all the admin stuff..
I might go along and keep him in line and teach him a few tricks to do with incorporating this into SharePoint!

Also SQL Code Camp in Wagga Wagga is coming up this October so it should be quite interesting…

Tom Bizannes
Microsoft Certified Professional
Sql Server and Microsoft Office Development
Sydney, Australia
http://www.macroview.com.au/

No comments: