Image in details

Question

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Shouldn't the image be in a separate table.

That allows you to join to that table using a case expression and it follows the normalization rules.

Dante Garcia SSC Enthusiast Points: 128 More actions · Answer 2

SSC Enthusiast

Points: 128

October 7, 2005 at 11:43 am

Could you tell me how to do that?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Even simpler than that.

Table Images

ImageID

ImagePath (or the image itself)

...

Table

Classification

ClassificationID

ImageID (foreign key to the images table)

...

Then

Select Columns, List, from dbo.Classifications S inner join dbo.Images I on S.ImageID = I.imageID

Dante Garcia SSC Enthusiast Points: 128 More actions · Answer 4

Oh, you meant on the dataase... I meant in the report table...

I'll try having an image column in my databse table...

Thanks

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

That's how I'd do it... but maybe there's another way in RS (never worked with that product).