I am trying to display image data stored in a database field using SRS 2005.
The image data is employee photos and I can get them to display in one column
straight down the report using a List control.
Is there a way to get them to display in 3 columns sorting across the page?
This would be like a High School yearbook layout...
Like this...
Pic 1 Pic 2 Pic 3
Pic 4 Pic 5 Pic 6
Instead of like this...
Pic 1
Pic 2
Pic 3
Pic 4Hi,
I'm not sure if this is done differently in SRS 2005 but in SRS 2000, you
can set the Columns property on the Report Page. Just click the page and
then in the Properties window, specify the number of columns needed (3 in
your case).
Hope that helps.
Assad
"jj#10" wrote:
> I am trying to display image data stored in a database field using SRS 2005.
> The image data is employee photos and I can get them to display in one column
> straight down the report using a List control.
> Is there a way to get them to display in 3 columns sorting across the page?
> This would be like a High School yearbook layout...
> Like this...
> Pic 1 Pic 2 Pic 3
> Pic 4 Pic 5 Pic 6
> Instead of like this...
> Pic 1
> Pic 2
> Pic 3
> Pic 4
>
Showing posts with label photos. Show all posts
Showing posts with label photos. Show all posts
Friday, March 9, 2012
displaying images horizontally - not vertically
Sunday, February 19, 2012
Display pictures in Northwind on the VB form
Hi,
In Northwind , there is an employees table which store photos. It seems the
pictures are linked to the picture files because there is a photopath field
containing the path. When I try to display the photos on the VB form, it g
ive me a error. I used the same way to display the logos in the pubs and th
ere is no problem. In VB, I used ODBC data source with ADODB control and a
picture control. Could you try it and tell me how to solve the problem?
Thanks a lotHi
The Photopath column contains the path to the photo. This has a http address
which you may have to change. The logo column in the PUBS database (pub_inf
o table) is an Image datatype which is the same datatype as the photo column
in the Northwind Employee table.
John
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message news:%23pkBQO0YF
HA.616@.TK2MSFTNGP12.phx.gbl...
Hi,
In Northwind , there is an employees table which store photos. It seems the
pictures are linked to the picture files because there is a photopath field
containing the path. When I try to display the photos on the VB form, it g
ive me a error. I used the same way to display the logos in the pubs and th
ere is no problem. In VB, I used ODBC data source with ADODB control and a
picture control. Could you try it and tell me how to solve the problem?
Thanks a lot|||Could you try to display the photos in VB? I cannot make it work.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:eDDcD44YFHA.3
356@.TK2MSFTNGP15.phx.gbl...
Hi
The Photopath column contains the path to the photo. This has a http address
which you may have to change. The logo column in the PUBS database (pub_inf
o table) is an Image datatype which is the same datatype as the photo column
in the Northwind Employee table.
John
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message news:%23pkBQO0YF
HA.616@.TK2MSFTNGP12.phx.gbl...
Hi,
In Northwind , there is an employees table which store photos. It seems the
pictures are linked to the picture files because there is a photopath field
containing the path. When I try to display the photos on the VB form, it g
ive me a error. I used the same way to display the logos in the pubs and th
ere is no problem. In VB, I used ODBC data source with ADODB control and a
picture control. Could you try it and tell me how to solve the problem?
Thanks a lot|||Hi Chris
As I don't have VB on a machine I can't, but I am pretty sure that the sampl
e program would work as it has been around for so long!! The code is using t
he photo column which it materialises by writing it to disc and then loads i
t into the Image control. If you stepped through the program you could check
that it wrote the file out correctly and you should be able to test loading
the file into (say) paint.
John
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message news:ezWN$N5YFHA
.132@.TK2MSFTNGP10.phx.gbl...
Could you try to display the photos in VB? I cannot make it work.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:eDDcD44YFHA.3
356@.TK2MSFTNGP15.phx.gbl...
Hi
The Photopath column contains the path to the photo. This has a http address
which you may have to change. The logo column in the PUBS database (pub_inf
o table) is an Image datatype which is the same datatype as the photo column
in the Northwind Employee table.
John
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message news:%23pkBQO0YF
HA.616@.TK2MSFTNGP12.phx.gbl...
Hi,
In Northwind , there is an employees table which store photos. It seems the
pictures are linked to the picture files because there is a photopath field
containing the path. When I try to display the photos on the VB form, it g
ive me a error. I used the same way to display the logos in the pubs and th
ere is no problem. In VB, I used ODBC data source with ADODB control and a
picture control. Could you try it and tell me how to solve the problem?
Thanks a lot
In Northwind , there is an employees table which store photos. It seems the
pictures are linked to the picture files because there is a photopath field
containing the path. When I try to display the photos on the VB form, it g
ive me a error. I used the same way to display the logos in the pubs and th
ere is no problem. In VB, I used ODBC data source with ADODB control and a
picture control. Could you try it and tell me how to solve the problem?
Thanks a lotHi
The Photopath column contains the path to the photo. This has a http address
which you may have to change. The logo column in the PUBS database (pub_inf
o table) is an Image datatype which is the same datatype as the photo column
in the Northwind Employee table.
John
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message news:%23pkBQO0YF
HA.616@.TK2MSFTNGP12.phx.gbl...
Hi,
In Northwind , there is an employees table which store photos. It seems the
pictures are linked to the picture files because there is a photopath field
containing the path. When I try to display the photos on the VB form, it g
ive me a error. I used the same way to display the logos in the pubs and th
ere is no problem. In VB, I used ODBC data source with ADODB control and a
picture control. Could you try it and tell me how to solve the problem?
Thanks a lot|||Could you try to display the photos in VB? I cannot make it work.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:eDDcD44YFHA.3
356@.TK2MSFTNGP15.phx.gbl...
Hi
The Photopath column contains the path to the photo. This has a http address
which you may have to change. The logo column in the PUBS database (pub_inf
o table) is an Image datatype which is the same datatype as the photo column
in the Northwind Employee table.
John
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message news:%23pkBQO0YF
HA.616@.TK2MSFTNGP12.phx.gbl...
Hi,
In Northwind , there is an employees table which store photos. It seems the
pictures are linked to the picture files because there is a photopath field
containing the path. When I try to display the photos on the VB form, it g
ive me a error. I used the same way to display the logos in the pubs and th
ere is no problem. In VB, I used ODBC data source with ADODB control and a
picture control. Could you try it and tell me how to solve the problem?
Thanks a lot|||Hi Chris
As I don't have VB on a machine I can't, but I am pretty sure that the sampl
e program would work as it has been around for so long!! The code is using t
he photo column which it materialises by writing it to disc and then loads i
t into the Image control. If you stepped through the program you could check
that it wrote the file out correctly and you should be able to test loading
the file into (say) paint.
John
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message news:ezWN$N5YFHA
.132@.TK2MSFTNGP10.phx.gbl...
Could you try to display the photos in VB? I cannot make it work.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:eDDcD44YFHA.3
356@.TK2MSFTNGP15.phx.gbl...
Hi
The Photopath column contains the path to the photo. This has a http address
which you may have to change. The logo column in the PUBS database (pub_inf
o table) is an Image datatype which is the same datatype as the photo column
in the Northwind Employee table.
John
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message news:%23pkBQO0YF
HA.616@.TK2MSFTNGP12.phx.gbl...
Hi,
In Northwind , there is an employees table which store photos. It seems the
pictures are linked to the picture files because there is a photopath field
containing the path. When I try to display the photos on the VB form, it g
ive me a error. I used the same way to display the logos in the pubs and th
ere is no problem. In VB, I used ODBC data source with ADODB control and a
picture control. Could you try it and tell me how to solve the problem?
Thanks a lot
Subscribe to:
Posts (Atom)