Thursday, August 23, 2012

SSRS SQL Server Reporting Services Export As JPEG (JPG)

I noticed that SSRS for SQL 2008 R2 was missing the option to export in JPEG formats. The reason for this is that JPEG formats don't and will not support Multi-page reports.

however If you are just exporting a nice simple graphic you can add support for exporting the JPEG formats.


  • Logon to the SSRS reporting server 
  • Locate the rsreportserver.config and edit it
  • Under the Configuration/Extensions/Render section 
  • Add 
&ltExtension Name="IMAGE (JPEG)" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"&gt
&ltOverrideNames&gt
&ltName Language="en-US"&gtImage (JPEG)&lt/Name&gt
&lt/OverrideNames&gt
&ltConfiguration&gt
&ltDeviceInfo&gt
&ltOutputFormat&gtJPEG&lt/OutputFormat&gt
&lt/DeviceInfo&gt
&lt/Configuration&gt
&lt/Extension&gt
  • Restart the SQL reporting service 
For more information see this thread on social technet


If you find this article useful please leave me a comment or click on an ad to show your support.

Monday, August 13, 2012

Number of days until XP support expires


Plug this into excel and it will tell you the number of days until XP support expires

=NETWORKDAYS(TODAY(),DATE(2014,4,8))

If you find this article useful please leave me a comment or click on an ad to show your support.

Wednesday, July 25, 2012

Office 365 Preview open to public

Microsoft has made Office 365 available to the public.. but instead of writing up about it I'll let Yoni from Fastrack to the explaining.

http://www.fastracktechnology.com.au/blog/microsoft-office-365-preview-opens-to-the-public

If you find this article useful please leave me a comment or click on an ad to show your support.

Thursday, July 19, 2012

Will a mandatory assignment re-run if I change the program command line?

Say you completed a mandatory deployment of an application to your environment. Now you want to change the command line it runs without causing it to re-run on all computers. Can this be done?

Yes.

When the configmgr program ran on the PC it put a flag in the execution history that the package ID was successfully run on that PC. This execution history is based on the Package ID and the 'program name' that it ran. It is not based on the actual 'command line' it executed.

Changing the program command line for an existing package will not cause the program  to re-run on clients that have already successfully completed mandatory program.

If you find this article useful please leave me a comment or click on an ad to show your support.

Thursday, July 05, 2012

Solver crashes Excel when TM1 is loaded.

IBM know it's a bug.

Not so keen on the solution though




http://www-01.ibm.com/support/docview.wss?uid=swg1PM60242

Our solution: Disable TM1 while using solver. Wait for IBM to fix TM1

If you find this article useful please leave me a comment or click on an ad to show your support.