Showing posts with label environment. Show all posts
Showing posts with label environment. Show all posts

Wednesday, March 21, 2012

Image does not display on report

I have a simple report that has nothing but an image. The image is part of the project. The image displays in the VS 2005 dev environment when report is previewed. But when deployed and run on the report server website, it does not display. If the report is print previewed or exported to Excel, the image displays. I've set my browser to have the least security as possible but still to no avail (made the website trusted as well). The server is running SQL Server 2005 SP2. My browser is IE7. Can anyone please help? Thanks.

Found the problem. The report didn't like that the 5.25" x 1.5" image was being fit into a 1.5" x 0.5" area. When I made the image smaller, it was displaying fine. Sorry for the trouble.

Monday, March 12, 2012

im a newbe. please help

i'm turning up a replicated SQL SVR database environment on dedicated hardware. other than the instance name, all database will be exactly the same. my question is, is it possible to export, or copy scheduled jobs from the first database environment to the newly created environment? i'd like to avoid having to recreate all of them, if possible.Generate SQL script from existing job, then execute the script in your new environment.|||Or use DTS (Data transformation services Wizard) , local packages, select the transfer job task then follow the wizard.