Hi everyone,
I recently upgraded to the latest service pack and patch for Crystal Reports 2020 and have also installed Crystal Reports Server. I've developed a program in Visual Studio that attempts to fetch a report created in Crystal Reports 2020, but I'm encountering several errors.
I'm uncertain whether the problem stems from the necessity to author the report in Crystal Reports Enterprise. My research indicates this was a requirement in older versions, but I haven't found conclusive information regarding the 2020 version. Additionally, I will share my Visual Studio code for further insight.
Any guidance or suggestions would be greatly appreciated.
<error>
<error_code>CRR 00107</error_code>
<message>The requests received by the Report Processing Server have the format of an old version. Please ask your system administrator to upgrade. (CRR 00107, )</message>
</error>
Failed to create report instance. Status code: InternalServerError
Response: <?xml version="1.0" encoding="UTF-8" standalone="no"?>
<error>
<error_code>CRR 00107</error_code>
<message>The requests received by the Report Processing Server have the format of an old version. Please ask your system administrator to upgrade. (CRR 00107, )</message>
</error>
Here is my program
using System;
using System.Linq;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using System.Threading.Tasks;
using System.Xml.Linq;
class Program
{
static readonly HttpClient client = new HttpClient();
static async Task Main(string[] args)
{
string baseUri = "http://Endpoint:8080/XXXX";
string username = "Username";
string password = "Password";
string reportId = "7087";
int pickslipNumber = 615710;
string logonToken = await AuthenticateAndGetLogonToken(baseUri, username, password);
if (string.IsNullOrEmpty(logonToken))
{
Console.WriteLine("Authentication failed.");
return;
}
Console.WriteLine($"Authentication successful. Logon Token: {logonToken}");
string instanceForm = await RetrieveInstanceForm(baseUri, reportId, logonToken);
if (!string.IsNullOrEmpty(instanceForm))
{
string instanceId = await CreateReportInstance(baseUri, reportId, logonToken, instanceForm, pickslipNumber);
if (!string.IsNullOrEmpty(instanceId))
{
Console.WriteLine($"Report instance created successfully. Instance ID: {instanceId}");
}
}
}
static async Task<string> AuthenticateAndGetLogonToken(string baseUri, string username, string password)
{
string authUrl = $"{baseUri}/logon/long";
var authPayload = $"<attrs xmlns='http://www.sap.com/rws/bip'>" +
$"<attr name='userName' type='string'>{username}</attr>" +
$"<attr name='password' type='string'>{password}</attr>" +
$"<attr name='auth' type='string' possibilities='secEnterprise,secLDAP,secWinAD'>secEnterprise</attr>" +
$"</attrs>";
HttpContent content = new StringContent(authPayload, Encoding.UTF8, "application/xml");
var response = await client.PostAsync(authUrl, content);
if (response.IsSuccessStatusCode)
{
var data = await response.Content.ReadAsStringAsync();
return ExtractLogonToken(data);
}
return null;
}
static string ExtractLogonToken(string xmlResponse)
{
var xDoc = XDocument.Parse(xmlResponse);
XNamespace ns = "http://www.sap.com/rws/bip";
var logonTokenElement = xDoc.Descendants(ns + "attr").FirstOrDefault(x => x.Attribute("name")?.Value == "logonToken");
return logonTokenElement?.Value;
}
static async Task<string> RetrieveInstanceForm(string baseUri, string reportId, string logonToken)
{
string url = $"{baseUri}/infostore/{reportId}/rpt/instance";
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Add("X-SAP-LogonToken", $"\"{logonToken}\"");
var response = await client.GetAsync(url);
if (response.IsSuccessStatusCode)
{
string instanceForm = await response.Content.ReadAsStringAsync();
Console.WriteLine("Instance Form: " + instanceForm);
return instanceForm;
}
else
{
Console.WriteLine($"Failed to retrieve instance form. Status code: {response.StatusCode}");
Console.WriteLine($"Response: {await response.Content.ReadAsStringAsync()}");
return null;
}
}
static async Task<string> CreateReportInstance(string baseUri, string reportId, string logonToken, string instanceForm, int pickslipNumber)
{
string url = $"{baseUri}/infostore/{reportId}/rpt/instance";
XDocument instanceDoc = XDocument.Parse(instanceForm);
XNamespace ns = "http://www.w3.org/2005/Atom";
var pickslipNumberEntry = instanceDoc.Descendants(ns + "entry")
.FirstOrDefault(e => e.Element(ns + "id")?.Value == "PickslipNumber");
if (pickslipNumberEntry != null)
{
var contentElement = pickslipNumberEntry.Element(ns + "content");
if (contentElement != null)
{
var attrsElement = contentElement.Element(ns + "attrs");
if (attrsElement != null)
{
var valueAttr = attrsElement.Element(ns + "attr");
if (valueAttr != null)
{
valueAttr.SetValue(pickslipNumber);
}
else
{
attrsElement.Add(new XElement(ns + "attr", new XAttribute("name", "value"), new XAttribute("type", "number"), pickslipNumber));
}
}
else
{
contentElement.Add(new XElement(ns + "attrs", new XElement(ns + "attr", new XAttribute("name", "value"), new XAttribute("type", "number"), pickslipNumber)));
}
}
}
string requestBody = instanceDoc.ToString();
HttpContent content = new StringContent(requestBody, Encoding.UTF8, "application/xml");
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Add("X-SAP-LogonToken", $"\"{logonToken}\"");
Console.WriteLine("Request URL: " + url);
Console.WriteLine("Request Body: " + requestBody);
var response = await client.PostAsync(url, content);
Console.WriteLine("Response Status Code: " + response.StatusCode);
Console.WriteLine("Response Content: " + await response.Content.ReadAsStringAsync());
if (response.IsSuccessStatusCode)
{
string instanceId = await response.Content.ReadAsStringAsync();
return instanceId;
}
else
{
Console.WriteLine($"Failed to create report instance. Status code: {response.StatusCode}");
Console.WriteLine($"Response: {await response.Content.ReadAsStringAsync()}");
return null;
}
}
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.