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.
Hi Valerie
There is a bit of confusion based on the following:
1) Their Server OS is Windows XP. They are running CR 2008 and VS 2012 as the IDE.
2) Attempted solutions: Installation of SP16 64 bit but problem still remains.
CR 2008 (v. 12.x) is not supported with VS 2012 and SP 16 64 bit would be for "SAP Crystal Reports, Developer Version for Visual Studio .NET" (v. 13.x).
So, we need to clear up the actual version of CR they are using? Also, are you sure the server is WIN XP? Microsoft does not support WIN XP anymore, so....
Additionally, how was the runtime deployed and how was the viewer configured?
Finally, can the customer create a Discussion here, rather than you on their behalf (it will make communication much simpler)?
- Ludek
Senior Support Engineer Product Support, Global Support Center Canada
Follow me on Twitter
Got Enhancement ideas? Use the SAP Idea Place
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.