Solved

Missing data in ssrs report

Posted on 2013-06-06
4
639 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 101

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 101

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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

717 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