from vb.net crystal report result directly export to pdf
-
Hello everybody, I am calling crystal report file i.e .rpt file from desktop application which is in vb.net 1.1 > On click Print button, It display result in crystal report and after click on option export from crystal report file , i gets result in pdf file. Now, i want whenever i click print , i want directly get result in pdf instead getting result in crystal report then export . Regards Shailesh Kavalkar
-
Hello everybody, I am calling crystal report file i.e .rpt file from desktop application which is in vb.net 1.1 > On click Print button, It display result in crystal report and after click on option export from crystal report file , i gets result in pdf file. Now, i want whenever i click print , i want directly get result in pdf instead getting result in crystal report then export . Regards Shailesh Kavalkar
Imports CrystalDecisions.Web Imports CrystalDecisions.Shared Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.CrystalReports.Engine.ReportDocument Partial Class test Inherits System.Web.UI.Page Dim cn As OledbConnection Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Call ShowReport() End Sub Sub ShowReport() ''*************************************************************************************** ''Don't change any line in the below code or the report will not work as expected ''*************************************************************************************** Dim ConnInfo As New ConnectionInfo With ConnInfo .DatabaseName = "test" End With Dim rpt As New ReportDocument rpt.Load(Server.MapPath("Abc.rpt")) Dim ParamFields As ParameterFields = Me.CrystalReportViewer.ParameterFieldInfo Dim ParamField As New ParameterField Dim ParamField_Value As New ParameterDiscreteValue ParamField.Name = "frmdt" ParamField_Value.Value = Session("FROMDATE") ''frmDate ''"30-Oct-2007 12:00:00" ParamField.CurrentValues.Add(ParamField_Value) rpt.ParameterFields("frmdt").CurrentValues.Add(ParamField_Value) ParamFields.Add(ParamField) ParamField = New ParameterField ParamField_Value = New ParameterDiscreteValue 'Here todt is the parameter name Created in Report ParamField.Name = "todt" ParamField_Value.Value = Session("TODATE") ''ToDate ''"31-Oct-2007 12:00:00" ParamField.CurrentValues.Add(ParamField_Value) rpt.ParameterFields("todt").CurrentValues.Add(ParamField_Value) ParamFields.Add(ParamField) ''*********** VERY IMPORTANT ''***************** ''Whenever using Parameter passing to CR :- Assigning the ParameterFields object to the ParameterFieldInfo of the CrystalReportViewer object programmatically will also suppress the default dialog asking for parameters that normally appears when you open a report with parameters. Me.CrystalReportViewer.ParameterFieldInfo = ParamFields For Each cnInfo As TableLogOnInfo In Me.CrystalReportViewer.LogOnInfo cnInfo.ConnectionInfo = ConnInfo Next '======================================================================================================== 'To Open Report In
-
Hello everybody, I am calling crystal report file i.e .rpt file from desktop application which is in vb.net 1.1 > On click Print button, It display result in crystal report and after click on option export from crystal report file , i gets result in pdf file. Now, i want whenever i click print , i want directly get result in pdf instead getting result in crystal report then export . Regards Shailesh Kavalkar