Missing data in ssrs report

I have an SSRS report that has an error when called from within a C# application, but the error is not present when displayed within BIDS. Two screenshots attached. The error is that there is missing data in the 3rd row. The first and 2nd last columns in the third row appear correctly in both, but there is missing data in between. This 3rd row is of cumulative data, except for the 39401 and 200525 which are literals.

Good:

Error:


using System;
public partial class Admin_SYSReport : System.Web.UI.Page
{
    private String sysNumber="000000000";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            sysNumber = Request.QueryString[("sysNumber")];
            PrepareReport();
        }
    }
    private void PrepareReport()
    {
        SYSCoverSheetReportViewer.Reset();
        SYSCoverSheetReportViewer.ShowToolBar = true;
        SYSCoverSheetReportViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
        SYSCoverSheetReportViewer.ServerReport.ReportServerCredentials = new Transactions.Admin.ReportServerNetworkCredentials();
        SYSCoverSheetReportViewer.ServerReport.ReportServerUrl = new Uri("http://---------/ReportServer");
        SYSCoverSheetReportViewer.ServerReport.ReportPath = "/SYSCoverSheet/SYSCoverSheet";

        FillParameters(SYSCoverSheetReportViewer.ServerReport);
        SYSCoverSheetReportViewer.ServerReport.Refresh();
    }
    private void FillParameters(Microsoft.Reporting.WebForms.ServerReport report)
    {
        var rpArray = new System.Collections.Generic.List<Microsoft.Reporting.WebForms.ReportParameter>();
        rpArray.Add (new Microsoft.Reporting.WebForms.ReportParameter("SYSNumber", sysNumber));
        rpArray.Add(new Microsoft.Reporting.WebForms.ReportParameter("LongDescription", "This is a long description"));
        report.SetParameters(rpArray);
    }
 }
LVL 1
allelopathAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
I don't use SSRS but have seen similar things in WebI and Crystal.

mlmcc
0
 
mlmccCommented:
If you make the column wider does the data display?

mlmcc
0
 
allelopathAuthor Commented:
That's good thinking, but I had already tried that and it is not the problem.
0
 
allelopathAuthor Commented:
Figured it out, sort of. Some sort of rdl.data cache problem.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.