External Image disappears with Interactive Sorting

Hi,

I have an image in the page header that is included in the project and is defined as "external". I also have interactive sorting enabled for the report. When a column is sorted, the image in the page header disappears. I deleted the image from the report and re-created it as "embedded" which does retain the image between postbacks.

Thank you,

Bob

Thank you Bob. This issue will be fixed in SP2 of RS 2005. If you have a pressing need, a hotfix has been released that product support services has.|||

Thank you Brad, I can live with this work around until SP2. In pre-SP1, I liked the "Select All" feature in multivalued parameters. In SP2, will this be available again? Will there be an option to turn this on and off, I hope?

|||

There is a post-SP1 hotfix which will restore the "Select All" option exactly the way it was in RTM. You will need to contact Microsoft product support (http://www.microsoft.com/services/microsoftservices/srv_support.mspx) to receive the SP1-based hotfix.

-- Robert

|||

Robert,

I installed the sequence of post-SP1 Hotfixes (including the one for SSRS) accessible through the link you provided, but this did not restore the 'Select All' capability. I called the support line and they could not provide any assistance without a reference # for the fix. Can you provide a bit more information on what needs to be installed/configured to restore the 'Select All' capability?

For reference: http://support.microsoft.com/kb/918222 is where I found the Hot Fix package.

Thanks in advance,

Bob Mack - HP

|||

Sql Hotfix #803 - but you may need to wait a few more days because a new package is currently being built.

-- Robert

|||Any update on the availability of this Hotfix?

Exporting SQL DB files

i have a VB project utilising SQL server Express. I need to export the database files so that the user data can be copied to a laptop and made available to other users.

My problem is this, connections are remaining open to the DB files even though I close all forms that include data access. Typically, my application takes around 6 minutes before the connections are released and the files can be copied.

Is there a way of either forcing all connections to close or of exporting the DB while it has connections?

Rich

Have you tried closing the connection on closing the form

Dim instance As DbConnection

instance.CloseSorry if the syntax is wrong I'm a C++ man. Same principles though.|||

In addition to what he has said about closing connections (a question might be if your access layer is caching connections, like connection pooling) you can force everyone out by using:

alter database <dbName>
set single_user with rolback immediate

Now, you have to be really careful that you want to do this, because if this is actually a database that someone else has access to they might be in the middle of doing something and this will really harsh their database experience :)

|||

I think this is exactly what's happenning, however, I am confused by your code - VS dosn't recognise it at all!

Cheers,

Rich