Search code examples
reporting-servicescrystal-reports

Font size differences when converting Crystal reports to SSRS


When converting Crystal reports to SSRS reports I can specify the exact same font and size, but the resulting text is larger in SSRS (when viewing either on the web or as a PDF). I understand that each reporting tool has its own engine and may simply interpret the same information differently (Social.MSDN: Same Font looks different in Crystal Report and SSRS report).

What is the best way to match font size when converting from Crystal reports to SSRS reports? Is there a conversion formula (e.g., SSRS fonts should be 90% of Crystal report size) or setting in SSRS to change how fonts are interpreted (i.e., scale, not zoom)?

Additional info: I am already aware that an overall zoom can be set for SSRS web viewing (SSRS Report Manager set default zoom level), but this reducing the entire page size (not just the elements on the page). I'm also aware that Crystal reporting can cause fonts to be smaller when exporting to PDF (Font size is decreased when exporting Crystal Report to PDF).

Example: web view of SSRS and Crystal reports (8pt Arial font) https://dl.dropboxusercontent.com/u/30773527/SSRSvCrystalExample.PNG

(I apologize I can't embed the image--I don't have enough reputation points yet)


Solution

  • I ended up making my SSRS fonts 1pt smaller than the Crystal reports. This isn't a perfect solution, although the size is very close the spacing is still slightly off.

    Example: longer text to show spacing difference https://dl.dropboxusercontent.com/u/30773527/FontChangeSSRS.PNG