Book Recommendation for SRS2005 Designing Reports

Hi,
Does anyone have any book recommendations for designing Reports? I am
looking for a book that covers the basics but also moves onto more
advanced examples.
Thanks.I just picked up "Microsoft SQL Server 2005 Reporting Services 2005" by
Brian Larson (McGraw Hill). The ISBN is 0-07-226239-7. It was highly rated
on Amazon and it's turned out to be excellent.
"Gareth King" <QBVBKADUOIUJ@.spammotel.com> wrote in message
news:WtFKf.111376$AL5.53955@.fe01.news.easynews.com...
> Hi,
> Does anyone have any book recommendations for designing Reports? I am
> looking for a book that covers the basics but also moves onto more
> advanced examples.
> Thanks.

blob data type in SQL Express

Hi all,

I am trying to store binary datafiles into a SQl Express table. However I can not find the BLOB data type when I am designing the table. Are we limited to using that kind of data type in the Express edition? Thanks.

Ke

hi Ke,

if you are searching for a BLOB datatype, you'll miss it..

SQLExpress does support blobs in different formats, binary, varbinary, image and text/ntext as long as the new datatypes as varchar(MAX), nvarchar(MAX), varbinary(MAX), XML

use tempdb;

GO

CREATE TABLE dbo.testBlob (

Id int NOT NULL PRIMARY KEY,

b varchar(max),

i image,

b2 varbinary (50)

);

GO

DROP TABLE dbo.testBlob ;

I've just run SQL Server Management Studio Express, the official graphical client tool for SQLExpress, available for free download at http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en, and the relative datatypes are listed in the datatypes combobox when editing tables...

please have a look at http://msdn2.microsoft.com/en-us/library/ms187752.aspx for all supported data types..

regards