Showing posts with label actual. Show all posts
Showing posts with label actual. Show all posts

Friday, March 23, 2012

Image path/not an actual image on an rdl

I put together an invoice report in RS which will be given to multiple
clients. I would like their logo to show up on the report. Instead of
embedding 1 logo on the .rdl and then giving it to one client, then
embedding a different logo on the .rdl and giving that to a different
client, so on and so on, can I just put a path to an image on the file and
make sure that each logo is placed in the same folder in the same drive,
ie.. "C:\[logofolder]".
Thank you for the help.
--You will need RS 2000 SP1. Details are in the SP1 readme file:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
The file: protocol is supported to fetch images from local or network paths.
Make sure to follow the instructions in RS BOL for "Configuring an Account
for Unattended Report Processing" on the report server, as indicated in the
SP1 readme file.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:OnxfRk7pEHA.3716@.TK2MSFTNGP10.phx.gbl...
> I put together an invoice report in RS which will be given to multiple
> clients. I would like their logo to show up on the report. Instead of
> embedding 1 logo on the .rdl and then giving it to one client, then
> embedding a different logo on the .rdl and giving that to a different
> client, so on and so on, can I just put a path to an image on the file and
> make sure that each logo is placed in the same folder in the same drive,
> ie.. "C:\[logofolder]".
> Thank you for the help.
> --
>
>|||Hi,
I followed all instructions in the Rs BOL but the problem isn't resolved.
Do you know if some other things can cause the problem?
"Robert Bruckner [MSFT]" wrote:
> You will need RS 2000 SP1. Details are in the SP1 readme file:
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
> The file: protocol is supported to fetch images from local or network paths.
> Make sure to follow the instructions in RS BOL for "Configuring an Account
> for Unattended Report Processing" on the report server, as indicated in the
> SP1 readme file.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Richard Cranium" <mgreco40@.hotmail.com> wrote in message
> news:OnxfRk7pEHA.3716@.TK2MSFTNGP10.phx.gbl...
> > I put together an invoice report in RS which will be given to multiple
> > clients. I would like their logo to show up on the report. Instead of
> > embedding 1 logo on the .rdl and then giving it to one client, then
> > embedding a different logo on the .rdl and giving that to a different
> > client, so on and so on, can I just put a path to an image on the file and
> > make sure that each logo is placed in the same folder in the same drive,
> > ie.. "C:\[logofolder]".
> >
> > Thank you for the help.
> >
> > --
> >
> >
> >
>
>

Wednesday, March 21, 2012

Image data type, doesn't return the data on selected

I don't know much about the Image data type. When I query a record and get
only 16bits of the an Imaeg field, instead of the actual data?
Any documentation and guidance for this problem? It seems not on the Books
Online.
Thanks very much.Check out the 'Retrieving ntext, text, or image Values' topic in the SQL
Server Books Online.
HTH
Jerry
"zhaounknown" <zhaounknown@.discussions.microsoft.com> wrote in message
news:686F627B-885B-4C6E-9134-4148CFFD824F@.microsoft.com...
>I don't know much about the Image data type. When I query a record and get
> only 16bits of the an Imaeg field, instead of the actual data?
> Any documentation and guidance for this problem? It seems not on the Books
> Online.
> Thanks very much.|||Thanks for your reply.
I checked the topic of "retrieving ntext, ...".
What it says is :
The full amount of data is returned if the length is less than TEXTSIZE.
The DB-Library API also supports a dbtextsize parameter that controls the
length of ntext, text, and image data that can be selected. The Microsoft OL
E
DB Provider for SQL Server and the SQL Server ODBC driver automatically set
@.@.TEXTSIZE to its maximum of 2 GB.
I am using MSDE, and @.@.TextSize is 64512. However, my object's length counts
56424, which is less than 64512 and is supposed to return the data in full.
But it seems doesn't.
"Jerry Spivey" wrote:

> Check out the 'Retrieving ntext, text, or image Values' topic in the SQL
> Server Books Online.
> HTH
> Jerry
> "zhaounknown" <zhaounknown@.discussions.microsoft.com> wrote in message
> news:686F627B-885B-4C6E-9134-4148CFFD824F@.microsoft.com...
>
>|||I found the problem is the data has not been stored into the SQL Server.
The reason is:
I create a update command using ADO.Net wizard by entering the command text
manually in the wizard, which will generate the Image field to have size at
16, instead of 2147483647, which causes the problem.
Hope, this may help anyone.
"zhaounknown" wrote:
> Thanks for your reply.
> I checked the topic of "retrieving ntext, ...".
> What it says is :
> The full amount of data is returned if the length is less than TEXTSIZE.
> The DB-Library API also supports a dbtextsize parameter that controls the
> length of ntext, text, and image data that can be selected. The Microsoft
OLE
> DB Provider for SQL Server and the SQL Server ODBC driver automatically se
t
> @.@.TEXTSIZE to its maximum of 2 GB.
> I am using MSDE, and @.@.TextSize is 64512. However, my object's length coun
ts
> 56424, which is less than 64512 and is supposed to return the data in full
.
> But it seems doesn't.
>
> "Jerry Spivey" wrote:
>