Crystal Reports on ASP.net and c#
I have a report that when first created with no parameters runs in a reportviewer on VS2017.
As soon as a parameter is introduced it asks for credentials. If the parameter is removed it still asks for credentials.
I have the following code in my aspx file but it still asks for credentials
TableLogOnInfos TableLogOnInfos = new TableLogOnInfos();
TableLogOnInfo TableLogOnInfo = new TableLogOnInfo();
ConnectionInfo ConnectionInfo = new ConnectionInfo();
Tables Tables;
ConnectionInfo.ServerName = "odbc17";
ConnectionInfo.DatabaseName = "Unisports";
ConnectionInfo.UserID = "Bill@unisports";
ConnectionInfo.Password = "xxxxxxxxxxx")";
ReportDocument report = new ReportDocument();
string reportPath = Server.MapPath("CrystalReport1.rpt");
report.Load(reportPath);
Tables = report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in Tables)
{
TableLogOnInfo = table.LogOnInfo;
TableLogOnInfo.ConnectionInfo = ConnectionInfo;
table.ApplyLogOnInfo(TableLogOnInfo);
}
CrystalReportViewer1.RefreshReport();
CrystalReportViewer1.ReportSource = report;
}
I am still being requested for credentials. I have been spending about 4 hours a day for the past week or so and getting nowhere so any help will be gratefully received.
Oh the server name is a DSN, when I first put the server name in it kept coming back with the DSN name in the server name field, the 17 just indicates to me that it is windows driver 17 for SQL Server.
c# asp.net crystal-reports visual-studio-2017
asked Nov 21 '18 at 22:30
BillBill
12
add a comment |
I have a report that when first created with no parameters runs in a reportviewer on VS2017.
As soon as a parameter is introduced it asks for credentials. If the parameter is removed it still asks for credentials.
I have the following code in my aspx file but it still asks for credentials
TableLogOnInfos TableLogOnInfos = new TableLogOnInfos();
TableLogOnInfo TableLogOnInfo = new TableLogOnInfo();
ConnectionInfo ConnectionInfo = new ConnectionInfo();
Tables Tables;
ConnectionInfo.ServerName = "odbc17";
ConnectionInfo.DatabaseName = "Unisports";
ConnectionInfo.UserID = "Bill@unisports";
ConnectionInfo.Password = "xxxxxxxxxxx")";
ReportDocument report = new ReportDocument();
string reportPath = Server.MapPath("CrystalReport1.rpt");
report.Load(reportPath);
Tables = report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in Tables)
{
TableLogOnInfo = table.LogOnInfo;
TableLogOnInfo.ConnectionInfo = ConnectionInfo;
table.ApplyLogOnInfo(TableLogOnInfo);
}
CrystalReportViewer1.RefreshReport();
CrystalReportViewer1.ReportSource = report;
}
I am still being requested for credentials. I have been spending about 4 hours a day for the past week or so and getting nowhere so any help will be gratefully received.
Oh the server name is a DSN, when I first put the server name in it kept coming back with the DSN name in the server name field, the 17 just indicates to me that it is windows driver 17 for SQL Server.
c# asp.net crystal-reports visual-studio-2017
asked Nov 21 '18 at 22:30
BillBill
12
add a comment |
I have a report that when first created with no parameters runs in a reportviewer on VS2017.
As soon as a parameter is introduced it asks for credentials. If the parameter is removed it still asks for credentials.
I have the following code in my aspx file but it still asks for credentials
TableLogOnInfos TableLogOnInfos = new TableLogOnInfos();
TableLogOnInfo TableLogOnInfo = new TableLogOnInfo();
ConnectionInfo ConnectionInfo = new ConnectionInfo();
Tables Tables;
ConnectionInfo.ServerName = "odbc17";
ConnectionInfo.DatabaseName = "Unisports";
ConnectionInfo.UserID = "Bill@unisports";
ConnectionInfo.Password = "xxxxxxxxxxx")";
ReportDocument report = new ReportDocument();
string reportPath = Server.MapPath("CrystalReport1.rpt");
report.Load(reportPath);
Tables = report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in Tables)
{
TableLogOnInfo = table.LogOnInfo;
TableLogOnInfo.ConnectionInfo = ConnectionInfo;
table.ApplyLogOnInfo(TableLogOnInfo);
}
CrystalReportViewer1.RefreshReport();
CrystalReportViewer1.ReportSource = report;
}
I am still being requested for credentials. I have been spending about 4 hours a day for the past week or so and getting nowhere so any help will be gratefully received.
Oh the server name is a DSN, when I first put the server name in it kept coming back with the DSN name in the server name field, the 17 just indicates to me that it is windows driver 17 for SQL Server.
c# asp.net crystal-reports visual-studio-2017
asked Nov 21 '18 at 22:30
BillBill
12
I have a report that when first created with no parameters runs in a reportviewer on VS2017.
As soon as a parameter is introduced it asks for credentials. If the parameter is removed it still asks for credentials.
I have the following code in my aspx file but it still asks for credentials
TableLogOnInfos TableLogOnInfos = new TableLogOnInfos();
TableLogOnInfo TableLogOnInfo = new TableLogOnInfo();
ConnectionInfo ConnectionInfo = new ConnectionInfo();
Tables Tables;
ConnectionInfo.ServerName = "odbc17";
ConnectionInfo.DatabaseName = "Unisports";
ConnectionInfo.UserID = "Bill@unisports";
ConnectionInfo.Password = "xxxxxxxxxxx")";
ReportDocument report = new ReportDocument();
string reportPath = Server.MapPath("CrystalReport1.rpt");
report.Load(reportPath);
Tables = report.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table table in Tables)
{
TableLogOnInfo = table.LogOnInfo;
TableLogOnInfo.ConnectionInfo = ConnectionInfo;
table.ApplyLogOnInfo(TableLogOnInfo);
}
CrystalReportViewer1.RefreshReport();
CrystalReportViewer1.ReportSource = report;
}
I am still being requested for credentials. I have been spending about 4 hours a day for the past week or so and getting nowhere so any help will be gratefully received.
Oh the server name is a DSN, when I first put the server name in it kept coming back with the DSN name in the server name field, the 17 just indicates to me that it is windows driver 17 for SQL Server.
c# asp.net crystal-reports visual-studio-2017
c# asp.net crystal-reports visual-studio-2017
asked Nov 21 '18 at 22:30
BillBill
12
asked Nov 21 '18 at 22:30
BillBill
12
edited Nov 21 '18 at 22:37
Bill
asked Nov 21 '18 at 22:30
BillBill
12
asked Nov 21 '18 at 22:30
BillBill
12
asked Nov 21 '18 at 22:30
BillBill
12
12
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%2f53421340%2fcrystal-reports-on-asp-net-and-c-sharp%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%2f53421340%2fcrystal-reports-on-asp-net-and-c-sharp%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
