For the purposes of testing I am running Report Builder 3 against 2008R2 SP1 reporting servers. The version of SharePoint I'm using to integrate with is 2007 (with SP2). To browse the website I'm using Internet Explorer 9.
UPDATE (from Microsoft): The lowercasing behaviour (documented below) is a "known bug" (108596) which will be resolved in a "future release". Appending the ".rdl" extension is a feature of SharePoint and as such is "as intended" behaviour. Bugs are fixed based on the number of users affected so if you want it fixed you need to raise it with Microsoft.
Writing The Test Report
Let's start with a fairly simple report;
|Report Builder 3: New Report (Using Wizard)|
Right-click on the "Click to add title" at the top of the screen;
|Report Builder 3: Expression Dialog (using Globals!ReportName)|
|Report Builder 3: Showing &ReportName as Report Title|
|Report Builder 3: Showing Report GUID|
This is your reports GUID. As you haven't saved the report yet it doesn't have a formal name so the expression evaluates to the GUID.
Saving The Report To Reporting ServersSave the Report to a native (stand-alone) server using the name "ReportName Test Report" and click refresh;
|Report Builder 3: Native-Mode Report Title|
|Report Builder 3: SharePoint Integrated-Mode Report Title|
Both of these tests were running the report in "Report Builder" - this is usually a pretty good indicator of how the report will look in live but it's important to test the report in a web browser as well.
Looking at the native mode report in Internet Explorer (I'm using IE9) gives you;
|Native-Mode Report in IE9|
|SharePoint Integrated-Mode Report in IE9|
Preview the report in Report Builder;
|Report Builder 3: Migrated Report|
|Migrated Report in IE|
Result Summary for ReportName "ReportName Test Report";
- &ReportName remains "ReportName Test Report" in all circumstances
- &ReportName has ".rdl" added as a suffix in all circumstances
- If the report has been migrated from Non-Integrated Mode @ReportName is converted to lowercase when viewing in a browser only (Report Builder is unaffected)