how to get parameter fields from ASP .NET to CR

Hi all,
I am writing a ASP .NET program (C#) to view a CR (8.5), and the CR takes a fews parameter fields, how can I use C# API to pass the parameter fields to CR to output the report?

one  more question is, when I view the CR (directly), it will prompt for sql connection username and password, I have made  a  file dsn for the connection, and it prompt out for these info everytime I view the report, can I pass these fields by using ASP.NET API too? Thanks a lot!
ultrafishAsked:
Who is Participating?
 
SevnnConnect With a Mentor Commented:
// Create report instance
private ReportDocument reportDocument = new ReportDocument();

// Assign values to instance
reportDocument.Load(strLocation);  // location of report
reportDocument.SetDatabaseLogon(dbUser,dbPass); // username and password for DB access

// Assign parameters to report
reportDocument.SetParameterValue(paramName,paramValue);
reportDocument.SetParameterValue(paramName,paramValue);
reportDocument.SetParameterValue(paramName,paramValue);

You didn't mention what you want to do with the report.  Your options are to sent it to a viewer, export or print.

// Print
reportDocument.PrintOptions.PrinterName = printerName;
reportDocument.PrintToPrinter(1, false, 0, 0);

// Export - This will require export options to be defined.
reportDocument.Export();






0
 
ultrafishAuthor Commented:
if I have to choose the datasource like
data.dsn
how can I choose it?
thanks~~~
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
ultrafishAuthor Commented:
also, I cannot find the method SetDatabaseLogon and SetParameterValue method
which library has to be imported?

and if I want to print directly, how can I do that? thanks
0
 
SevnnCommented:
I have never needed to choose a dsn.  I did a quick check and ReportDocument has a parameter:

reportDocument.SetDataSource(dsnSource);

Hope this helps.  Thanks for the points ultrafish, this is my first accepted response (also my first day to be a member of EE).  Good Luck.
0
 
SevnnCommented:
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

Is "reportDocument" working at all for you?

What do you mean by printing directly?
0
 
ultrafishAuthor Commented:
is that only exist in 2003 and CR 9.0?
I am using CR 8.5 and VS.NET 2002 only, I don't have the method SetDatabaseLogon() and SetParameterValue()
0
 
SevnnCommented:
Ahhh, You weren't specific about your .Net development environment.  You referenced CR 8.5 but I understand that as a reference to what version the reports were originally written in.  I don't know if CR 8.5 components in 2002 would be similar to the code I posted.  What I posted is from a working program in .Net 2003 with CR 9.0 (Crystal Decisions).  Hopefully mlmcc's link will provide the information you need.
0
All Courses

From novice to tech pro — start learning today.