external images disappear with interactive sort

I have created my report with embedded and external images. There are also
interactive sorting set up for all columns in my report. When I deploy the
report and look at it in the report manager, report appears good. However
when I try to change the sort directin of any any column using the
interactive sort icon then the new page does not have my external image. How
can I fix this so that I can see these images in my Report Manager?
Note: My system name does not have any underscore. But it has a hyphen. The
computer name in <urlroot> element of rsreportserver.config file has full
name in it. Also I tried to change the useSessionCookies entry to false in
ConfigurationInfo table of my Report server to false. But it did not help me.
So I reverted it back to true.This happened with me when I was using VS2005 beta but was fixed with
the real version. FYI|||Hi,
Thanks for posting at the newsgroup!
From your post, my understanding of this issue is: interactive sorting
works well in report manager, however, the sorting image is not working
now. If this is not correct, please feel free to let me know.
So currently I'd suggest we could check your SQL server 2005 version.
Please go to the localhost site and type the reporting service as below:
http://localhost/reportserver
Then at the page, the SQL server 2005 version will be listed. If you have
several instance at the reporting service, please use the url:
http://localhost/reportserver$<instancename>
Furthermore, if you could give us one detailed repro step(we could use the
Adventure works, pubs or northwind sample database) on this issue, that
will be very helpful for our troubleshooting. Thanks a lot!
Look forward to your reply!
Best Regards,
Wei-Dong XU
Microsoft Support
----
This posting is provided "AS IS" with no warranties, and confers no rights.
----
It is my pleasure to be of any assistance.|||Hi all,
The version of Reporting services that I use is "Microsoft SQL Server
Reporting Services Version 9.00.1399.00". This is RTM version of SQL Server
2005.
Your understanding of my problem: "interactive sorting
works well in report manager, however, the sorting image is not working
now."
My Problem: "Interactive sorting works good in report manager and also the
sort image appears good. My report has a customer logo which is basically
created using project type. Thus it is an external image not the embedded
one. This external image which is added to report by me disappears when I
make use of the sorting using the sort icon in Report manager."
Thanks.|||Hi Ring,
Does the URL of your external image stored in database? Is it possible for
you to generate a reproduce sample based on AdventureWorks? Or it will be
appreciated if you could give me some screen shot.
You may attach the sample in the newsgroup. I understand the information
may be sensitive to you, my direct email address is
v-mingqc@.ONLINEmicrosoft.com (please make sure you have REMOVED ONLINE
before you click SEND), you may send the file to me directly and I will
keep secure.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
I am not sure if you received my email. Thus I am answering you also in
newsgroup. My image which disappears with interactive sorting is not taken
from database. I initally add image to my report solution. When we try to put
image in our report from tool box, image wizard starts. I am choosing project
type in the image wizard. Then I choose the image which I previosly added to
my solution in the 3rd step of image wizard. Then while I deploy my report to
a folder in ReportServer, I also deploy my image to the same folder. As I do
not know how to add attachments in a web based newgroup viewer, I am not
attaching my screenshots.
Thanks|||Hi,
Yes, thanks so much for emailing the screen shots and I have reproduced it
on my side.
This is a known issue for SQL Server 2005 Reporting Services and will be
fixed in SSRS 2005 SP1.
I am sincerely sorry for the inconvenience it might cause to you and thanks
so much for your understanding.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I just downloaded and installed the SQL Server 2005 SP1 CTP that was made
available on Friday and this problem is not fixed! What is the status on this
problem being fixed by Microsoft? I have an SSRS 2005 deployment that is
scheduled for release in the next month and this issue is a big problem since
it is our company's logo that is not displaying when this error occurs.
Steve
"Michael Cheng [MSFT]" wrote:
> Hi,
> Yes, thanks so much for emailing the screen shots and I have reproduced it
> on my side.
> This is a known issue for SQL Server 2005 Reporting Services and will be
> fixed in SSRS 2005 SP1.
> I am sincerely sorry for the inconvenience it might cause to you and thanks
> so much for your understanding.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page: http://support.microsoft.com/common/international.aspx
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>sql

External image problem when sorting in table

Reporting Services I am using external image png as my header for reports When i am clicking on sort row of the report the header image is dissapeared.Though it is working well in Visual Studio 2005 the problem is occuring after deploying it in reportserver.

What the reason and how can i remove this error.It was working well when i had embeded the image..But i need to have external image only..

Did you install SP1 on the report server (http://www.microsoft.com/sql/sp1.mspx)?

-- Robert

Expression editor (sort of) bug

I've noticed in the expression editor that pasting rich text (like copied
from a web page) preserves the formatting. This makes stuff look really
screwed up in the expression editor. I noticed this copying stuff from this
newsgroup and pasting it into the expression editor.I believe the formatting goes away after you commit it. But be careful
about extra carriage returns/line feeds. They can mess up the code.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Stefan Wrobel" <StefanWrobel@.discussions.microsoft.com> wrote in message
news:8C6BE014-DC4D-400B-9CA6-CBDDFC99B16E@.microsoft.com...
> I've noticed in the expression editor that pasting rich text (like copied
> from a web page) preserves the formatting. This makes stuff look really
> screwed up in the expression editor. I noticed this copying stuff from
> this
> newsgroup and pasting it into the expression editor.

Exporting to Excel...problems, problems

I'm exporing a simple matrix report to excel. Once exported I want to sort on
a particular column but it errors out..."This operation requires merged cells
to be identically sized." If I highlight all the cells then go to format ->
cells - > uncheck merge cells it still does not work. The numeric data in the
columns is being treated as text. Can someone please offer some suggestions?
the matrix is quite simple. Person, month columns with the data being the
count per month.
Thanks,Did you try using Data/Text to Columns... on the column of data in question?
"Brian L" wrote:
> I'm exporing a simple matrix report to excel. Once exported I want to sort on
> a particular column but it errors out..."This operation requires merged cells
> to be identically sized." If I highlight all the cells then go to format ->
> cells - > uncheck merge cells it still does not work. The numeric data in the
> columns is being treated as text. Can someone please offer some suggestions?
> the matrix is quite simple. Person, month columns with the data being the
> count per month.
> Thanks,