Embedded image does not appear

Hi there!

I've an embedded image (logo) in my report, and in the preview it looks wonderful, but after deploy the logo doesnt appear in the report (report server).

The url of the dead-link-image is http://hamsql1/Reports$BI/Reserved.ReportViewerWebControl.axd?.

I thought that an embedded image is stored "in" the report, but it seems to be an other place. Is it nessecary to deploy an embedded image too? Is it a problem of permissions (i read it in another threat)? How to set these image-see-permission? Or is there an other problem?

Every idea is very welcome!

Thanks,

Torsten

Some new informations:

The imported image is an printable image with 300 dpi. These image does not appear in the report. Another image, 72dpi, appears. Is it possible, that the render is not able to render 300 dpi?

|||

Hello,

What version of Reporting Services are you running? Have you applied the latest service pack? If you go to http://<server>/ReportServer and look in the bottom right you will see the version number.

Also, are both images embedded? Are they both the same image type (gif, jpg, etc.)? Are either of them scaled? Is the sizing option on both set the same?

Try building a new blank report and embedding both images using the wizard defaults. Does it work then?

Larry

|||

HI Larry!

I've Microsoft SQL Server Reporting Services, Version 9.00.3042.00, SP2, running on Win 2003 Server 64 Bit.

Both images are embedded, both are jpg. I tried both, scaled and nonscaled, it seems there is no dependency on scaling or not.

I tried it in a blank report, and again, the 300dpi image does not appear, the 72dpi image is okay.

Torsten

|||

Hello Torsten,

You are running on SP2 Original (http://www.sqlservercentral.com/columnists/sjones/2960.asp) and I have tested on a 32 bit Win 2003 with the same version of SSRS and don't see the problem. I will have to wait until I get home to test the 64 bit versions. Can you share your images with me? It could be image specific. My email is larry at smithmier dot com.

Thanks,

Larry

|||

Hi Larry!

Could you reproduce it?

Torsten

|||

Hello,

Yes, I received your report and images and reproduced it locally (even on a 32 bit machine). I fixed the problem by resaving the JPG as a new file using Paint.NET (http://www.getpaint.net/) and re-embedding it. I am looking at the file itself to see if I can figure out what went wrong, but for now, you should be fine with the new image. I am emailing it back to you.

Larry

embedded deployment sql server express

Hi,my problem is the following

I can not completely understand how to deploy sse with my application

To some degree I understand the explaning in Mikes Documentation

Things I don't get:

1)Do I not check the prerequisite server express because when I did and run the setup.exe that I build the thing that happens is that the sql package gets unpacked over and over along with a little message that it's taking a little longer then expected. I gues this is the fallpit where the actual setup.exe for sse is nothing being done with hence the wrapper.

A quote from Mikes document "If the VS Bootstrapper isn't flexible enough for you then". Well, I don't know what I'am doing wrong but it doesn't work at all. I had no problem with the other prerequisites (Framework, installer)

Back to the first question: if so do I manually add the SQLEXP.EXE (downloaded from the internet) or is it the sqlexpr32.exe in the same folder as the setup.exe for the application?

2) How is the wrapper invoked? I don't see that mentioned. I thought when you start the application itself, but that hardly seems logical.

Please anyone, give me some clear directions or additional expanatory

Thanks,

Richard

Hi Richard,

I've never heard of the problem you are encountering where the package gets unpacked over and over. You should test if this is specifically related to how the VS Bootstrapper is calling the package by trying to manually install SQL Express on the problem computer. Try copying the SQLEXPR32.EXE file from the folder where you setup.exe lives to the computer and just double-click on it directly to do a manual install.

Is this problem happening on more than one computer? This seems like it is going to be machine specific and is related to some configuration on the computer that we don't know about. Test your installation on a few other computers to see if the problem can be reproduced.

As far as calling the wrapper, normally the wrapper is what you run and it calls other things. Basically, a wrapper would call the SQL Express installation and then it would call the installation of your custom application. The wrapper replaces your current setup.exe program, which is actuall a wrapper as well. I don't think you need to write a customer wrapper since the problem here is how the SQL installer is executing, you need to figure out if the SQL installer problem is machine specific or not first.

Mike

|||

thanks for the reply,

on it's own it installed fine, but now I'am in the process of uninstalling it and I can't seem to get rid of it. ADD/REMOVE progams doesn't work. Any suggestions?

Anyway I'am going to assume that the deployment is suppose to work fine like you said. That's why I go forward and ask you the question how you can make the prerequisites do a silent install. In particulary the sse. I don't realy grasp the concept off passing arguments to the setup program. How and from where is that code beiing executed?

Before I am going to ask you the shirt of your back I wanted to know what a good book is to learn the concepts of working with sse and a desktop application. Would you suggest ADO.net the core essentials from microsoft press?

Richard

|||

as I stated in my last reply, I deployed my application to my newly installed xp pro laptop

Now, that I want to testdrive my database application I get this error:

An attempt to attach an auto-named database file c:/program files........................\MyDB.mdf failed. A database with the same name exists, or specified file can not be opened, or it is located on UNC share.

This is what I read in my app.config file;

<connectionStrings>

<add name="MasterDetail.My.MySettings.MyDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDB.mdf;Integrated Security=True;User Instance=True"

providerName="System.Data.SqlClient" />

</connectionStrings>

What could I be doing wrong?

Richard

|||

Richard777 wrote:

I can't seem to get rid of it. ADD/REMOVE progams doesn't work. Any suggestions?

Odd, it's always worked for me. SQL Server uses a single ARP entry for all copies of SQL Server 2005, this includes multiple Editions and Instances. You need to ensure that you uncheck all the components you wish to remove once you've selected the instance you want to remove. There are also some components that have to be removed separately; I recall that the Setup Components are one of them, but I can't recal the others.

Richard777 wrote:

Anyway I'am going to assume that the deployment is suppose to work fine like you said. That's why I go forward and ask you the question how you can make the prerequisites do a silent install. In particulary the sse. I don't realy grasp the concept off passing arguments to the setup program. How and from where is that code beiing executed?

If you are using ClickOnce to deploy SSE it should already be doing a quite install for the prerequisites. The arguments for each prerequsite are part of the manifest for that prerequiste that is installed by VS. If you are trying to write your own command line you need to use the /qn argument to cause a quite install. There is more information about configuring SSE during install in the FAQ that you can find at the top of this forum.

Richard777 wrote:

Before I am going to ask you the shirt of your back I wanted to know what a good book is to learn the concepts of working with sse and a desktop application. Would you suggest ADO.net the core essentials from microsoft press?

I've not read that book specifically. I have been through part of ADO.NET 2.0 Step by Step and it seems alright. There are also many learning videos available for free on the Microsoft web site, start here (C# or VB.NET) to see if there is anything interesting to you. You might also be interested in the ADO.NET sections of the MSDN Library, which is here.

Mike

|||

Is there anywhere we can get a description of "the manifest for that prerequiste that is installed by VS"

I would like to specify the ADDLOCAL and SQL Signon stuff. Do you have any examples of how to make and include a manifest for these things.

Thanks

Ciaran

|||

Hi Ciaran,

There are a number of documents on MSDN that discuss the Bootstrapper:

http://msdn2.microsoft.com/en-us/library/aa730839(vs.80).aspx
http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx
http://msdn2.microsoft.com/en-us/library/ms229223(VS.80).aspx
http://msdn.microsoft.com/msdnmag/issues/04/10/bootstrapper/

Those documents will tell you enough to read the manifests that are installed by VS, we don't have specific documentation on the individual manifests, but they're XML, so they're pretty much self documenting.

Mike

Email Subscriptions in Sql Server 2000 Reporting Services

Hi,

I have changed my Reporting services from Windows Security to Forms Security. When I deploy reports on the local SQL server, a windows pops up. This windows requires my username and password for the report server. After I input them, everything works fine.

However, When I deploy reports to the above server from the different SQL server located on a different computer, the windows always pops up, although I type the same username and same password. Any ideas?

Thanks a lot.Is this a Windows dialog box from IE? If so, have you enabled anonymous access to the ReportServer and Reports virtual directories in the IIS management console?This is one of the pre-requisites for making forms authentication work.

Thanks
Tudor|||Hi,

Yes, I have already changed them on the computer where my reporting server is located. In fact, I have succeeded in implementing Forms security locally. Like what I described in my question post, after my inputing username and password, local deploying is fine. But when I deploy from another computer, after my inputer the same username and password, the poped-up windows is still there.

Moreover, I also encountered another problem. When email-subscription works under windows security, but it doesn't work under forms security. The error is "Object reference not set to an instance of an object."

Any ideas about them?

Thanks a lot.|||Urgent. any ideas?|||

Check whether the error comes from the (modified) sample code. For instance the sample implementation of GetUserInfo checks for the existence of the HttpContext and returns null if it's not present.
If you have changed that, it would be possible that it could fail when running the report as part of a subscription.

Thanks
Tudor

|||How do you enable anonymous access to the ReportServer? I have an application that references the URL of the report. It is also prompting for credentials. I would really not like to pass the login and password through. Currently we are using one standard user name and password.

Thanks in advance!|||You enable anonymous in the IIS settings. Note, security will effectively be disabled at this point.|||I received a differnent error while using the Forms Extension with SQL REporting Services 2005 when trying to use email subscriptions. The error I received is "

The Forms extension failed to read its configuration settings from the RSReportServer.config configuration file. The extension is not available to users."

Any ideas

Thanks

|||

Hi ,

I have configured SMTP server and i have done email subscription to particular customer called "tbs".The report generates daily at 9:00pm and report will be sent to customer's email.But,if the report doesnot contain any Records,the report should not be delivered to Customer.

Could you be able to guide me and suggest me .

Thanks,

Jayaram

Either a connection cannot be made to the .\sql2005 server, or Analysis Services is not running

I get this error when trying to deploy a Analysis Services Project. I don't have the cube defined yet. I did have sql 2000 and sql 2005 installed on the same machine at one point, but I've since uninstalled them both and reinstalled only sql 2005.

Error 1 Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the '.' server. Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the '.' server. Either a connection cannot be made to the .\sql2005 server, or Analysis Services is not running on the computer specified. Errors in the metadata manager. An error occurred when loading the Tbl PM Project dimension, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\mbn_gargle.0.db\Tbl PM Project.4.dim.xml'. File system error: The following error occurred while writing to the file 'MSSQLServerOLAPService': The event log file is full. . Errors in the metadata manager. An error occurred when loading the MBN Gargle cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\mbn_gargle.0.db\MBN Gargle.15.cub.xml'. File system error: The following error occurred while writing to the file 'MSSQLServerOLAPService': The event log file is full. . 0 0

The problem is actually because it is trying to access a named instance ".\sql2005", which no longer exists. I can see that from this message,

"Either a connection cannot be made to the .\sql2005 server, or Analysis Services is not running on the computer specified."

This happens on brand new projects.

I saw other threads on this subject and the resolutions didn't work. I tried installing the msi file listed on the sql server 2005 packages install (listed on another thread, sorry I don't have the file name handy) but it didn't work.

How do I get around this bug and have SQL look at the only sql instance on the machine, the localhost? The browser service is turned on.

Bob

Check your BI Dev studio project settings. Looks like your project is still trying to deploy to the .\sql2005 instance.

Right click on your project node select "Properties". Click on the "Deployment" node on the left and see what is the value for the Server property. Change it to the "localhost".

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.