Font size differences when converting Crystal reports to SSRS

1
votes

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)

1
reporting-servicescrystal-reports
How are you converting the reports to ssrs? – aMazing
Mostly manually—opening the Crystal report in Crystal Viewer or Visual Studio and recreating the report in SSRS. With things like font size and the stored proc I can copy and paste directly across, but other visual elements are created again manually in SSRS. – Sean

1 Answers

0
votes

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