You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server
Data Tools (SSDT).
The report contains tables, images, charts, page breaks, gauges, and indicators.
You need to ensure that the reports can be exported to Microsoft Excel and PDF formats
and do not have any layout issues.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
A.
During development, preview the report in the SSDT preview tab to validate its default
HTML rendering.
B.
After development, test the report in a web browser.
C.
Increase the value of the Width property of the report body.
D.
During development, preview the report in the SSDT preview tab and export it to the other
rendering formats.
Getting the best results for exported reports is often an iterative process; you author and preview the report in Report Builder or Report Designer, export the report to the preferred format, review the exported report, and then make changes to the report.
https://technet.microsoft.com/en-us/library/ee210530(v=sql.110).aspx
Rendering may cause different surprises after exporting. No other way than test it multiple times, so “D” is correct. When something goes wrong than we need sometimes increase the width or other parameters, but we start with the test.