Showing posts with label project. Show all posts
Showing posts with label project. Show all posts

Thursday, March 29, 2012

Embedding picture in local report header

Okay. Simple request. I have a local report in my VS2005 project. I want to embed my company logo in the header. How do I do this? When I put an image item on the page it wants me to put something in the value for this? I've tried sending through a dataset but SSRS can't load data set information into the header! Why is this so complicated? I don't want to embed a dynamic database image, just a static image that will be embedded in my program. Any help on this would be appreciated.

Thanks,

Jon

Drag and drop an image control to the page header. Select embedded image. Click New image. Select the image that you want to embed. Then click finish. Build and deploy the report. Voila!

|||

This works fine for .rdl files. For me, the image wizard does not come up for .rdlc files. Does anyone know why this is?

|||

I've noticed this too. That's what prompted my original question. So basically, here is what I've figured out.

1. Click on Reports > Embedded Images.

2. Add your new image, remember what you named it.

3. Add an image to your report.

4. Click on the image.

5. Change the Source property to 'Embedded'

6. Change the value property to the name of your embedded image.

That's it! I'm still not sure why the wizard doesn't work.

Tuesday, March 27, 2012

Embedded Database or runtime solution

Hello,
Im doing research for my company for a project we are about to start, but the more I find, the more Im confusing myself. Maybe someone would be so nice to help me a little.

We need a database solution, either licensing (ISV) or i think maybe an embedded database. if its licensing, its not a problem, but after research, im thinking licensing would be a waste of time or too much and theire not enough information to go by just that.

Problem: Need to develop software for a client where there will be around 300 users using the system (not all at once neccisarrily). We are creating this software for them and they want to re-sell it after completion, but they do not want to make their customers purchase a database for the purchase of their software. (because of all types of licensing). We need the database RUNTIME to run on the customers machine to make the software work.

Is there a RUNTIME license for Independant-Software-Vendor(IVS) for redistribution? or would it make sense to embed a database ( for example, the free edition of sql server;embeeded feature :), or maybe firebird embedded database?) We are developing in Visual Studio 2005.

This might sound confusing, thats where im at. For those of you with more experience, hopefully you understand what im talking about.

Thank you. I have 2 days to find a solution. Ill continue looking and post in thread if i find anything new or clearify my problem.You've probably already had to turn your assignment in, but you've got a bunch of choices. The problem is that licensing is like playing pickup sticks with eels. They're slippery, they often move on their own, and they're tough to stack at the best of times.

-PatP

Friday, March 9, 2012

Email Alert

I'm trying to develop a email alert feature on my project. I was trying to approach with SQL trigger wich I think is the best option. Basically, when a new record is inserted into ad table, a email alert goes to peolpe who selected to receive alert wehen certain conditions are met. What would be the best approach? any examples?
ThanksThat sounds a lot likeSQL Server Notification Services, a free download if you are using SQL Server.
|||Thanks for the reply. Is MS Notification Services SP1 what I need?

Sunday, February 19, 2012

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.