Wednesday, November 17, 2010

Previewing Sitecore Reports with Windows Report Designer


You probably know that you can edit Sitecore OMS reports outside of the browser with Windows based tools from Stimulsoft available for download here.

Our Report Designer Cookbook on SDN documents the following benefits of the Windows based Designer:

  • Create new reports from scratch
  • Use wizards to quickly create new reports
  • Reports load quickly (the client does not run in a browser window)
  • Use a number of keyboard shortcuts (including Ctrl Z)
  • Preview functionality
  • Create complex SQL queries using the Query Builder
  • Import and export formatting styles

It turns out that the “Preview” functionality does not, you may be seeing the following errors when trying to preview:

image

What you need is to copy the following DLLs from your Sitecore bin folder into the bin directory where Report Designer is installed on your workstation (C:\Program Files (x86)\Stimulsoft Reports.Net 2010.2 Trial\Bin):

  • Sitecore.Oracle.dll
  • Sitecore.Analytics.dll

After you do that, you will be able to preview the reports just fine:

image

Happy reporting!