images loading slow corrupts the report

I have a report with an embedded image which appears in every row(static), it
also has a report that it drills down to. This page that calls this report
uses the reportviewer. the report loads quick, but the images take a while
longer. If I hit the column that drills to the next report, I can see the
page call the server, but the report stays on the same page. Yet the
reportviewer showbackbutton becomes active. If you hit the backbutton on
the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot
be found .
How do I get the images quicker?
How do I keep the above problem from happening?On Jul 5, 5:32 pm, NeedToKnow <NeedToK...@.newsgroups.nospam> wrote:
> I have a report with an embedded image which appears in every row(static), it
> also has a report that it drills down to. This page that calls this report
> uses the reportviewer. the report loads quick, but the images take a while
> longer. If I hit the column that drills to the next report, I can see the
> page call the server, but the report stays on the same page. Yet the
> reportviewer showbackbutton becomes active. If you hit the backbutton on
> the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot
> be found .
> How do I get the images quicker?
> How do I keep the above problem from happening?
It seems like you are using too many resources while trying to render
several images. If your images are MPEG, I would suggest converting
them to JPG/JPEG/GIF which should conserve space and improve
performance a little. It seems from your description that the
execution error is related to the resource utilization (of the
rendering). Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||My resource is one gif that is 925 bytes in size. It appears on every line
of the table. It is not a resource error. It comes from the reportviewer
when it is trying to load the drill down report.
"EMartinez" wrote:
> On Jul 5, 5:32 pm, NeedToKnow <NeedToK...@.newsgroups.nospam> wrote:
> > I have a report with an embedded image which appears in every row(static), it
> > also has a report that it drills down to. This page that calls this report
> > uses the reportviewer. the report loads quick, but the images take a while
> > longer. If I hit the column that drills to the next report, I can see the
> > page call the server, but the report stays on the same page. Yet the
> > reportviewer showbackbutton becomes active. If you hit the backbutton on
> > the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot
> > be found .
> > How do I get the images quicker?
> > How do I keep the above problem from happening?
>
> It seems like you are using too many resources while trying to render
> several images. If your images are MPEG, I would suggest converting
> them to JPG/JPEG/GIF which should conserve space and improve
> performance a little. It seems from your description that the
> execution error is related to the resource utilization (of the
> rendering). Sorry that I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

IIF Function

I've been looking at the online help and it appears that
this statement should function as follows:
Select IIf(1 > 0 , 'Yes', 'No')
If 1 is greater than 0, Yes should be returned, if not
then No
Sql returns an error message: Incorrect syntax near '>'
Any Ideas?
Thanks
You must be looking at help for MS Access or Excel or something. There is
no such thing as IIF in SQL Server. Maybe try CASE:
SELECT CASE WHEN 1 > 0 THEN 'Yes' ELSE 'No' END
"Raghib" <anonymous@.discussions.microsoft.com> wrote in message
news:100801c4f1fe$f73d1860$a301280a@.phx.gbl...
> I've been looking at the online help and it appears that
> this statement should function as follows:
> Select IIf(1 > 0 , 'Yes', 'No')
>
> If 1 is greater than 0, Yes should be returned, if not
> then No
> Sql returns an error message: Incorrect syntax near '>'
> Any Ideas?
> Thanks
>
|||If you search for IIF in SQL Server Books Online, you will indeed find it.
However, you have to look at the title (or location) and realize it is for
Analysis Services only.
This is not a TSQL function, but rather an MDX function.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GAGeFg8EHA.2600@.TK2MSFTNGP09.phx.gbl...
> You must be looking at help for MS Access or Excel or something. There is
> no such thing as IIF in SQL Server. Maybe try CASE:
> SELECT CASE WHEN 1 > 0 THEN 'Yes' ELSE 'No' END
>
>
> "Raghib" <anonymous@.discussions.microsoft.com> wrote in message
> news:100801c4f1fe$f73d1860$a301280a@.phx.gbl...
>

IIF Function

I've been looking at the online help and it appears that
this statement should function as follows:
Select IIf(1 > 0 , 'Yes', 'No')
If 1 is greater than 0, Yes should be returned, if not
then No
Sql returns an error message: Incorrect syntax near '>'
Any Ideas?
ThanksYou must be looking at help for MS Access or Excel or something. There is
no such thing as IIF in SQL Server. Maybe try CASE:
SELECT CASE WHEN 1 > 0 THEN 'Yes' ELSE 'No' END
"Raghib" <anonymous@.discussions.microsoft.com> wrote in message
news:100801c4f1fe$f73d1860$a301280a@.phx.gbl...
> I've been looking at the online help and it appears that
> this statement should function as follows:
> Select IIf(1 > 0 , 'Yes', 'No')
>
> If 1 is greater than 0, Yes should be returned, if not
> then No
> Sql returns an error message: Incorrect syntax near '>'
> Any Ideas?
> Thanks
>|||If you search for IIF in SQL Server Books Online, you will indeed find it.
However, you have to look at the title (or location) and realize it is for
Analysis Services only.
This is not a TSQL function, but rather an MDX function.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GAGeFg8EHA.2600@.TK2MSFTNGP09.phx.gbl...
> You must be looking at help for MS Access or Excel or something. There is
> no such thing as IIF in SQL Server. Maybe try CASE:
> SELECT CASE WHEN 1 > 0 THEN 'Yes' ELSE 'No' END
>
>
> "Raghib" <anonymous@.discussions.microsoft.com> wrote in message
> news:100801c4f1fe$f73d1860$a301280a@.phx.gbl...
>

IIF Function

I've been looking at the online help and it appears that
this statement should function as follows:
Select IIf(1 > 0 , 'Yes', 'No')
If 1 is greater than 0, Yes should be returned, if not
then No
Sql returns an error message: Incorrect syntax near '>'
Any Ideas?
ThanksYou must be looking at help for MS Access or Excel or something. There is
no such thing as IIF in SQL Server. Maybe try CASE:
SELECT CASE WHEN 1 > 0 THEN 'Yes' ELSE 'No' END
"Raghib" <anonymous@.discussions.microsoft.com> wrote in message
news:100801c4f1fe$f73d1860$a301280a@.phx.gbl...
> I've been looking at the online help and it appears that
> this statement should function as follows:
> Select IIf(1 > 0 , 'Yes', 'No')
>
> If 1 is greater than 0, Yes should be returned, if not
> then No
> Sql returns an error message: Incorrect syntax near '>'
> Any Ideas?
> Thanks
>|||If you search for IIF in SQL Server Books Online, you will indeed find it.
However, you have to look at the title (or location) and realize it is for
Analysis Services only.
This is not a TSQL function, but rather an MDX function.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GAGeFg8EHA.2600@.TK2MSFTNGP09.phx.gbl...
> You must be looking at help for MS Access or Excel or something. There is
> no such thing as IIF in SQL Server. Maybe try CASE:
> SELECT CASE WHEN 1 > 0 THEN 'Yes' ELSE 'No' END
>
>
> "Raghib" <anonymous@.discussions.microsoft.com> wrote in message
> news:100801c4f1fe$f73d1860$a301280a@.phx.gbl...
>> I've been looking at the online help and it appears that
>> this statement should function as follows:
>> Select IIf(1 > 0 , 'Yes', 'No')
>>
>> If 1 is greater than 0, Yes should be returned, if not
>> then No
>> Sql returns an error message: Incorrect syntax near '>'
>> Any Ideas?
>> Thanks
>