Databases
StackOverflow2013
Postsdbo
POVBCRLF carriage return error in SSRS
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVBCRLF carriage return error in SSRS
    primarykey
    data
    text
    <p>I am using SQL Server 2012 and Visual Studio 2010</p> <p>I recently upgraded our software which uses SSRS for reporting. All reports were working fine prior to the upgrade. Since the upgrade I now see VBCRLF appearing in the report output. I want to remove this from the output.</p> <p>Here is how the report design looks in Visual Studio</p> <p><img src="https://i.imgur.com/2pTmeUO.jpg" alt="1"></p> <p>Before upgrade (note the headers)</p> <p><img src="https://i.imgur.com/8389EEl.jpg" alt="1"></p> <p>After the upgrade with VBCRLF problem appearing in the table headers month to date etc..</p> <p><img src="https://i.imgur.com/3Uw3Ay3.jpg" alt="1"></p> <p>Here are the underlying rdl's if they are helpful. This report has a parent and subreport. The charts and table are in the subreport</p> <p><a href="https://dl.dropboxusercontent.com/u/29851290/PortfolioSummary.rdl" rel="nofollow noreferrer">https://dl.dropboxusercontent.com/u/29851290/PortfolioSummary.rdl</a> <a href="https://dl.dropboxusercontent.com/u/29851290/PortfolioSummarySubreport.rdl" rel="nofollow noreferrer">https://dl.dropboxusercontent.com/u/29851290/PortfolioSummarySubreport.rdl</a></p> <p>Any help is appreciated.</p> <p>***UPDATE</p> <p>I see in the updated Stored Procedure the company added VBCRLF to indicate carriage returns, but as you see instead of inserting a carriage return, the report shows VBCRLF. Any idea how to tell SSRS when it sees VBCRLF in the code of the underlying sproc to make that a carriage return?</p> <p>sample code</p> <pre><code>-- Time Period Variables declare @DTD nvarchar(255) = 'Day VBCRLF To Date' declare @DTDAnn nvarchar(255) = 'Annualized VBCRLF Day VBCRLF To Date' declare @ITD nvarchar(255) = 'Inception VBCRLF To Date' declare @ITDAnn nvarchar(255) = 'Annualized VBCRLF Inception VBCRLF To Date' </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJay C
    1. USJay C
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload