Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
Loading Crystal Report with parameters - ASP.NET Web forms
Dealy
Jun 21 2016 2:31 AM
334
Reply
Hello,
I'm trying to load a crystal reports with parameters using a stored procedure as a data source.I'm using Visual Studio 2015 with ASP.NET Web forms.
I've created the report (Report1.rpt) using wizard, binding it on my stored procedure. When I was asked to enter the parameters I left it blank.
Here's my code:
protected
void
Button1_Click(object sender, EventArgs e)
{
ReportDocument reportDocument =
new
ReportDocument();
ParameterField paramField =
new
ParameterField();
ParameterFields paramFields =
new
ParameterFields();
ParameterDiscreteValue paramDiscreteValue =
new
ParameterDiscreteValue();
paramField.Name =
"@id"
;
paramDiscreteValue.Value =
"123"
;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramFields.Add(paramField);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
string reportPath = Server.MapPath(
"~/User/Report1.rpt"
);
reportDocument.SetDatabaseLogon(
"user"
,
"pass"
,
"SERVER"
,
"DB1"
,
false
);
reportDocument.Load(reportPath);
CrystalReportViewer1.ReportSource = reportDocument;
1. When I click on the button I get nothing. Any ideas why the report is not loading?
2. If i use the following code I get error in "SERVER\TSQL2012"
reportDocument.SetDatabaseLogon(
"user"
,
"pass"
,
"SERVER\TSQL2012
"
,
"DB1"
,
false
);
Any kind of help would be appreciated!
Thank you in advance.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Terminating web page after 15 minute
Visual Studion 2013 Install In windows 7 SP1