Showing posts with label specified. Show all posts
Showing posts with label specified. Show all posts

Monday, March 26, 2012

External Image not displaying

Hi,
I installed SP1 and have specified an image as External & am using
"https"//abc.com/Images"+Fields!LOGO.Value as the exprseeion for getting the
image but the iamge is not displaying. The image in the database field LOGO
is stored simply as xyz.gif . How acn i display such an image? Am i missing
something here?
--
pmudDid you read the following section for the SP1 readme about external images:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
If the UnattendedExecutionAccount is not configured, the report server will
try to access the image with no credentials (anonymous). Also, did you check
if the expression really generates a valid image path? If you run the report
in report designer preview (with SP1 installed), you should see a processing
warning message with details if the web server responds e.g. with a 401
error on the image request.
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:ACFAA192-6175-4AC4-8CA5-26641626CAFB@.microsoft.com...
> Hi,
> I installed SP1 and have specified an image as External & am using
> "https"//abc.com/Images"+Fields!LOGO.Value as the exprseeion for getting
> the
> image but the iamge is not displaying. The image in the database field
> LOGO
> is stored simply as xyz.gif . How acn i display such an image? Am i
> missing
> something here?
> --
> pmud|||Hi Robert,
I validated that the image can be accessed through IE. Also, my report uses
a shared data source which uses credentials. So i dont think there will be a
need to configure an account for unattended execution. what do you think?
Also,when i use the expression ="https://abc.com/Images/"&FieldsLOGO.Value,
I cant see the image when the report is previewed. actually whn i create the
expression & try to insert &Fields!LOGO.VAlue , when i expand the Fields
section, it says report item not linked to dataset. So I tried to use the
expression ="https://triotekdealer.com/Images/"&(Fields!LOGO_IMAGEPATH.Value,
"DataSet1")
But i got the error : The value expression for the image â'image1â' contains
an error: [BC30198] ')' expected.
How can I link the dataset to the image so that it can use the fields in the
dataset, if thats's what the problem is?
--
pmud
"Robert Bruckner [MSFT]" wrote:
> Did you read the following section for the SP1 readme about external images:
> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
> If the UnattendedExecutionAccount is not configured, the report server will
> try to access the image with no credentials (anonymous). Also, did you check
> if the expression really generates a valid image path? If you run the report
> in report designer preview (with SP1 installed), you should see a processing
> warning message with details if the web server responds e.g. with a 401
> error on the image request.
>
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:ACFAA192-6175-4AC4-8CA5-26641626CAFB@.microsoft.com...
> > Hi,
> >
> > I installed SP1 and have specified an image as External & am using
> > "https"//abc.com/Images"+Fields!LOGO.Value as the exprseeion for getting
> > the
> > image but the iamge is not displaying. The image in the database field
> > LOGO
> > is stored simply as xyz.gif . How acn i display such an image? Am i
> > missing
> > something here?
> > --
> > pmud
>
>|||You could move the image inside a data region (e.g. a list). Then you will
get one image per row in the dataset. In that case the expression has to
look like:
="https://triotekdealer.com/Images/" & Fields!LOGO_IMAGEPATH.Value
Otherwise, you have to use an aggregate function (because the dataset has
multiple rows):
="https://triotekdealer.com/Images/" & First(Fields!LOGO_IMAGEPATH.Value,
"DataSet1")
This posting is provided "AS IS" with no warranties, and confers no rights.
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:83471FE2-3457-4C66-85A0-8F9CE798901C@.microsoft.com...
> Hi Robert,
> I validated that the image can be accessed through IE. Also, my report
> uses
> a shared data source which uses credentials. So i dont think there will be
> a
> need to configure an account for unattended execution. what do you think?
> Also,when i use the expression
> ="https://abc.com/Images/"&FieldsLOGO.Value,
> I cant see the image when the report is previewed. actually whn i create
> the
> expression & try to insert &Fields!LOGO.VAlue , when i expand the Fields
> section, it says report item not linked to dataset. So I tried to use the
> expression
> ="https://triotekdealer.com/Images/"&(Fields!LOGO_IMAGEPATH.Value,
> "DataSet1")
> But i got the error : The value expression for the image 'image1' contains
> an error: [BC30198] ')' expected.
> How can I link the dataset to the image so that it can use the fields in
> the
> dataset, if thats's what the problem is?
> --
> pmud
>
> "Robert Bruckner [MSFT]" wrote:
>> Did you read the following section for the SP1 readme about external
>> images:
>> http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_external_images
>> If the UnattendedExecutionAccount is not configured, the report server
>> will
>> try to access the image with no credentials (anonymous). Also, did you
>> check
>> if the expression really generates a valid image path? If you run the
>> report
>> in report designer preview (with SP1 installed), you should see a
>> processing
>> warning message with details if the web server responds e.g. with a 401
>> error on the image request.
>>
>> --
>> Robert M. Bruckner
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "pmud" <pmud@.discussions.microsoft.com> wrote in message
>> news:ACFAA192-6175-4AC4-8CA5-26641626CAFB@.microsoft.com...
>> > Hi,
>> >
>> > I installed SP1 and have specified an image as External & am using
>> > "https"//abc.com/Images"+Fields!LOGO.Value as the exprseeion for
>> > getting
>> > the
>> > image but the iamge is not displaying. The image in the database field
>> > LOGO
>> > is stored simply as xyz.gif . How acn i display such an image? Am i
>> > missing
>> > something here?
>> > --
>> > pmud
>>

Sunday, February 19, 2012

exporting to pdf without generating report

hi
I am calling a report from asp and if i click the button the report has to
be be stored in a specified location given by the user and report window
should not be generated.
It is very urgent please help me to solve the problem
thanks
terranceHi,
If you are using URL access then try this.
e.g.
http://servername/reportserver?/Sales/YearlySalesSummary&rs:Format=PDF&rs:Command=Render
If you are in the program, you need to change the response.contenttype as
well to "Application/PDF"
Amarnath
"ter" wrote:
> hi
> I am calling a report from asp and if i click the button the report has to
> be be stored in a specified location given by the user and report window
> should not be generated.
> It is very urgent please help me to solve the problem
> thanks
> terrance
>