all groups > sql server reporting services > november 2004 >
You're in the

sql server reporting services

group:

Present 4 images on each row in a report


Present 4 images on each row in a report Billy
11/23/2004 2:23:04 PM
sql server reporting services:
I am going to present images that are stored in a database (SQL Server 2000)
on my report. I want to have 4 pictures on each row.

My table contains 20 images and hence I will have 5 rows with 4 pictures on
each row.

Re: Present 4 images on each row in a report Billy
11/24/2004 4:17:03 AM
Thank for your answer but I don't think that will solve my challenge.

The problem is not to present the images, but to display them four on each
row. Like this (numbers are placeholders for my images):

1 2 3 4
5 6 7 8

My resultset from the query is like this (numbers are still placeholders):
1
2
3
4
..
..
..
20

I wouild appriciate your further help on this question.

Thanks in advance.




[quoted text, click to view]
Re: Present 4 images on each row in a report Devon
11/24/2004 9:21:16 AM
This may be a silly way to do it since it will need to be modified whenever
you add an image to the table but set the dataset query to:

select
case when id = 1 then image end
,case when id = 2 then image end
,case when id = 3 then image end
,case when id = 4 then image end
from imageTable
union
select
case when id = 5 then image end
,case when id = 6 then image end
,case when id = 7 then image end
,case when id = 8 then image end
from imageTable
union
select
case...

[quoted text, click to view]

Re: Present 4 images on each row in a report Abdus Salam Atif
11/24/2004 5:03:47 PM
You have to use a table or list control on your report and then add the
image control to the row of the table or inside the list control. I hope
this will help.

Regards,

Atif

[quoted text, click to view]

AddThis Social Bookmark Button