Solved

Missing data in ssrs report

Posted on 2013-06-06
4
631 Views
Last Modified: 2013-06-07
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);
    }
 }
0
Comment
Question by:allelopath
  • 2
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39228870
If you make the column wider does the data display?

mlmcc
0
 
LVL 1

Author Comment

by:allelopath
ID: 39229002
That's good thinking, but I had already tried that and it is not the problem.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39229023
I don't use SSRS but have seen similar things in WebI and Crystal.

mlmcc
0
 
LVL 1

Author Comment

by:allelopath
ID: 39229720
Figured it out, sort of. Some sort of rdl.data cache problem.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question