Hi Crystal Experts,
I just chatted with a customer who is getting the following error messages. After arduous research through the blogs, I could not confirm a solution so I decided to post a new thread. Forgive me if this is already mentioned somewhere else. I understand there can be different combinations of issues.
The customer's local machine is running on Windows 7. Their Server OS is Windows XP. They are running CR 2008 and VS 2012 as the IDE.
The issue is that the reports work locally on his machine but once the files are uploaded to the server, the reports come back blank. I've included a snapshot from the customer.
Attempted solutions: Installation of SP16 64 bit but problem still remains.
Can anyone shed some light on this for me please?
All the best,
Valerie Rose Cadag
Customer Care Specialist
SAP Americas, Phoenix AZ
Request clarification before answering.
Well this is my code to call my reports
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Net;
using System.Text.RegularExpressions;
using System.Web;
using System.Web.Script.Serialization;
using System.Web.SessionState;
using Newtonsoft.Json;
using System.Windows.Forms.DataVisualization.Charting;
using OfficeOpenXml;
using SCFramework;
using System.Web.UI.WebControls;
using System.Globalization;
using System.IO;
using System.Web.Configuration;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using SmartCap_2._0.Forms.Checks.Tools;
using System.Collections;
namespace SmartCap_2._0.Forms.Checks.Report
{
public partial class CrystalReportToView : System.Web.UI.Page
{
public string check_IDs = "";
public string paymentDesc = "";
protected void Page_Load(object sender, EventArgs e)
{
string connStr = ConfigurationManager.ConnectionStrings["SmartCap"].ToString();
UserInfo user = (UserInfo)Session["UserInfo"];
//string name = user.ToString();
string parameters = HttpContext.Current.Request.Params["params"];
if (!string.IsNullOrEmpty(parameters))
{
JavaScriptSerializer jss = new JavaScriptSerializer();
ReloadRequest rr = jss.Deserialize<ReloadRequest>(Server.UrlDecode(parameters));
check_IDs = rr.Params.Param;
paymentDesc = rr.Params.Param2;
}
if (!IsPostBack)
{
ReportViewPCP();
//LogActivity.Log_Action(connStr, user.UserName, "Checks Template", "Generate Report", Request.Browser.Browser, Request.UserHostAddress.ToString(), "RV", new FileInfo(this.Request.Url.LocalPath).Name);
}
}
private void ReportViewPCP()
{
DB db = new DB();
string connStr = ConfigurationManager.ConnectionStrings["SmartCap"].ToString();
try
{
string[] array = check_IDs.Split(',');
string comp = "";
for (int i = 0; i < array.Length; i++)
{
array[i] = "'" + array[i] + "'";
comp += array[i] + ",";
}
comp = comp.Remove(comp.Length - 1);
//LOADS REPORT DEPENDING ON PAYMENT DESCRIPTION(INCENTIVE, MEDICAL FUND INCENTIVE, CAPITATION)
if (paymentDesc.ToLower() == "capitation")
{
CrystalReportSource1.Report.FileName = Server.MapPath(@"capitationsReport.rpt");
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"capitationsReport.rpt"));
}
else if (paymentDesc.ToLower() == "incentive")
{
CrystalReportSource1.Report.FileName = Server.MapPath(@"msoIncentivesReport.rpt");
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"msoIncentivesReport.rpt"));
}
else
{
CrystalReportSource1.Report.FileName = Server.MapPath(@"incentivesReport.rpt");
CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"incentivesReport.rpt"));
}
CrystalReportSource1.ReportDocument.SetDatabaseLogon("empty", "empty");
CrystalReportSource1.ReportDocument.SetParameterValue("ID", comp);
CrystalReportViewer1.ReportSource = CrystalReportSource1;
CrystalReportViewer1.DisplayGroupTree = false;
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.ServerName = @"empty";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.UserID = "empty";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.Password = "empty";
CrystalReportViewer1.LogOnInfo[0].ConnectionInfo.DatabaseName = "empty";
CrystalReportViewer1.Zoom(125);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Valerie,
It seems others are having issues also but no idea why so far:
That was for IE 10, so it must be some setting causing the problem, just don't know how to fix it...
Don
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.