Crystal Reports changing server causes error
I'm writing some C# code to open a Crystal Report and run it. The report itself was designed against a Dev db so internally that dev db server name is stored in it. The Prod db server has the same everything as dev. In C# I open the code, change the logon data with SetDatabaseLogon() and try to export to stream.
If the db server name is the same as what it was developed against this all works. however, when I change the db server name to production I get ExportToStream() gives me the generic "Object reference not set to an instance of an object". Any ideas on how I can switch the db server while everything else stays the same?
public Stream GetReportStream(string reportName, string exportType, IEnumerable<KeyValuePair<string, string>> rptParams)
{
ReportClass rpt = new ReportClass();
rpt.FileName = Path.Combine(@"P:Temp", reportName + ".rpt");
rpt.Load();
var connections = rpt.DataSourceConnections;
for (var i = 0; i < connections.Count; i++)
{
//rpt.SetDatabaseLogon(connections[i].UserID, "MYPWHERE", connections[i].ServerName, connections[i].DatabaseName); // this sets the info to whatever was already in the db which is the dev server and that works
rpt.SetDatabaseLogon(connections[i].UserID, "MYPWHERE", "PRODDBSERVER", connections[i].DatabaseName);
}
// figure out what type each parameter is and then set it
foreach (var param in rptParams)
{
// is int?
int intParam = 0;
if (int.TryParse(param.Value, out intParam))
{
rpt.SetParameterValue("@" + param.Key, intParam);
continue;
}
// is date?
DateTime dateParam;
if (DateTime.TryParse(param.Value, out dateParam))
{
rpt.SetParameterValue("@" + param.Key, dateParam);
continue;
}
}
// return the report to web client
return rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
}
c# crystal-reports
asked Nov 14 '18 at 20:55
user441521user441521
2,1701457122
add a comment |
I'm writing some C# code to open a Crystal Report and run it. The report itself was designed against a Dev db so internally that dev db server name is stored in it. The Prod db server has the same everything as dev. In C# I open the code, change the logon data with SetDatabaseLogon() and try to export to stream.
If the db server name is the same as what it was developed against this all works. however, when I change the db server name to production I get ExportToStream() gives me the generic "Object reference not set to an instance of an object". Any ideas on how I can switch the db server while everything else stays the same?
public Stream GetReportStream(string reportName, string exportType, IEnumerable<KeyValuePair<string, string>> rptParams)
{
ReportClass rpt = new ReportClass();
rpt.FileName = Path.Combine(@"P:Temp", reportName + ".rpt");
rpt.Load();
var connections = rpt.DataSourceConnections;
for (var i = 0; i < connections.Count; i++)
{
//rpt.SetDatabaseLogon(connections[i].UserID, "MYPWHERE", connections[i].ServerName, connections[i].DatabaseName); // this sets the info to whatever was already in the db which is the dev server and that works
rpt.SetDatabaseLogon(connections[i].UserID, "MYPWHERE", "PRODDBSERVER", connections[i].DatabaseName);
}
// figure out what type each parameter is and then set it
foreach (var param in rptParams)
{
// is int?
int intParam = 0;
if (int.TryParse(param.Value, out intParam))
{
rpt.SetParameterValue("@" + param.Key, intParam);
continue;
}
// is date?
DateTime dateParam;
if (DateTime.TryParse(param.Value, out dateParam))
{
rpt.SetParameterValue("@" + param.Key, dateParam);
continue;
}
}
// return the report to web client
return rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
}
c# crystal-reports
asked Nov 14 '18 at 20:55
user441521user441521
2,1701457122
add a comment |
I'm writing some C# code to open a Crystal Report and run it. The report itself was designed against a Dev db so internally that dev db server name is stored in it. The Prod db server has the same everything as dev. In C# I open the code, change the logon data with SetDatabaseLogon() and try to export to stream.
If the db server name is the same as what it was developed against this all works. however, when I change the db server name to production I get ExportToStream() gives me the generic "Object reference not set to an instance of an object". Any ideas on how I can switch the db server while everything else stays the same?
public Stream GetReportStream(string reportName, string exportType, IEnumerable<KeyValuePair<string, string>> rptParams)
{
ReportClass rpt = new ReportClass();
rpt.FileName = Path.Combine(@"P:Temp", reportName + ".rpt");
rpt.Load();
var connections = rpt.DataSourceConnections;
for (var i = 0; i < connections.Count; i++)
{
//rpt.SetDatabaseLogon(connections[i].UserID, "MYPWHERE", connections[i].ServerName, connections[i].DatabaseName); // this sets the info to whatever was already in the db which is the dev server and that works
rpt.SetDatabaseLogon(connections[i].UserID, "MYPWHERE", "PRODDBSERVER", connections[i].DatabaseName);
}
// figure out what type each parameter is and then set it
foreach (var param in rptParams)
{
// is int?
int intParam = 0;
if (int.TryParse(param.Value, out intParam))
{
rpt.SetParameterValue("@" + param.Key, intParam);
continue;
}
// is date?
DateTime dateParam;
if (DateTime.TryParse(param.Value, out dateParam))
{
rpt.SetParameterValue("@" + param.Key, dateParam);
continue;
}
}
// return the report to web client
return rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
}
c# crystal-reports
asked Nov 14 '18 at 20:55
user441521user441521
2,1701457122
I'm writing some C# code to open a Crystal Report and run it. The report itself was designed against a Dev db so internally that dev db server name is stored in it. The Prod db server has the same everything as dev. In C# I open the code, change the logon data with SetDatabaseLogon() and try to export to stream.
If the db server name is the same as what it was developed against this all works. however, when I change the db server name to production I get ExportToStream() gives me the generic "Object reference not set to an instance of an object". Any ideas on how I can switch the db server while everything else stays the same?
public Stream GetReportStream(string reportName, string exportType, IEnumerable<KeyValuePair<string, string>> rptParams)
{
ReportClass rpt = new ReportClass();
rpt.FileName = Path.Combine(@"P:Temp", reportName + ".rpt");
rpt.Load();
var connections = rpt.DataSourceConnections;
for (var i = 0; i < connections.Count; i++)
{
//rpt.SetDatabaseLogon(connections[i].UserID, "MYPWHERE", connections[i].ServerName, connections[i].DatabaseName); // this sets the info to whatever was already in the db which is the dev server and that works
rpt.SetDatabaseLogon(connections[i].UserID, "MYPWHERE", "PRODDBSERVER", connections[i].DatabaseName);
}
// figure out what type each parameter is and then set it
foreach (var param in rptParams)
{
// is int?
int intParam = 0;
if (int.TryParse(param.Value, out intParam))
{
rpt.SetParameterValue("@" + param.Key, intParam);
continue;
}
// is date?
DateTime dateParam;
if (DateTime.TryParse(param.Value, out dateParam))
{
rpt.SetParameterValue("@" + param.Key, dateParam);
continue;
}
}
// return the report to web client
return rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
}
c# crystal-reports
c# crystal-reports
asked Nov 14 '18 at 20:55
user441521user441521
2,1701457122
asked Nov 14 '18 at 20:55
user441521user441521
2,1701457122
asked Nov 14 '18 at 20:55
user441521user441521
2,1701457122
asked Nov 14 '18 at 20:55
user441521user441521
2,1701457122
asked Nov 14 '18 at 20:55
user441521user441521
2,1701457122
2,1701457122
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53308584%2fcrystal-reports-changing-server-causes-error%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53308584%2fcrystal-reports-changing-server-causes-error%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
