?
Solved

Missing data in ssrs report

Posted on 2013-06-06
4
Medium Priority
?
655 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 2000 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month13 days, 12 hours left to enroll

801 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