how can i display crystal report in button_click? am
working with VS2005..........plz help me
Answer Posted / v
protected void Page_Load(object sender, EventArgs e)
{
_ControlId = Request["ControlId"];
CrystalDecisions.CrystalReports.Engine.Database
crDatabase;
CrystalDecisions.CrystalReports.Engine.Table
crTable;
TableLogOnInfo dbConn = new TableLogOnInfo();
_oRpt = new ReportDocument();
// loading the ItemReport in report document
_oRpt.Load(Server.MapPath("~\\reports") + "\\"
+ "RepsAndWar.rpt");
// getting the database, the table and the
LogOnInfo object which holds login information
crDatabase = _oRpt.Database;
// getting the table in an object array of one item
object[] arrTables = new object[1];
crDatabase.Tables.CopyTo(arrTables, 0);
// assigning the first item of array to crTable by
downcasting the object to Table
crTable =
(CrystalDecisions.CrystalReports.Engine.Table)arrTables[0];
dbConn = crTable.LogOnInfo;
// setting values
parseConnString(Settings.CnxBackShop);
dbConn.ConnectionInfo.ServerName = _ServerName;
dbConn.ConnectionInfo.DatabaseName =
_DatabaseName;
dbConn.ConnectionInfo.UserID = _UserID;
dbConn.ConnectionInfo.Password = _Password;
// applying login info to the table object
crTable.ApplyLogOnInfo(dbConn);
crTable.Location =
dbConn.ConnectionInfo.DatabaseName + ".dbo." +
crTable.Location.Substring(crTable.Location.LastIndexOf
(".") + 1);
crTable.LogOnInfo.ConnectionInfo.ServerName =
dbConn.ConnectionInfo.ServerName;
// defining report source
CrystalReportViewer1.ReportSource = _oRpt;
setReportParameters();
}
private void setReportParameters()
{
// all the parameter fields will be added to this
collection
ParameterFields paramFields = new ParameterFields();
// the parameter fields to be sent to the report
ParameterField pfControlId = new ParameterField();
// setting the name of parameter fields with wich
they will be recieved in report
pfControlId.ParameterFieldName = "@ControlId";
// the above declared parameter fields accept
values as discrete objects
// so declaring discrete objects
ParameterDiscreteValue dc_ControlId = new
ParameterDiscreteValue();
// setting the values of discrete objects
dc_ControlId.Value = _ControlId;
// now adding these discrete values to parameters
pfControlId.CurrentValues.Add(dc_ControlId);
// now adding all these parameter fields to the
parameter collection
paramFields.Add(pfControlId);
// finally add the parameter collection to the
crystal report viewer
CrystalReportViewer1.ParameterFieldInfo =
paramFields;
}
protected void btnExport_Click(object sender, EventArgs e)
{
MemoryStream oStream;
oStream = (MemoryStream)_oRpt.ExportToStream
(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)
;
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.BinaryWrite(oStream.ToArray());
Response.End();
}
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between method and function in c#?
What is sqldatareader c#?
When a Static Constructor is called in a Class?
what is the scope of anonymous type ?
Is enum a class c#?
How long can a string be c#?
What is application object in c#?
Are all methods virtual in c#?
Where is the keyword void used?
What is a web service in c#?
In which format you can pass the value in the sleep function?
How does c# achieve polymorphism?
Is dictionary a collection?
What is the and operator in c#?
What is byte c#?