Tip: How to pass Crystal Report Parameters Programmatically?

string path = string.Empty; path = Environment.CurrentDirectory + "\\DAILYITEMWISESALEREPORT.rpt"; ReportDocument crystalReport = new ReportDocument(); # region /* // Not Working this paraments ParameterField paramField = new ParameterField(); ParameterFields paramFields = new ParameterFields(); ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue(); paramField.Name = "@rvno"; paramDiscreteValue.Value = ""; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); paramField.Name = "@StoreName"; paramDiscreteValue.Value = ""; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); paramField.Name = "@StoreNameFin"; paramDiscreteValue = new ParameterDiscreteValue(); paramDiscreteValue.Value = ""; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); paramField.Name = "@FromCode"; paramDiscreteValue = new ParameterDiscreteValue(); paramDiscreteValue.Value = ""; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); paramField.Name = "@ToCode"; paramDiscreteValue = new ParameterDiscreteValue(); paramDiscreteValue.Value = ""; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); paramField.Name = "@FromDate"; paramDiscreteValue = new ParameterDiscreteValue(); paramDiscreteValue.Value = "07-01-2001"; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); paramField.Name = "@ToDate"; paramDiscreteValue = new ParameterDiscreteValue(); paramDiscreteValue.Value = "07-01-2016"; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); crystalReportViewer1.ParameterFieldInfo = paramFields; //crystalReport.ParameterFields = paramFields; // crystalReport.ParameterFields = crystalReportViewer1; */ #endregion ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldDefinition; ParameterValues crParameterValues = new ParameterValues(); ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue(); crystalReport.Load(path); crParameterDiscreteValue.Value = "abc"; crParameterFieldDefinitions = crystalReport.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions[0]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = ""; crParameterFieldDefinitions = crystalReport.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions[1]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = ""; crParameterFieldDefinitions = crystalReport.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions[2]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = ""; crParameterFieldDefinitions = crystalReport.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions[3]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = ""; crParameterFieldDefinitions = crystalReport.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions[4]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = "07-01-2001"; crParameterFieldDefinitions = crystalReport.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions[5]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crParameterDiscreteValue.Value = "08-01-2015"; crParameterFieldDefinitions = crystalReport.DataDefinition.ParameterFields; crParameterFieldDefinition = crParameterFieldDefinitions[6]; crParameterValues = crParameterFieldDefinition.CurrentValues; crParameterValues.Clear(); crParameterValues.Add(crParameterDiscreteValue); crParameterFieldDefinition.ApplyCurrentValues(crParameterValues); crystalReport.Load(path); crystalReport.SetDatabaseLogon("aa", "abc"); crystalReport.ExportToDisk(ExportFormatType.PortableDocFormat, "D:\\itemwise.pdf"); //if you want ot export //crystalReportViewer1.ReportSource = crystalReport; ReportViewer rv = new ReportViewer(); // If you want to Show report rv.ShowReport(crystalReport); rv.ShowDialog();

Jesse, technically code is same. All you have to do is, convert it to C#.

Thanks, but I'm looking for help in C#! This VB example is posted under Crystal Reports C# on c-sharpcorner.com

Hello Mahesh, Thanks, it helped. I can now see the value i passed into the report. Now, I have a problem when using this in the 'Add command' when I call a query like: Select *from categories where categoryid={?@catid} => error: No value given for one or more required parameters Select * from categories where categoryid IN ({?@catid}) => error: No value given for one or more required parameters Select *from categories where categoryid='{?@catid}' => No results returned Can you tell me how to use this parameter from the 'Add Command' module? Thanks and regards, Norman

i am trying to send parameter by the user and to preview the report. for example, the user will select the invoice no and click the preview button to view the report. i it working when i run the project form the visual studio 2008 . but when i publish it and try to work from the browser (opera / firefox ) also shared the shared the folder "C:\Documents and Settings\Administrator\Local Settings\Temp" and "C:\WINDOWS\Temp" it is not working and show the following error: Error in File C:\WINDOWS\TEMP\rptLedgerSubsidiary {1949386A-245F-4BE8-8354-62CA224759CE}.rpt: Access to report file denied. Another program may be using it.

hello, i have to filter the data which is using dropdownlist and 2 textboxs (3 of 'em autopostback). i'm done display the data in gridview and the problem is i need to display same gridview data in crystal report to another page when i click a button view. actually i'm new in .net and i have no idea how to do it.. i'm using c# .net 2.0. thanks in advance.

Hi Mahesh, I am passing the string parameters to parameter fields of crystal reports using the following code, but still a window prompting for Parameter value appears at runtime !! Any suggestions or solutions ??!! Thanks in advance ReportDocument reportDocument = new ReportDocument(); ParameterFields paramFields = new ParameterFields; ParameterField paramField; ParameterDiscreteValue paramDiscreteValue; paramField = new ParameterField(); paramField.Name = "HeaderColumn1"; paramDiscreteValue = new ParameterDiscreteValue(); paramDiscreteValue.Value = "Customer Code"; paramField.CurrentValues.Add(paramDiscreteValue); paramFields.Add(paramField); crystalReportViewer1.ReportSource = reportDocument; crystalReportViewer1.ParameterFieldInfo = paramFields; crystalReportViewer1.RefreshReport(); Thanks in advance :)

I tried to connect crystel report and dataset I got an exception An unhandled exception of type 'System.StackOverflowException' occurred in CrystalDecisions.CrystalReports.Engine.dll

i dont know why when i remove @ from perameter field it is working fine Private Sub CreateReport() Dim objReport As New invoice ' 'CrystalReport1 Dim myResults As CrystalDecisions.CrystalReports.Engine.Table Dim myLogin As CrystalDecisions.Shared.TableLogOnInfo '///////////////////////////////////////////////////////////////////////////// Dim crParameterDiscreteValue As ParameterDiscreteValue Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldLocation As ParameterFieldDefinition Dim crParameterValues As ParameterValues crParameterFieldDefinitions = objReport.DataDefinition.ParameterFields crParameterFieldLocation = crParameterFieldDefinitions.Item("emailadd") crParameterValues = crParameterFieldLocation.CurrentValues crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue.Value = "Parameter1Value" crParameterValues.Add(crParameterDiscreteValue) crParameterFieldLocation.ApplyCurrentValues(crParameterValues) ' Add a parameter value - END crParameterFieldLocation = crParameterFieldDefinitions.Item("customText") crParameterValues = crParameterFieldLocation.CurrentValues crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue.Value = "Parameter2Value" crParameterValues.Add(crParameterDiscreteValue) crParameterFieldLocation.ApplyCurrentValues(crParameterValues) '///////////////////////////////////////////////////////////////////////////////////// For Each myResults In objReport.Database.Tables myLogin = myResults.LogOnInfo myLogin.ConnectionInfo.UserID = "xxxxx" myLogin.ConnectionInfo.Password = "xxxxxxxx" myResults.ApplyLogOnInfo(myLogin) Next invoice.ReportSource = objReport End Sub

hi sir, It's nice work, I tried to apply this example to my work, but I faced with this error (; expected) at line (ParDiscreteValue = New ParDiscreteValue;) and I didn't forget ";"..! using C#, my code is: <code> RepDS= new DataSet1() ; RepDS = repBS.Getrcountcate(FromDate, ToDate); MyreportDOC.Load("RCountPerProvince.rpt"); MyreportDOC.SetDataSource(RepDS); // Declare report variables ParameterDiscreteValue crParameterDiscreteValue; ParameterFieldDefinitions crParameterFieldDefinitions; ParameterFieldDefinition crParameterFieldLocation; ParameterValues crParameterValues; //report parameters crParameterFieldDefinitions = MyreportDOC.DataDefinition.ParameterFields; // add date 1 parameter crParameterFieldLocation = crParameterFieldDefinitions.Item("@FromDate"); crParameterValues = crParameterFieldLocation.CurrentValues; crParameterDiscreteValue = New crParameterDiscreteValue(); crParameterDiscreteValue.Value = FromDate; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldLocation.ApplyCurrentValues(crParameterValues); //add date 2 parameter crParameterFieldLocation = crParameterFieldDefinitions.Item("@todate"); crParameterValues = crParameterFieldLocation.CurrentValues; crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue; crParameterDiscreteValue.Value = ToDate; crParameterValues.Add(crParameterDiscreteValue); crParameterFieldLocation.ApplyCurrentValues(crParameterValues); // load Viewer CrystalReportViewer1.ReportSource = MyreportDOC ; CrystalReportViewer1.DataBind(); </code>

Missing Parameter values

I m writing a report using vb.net 2008.i m held up with prbms.how to drag and drop the parameters on crystalreport.rpt.i want to create monthly sales report where my database includes salesmaster and salesdetails table.how to specify date.

code not working

Mahesh, I already added proper componant (CrViewer) & refrences also. I want to export the .rpt file to .pdf file. I can export the file properly, means the data which is showing my exported pdf file is right. But the problem is I cant get the formulas which are created in .rpt file. Some formulas are showing blank value, some are showing the value of other formulas. The value for these formulas is pasing programmatically using VB 6.0. So, nw I want to know tht hw to pass Crystal reports formulas/value of formulas to the Cr Viewer...... Plz help me asap..........Thanks in advance

hi Sir how r u ? I and looking for how to pass values to formula field in crystal report progarmatically... Let me explain you what i am doing ... i am creating a report with 10 fixed fields but which field will be displayed first will be decided at runtime .. for example ... i have four fields ... Name , FName, Phone, Email..... i will decide at runtime the format of report .... 1. Name Fname Phone Email 2. Fname Name Phone Email 3. Email Name Phone Fname like this it can be any depending on the user requirement .... so i have used 10 formula fields and i will pass the field name to formulas at runtime ... so how to do that .... i am not getting it ... If there is any other alternative please help me .... Thanks for ur useful help in advance ...

Hi, I have no experience with crystal reports. I have a windows form called form1 on whiich I have a datetimepicker and a checklist box. I want to pass the date selected(invoice date) and all the cheked boxes in the list (invoice number) to the report. On the deisgn of the form 1 there are no crystal report objects. the code is as follows. Please help me. Dim cryRpt As New ReportDocument cryRpt.Load("C:\Documents and Settings\SPatel\Desktop\Rental Invoice.rpt") Dim crViewer As New CrystalDecisions.Windows.Forms.CrystalReportViewer Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldDefinition As ParameterFieldDefinition Dim crParameterValues As New ParameterValues Dim crParameterDiscreteValue As New ParameterDiscreteValue crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields crParameterFieldDefinition = crParameterFieldDefinitions.Item("INVOICE_NUMBER") crParameterValues = crParameterFieldDefinition.CurrentValues Dim dMyDate As String dMyDate = DateTimePicker1.Value.Date Dim crParadateValues As New ParameterValues Dim crParadateDiscreteValue As New ParameterDiscreteValue crParadateDiscreteValue.Value = dMyDate crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields crParameterFieldDefinition = crParameterFieldDefinitions.Item("INVOICE_DATE") crParadateValues = crParameterFieldDefinition.CurrentValues crParameterValues.Add(crParadateDiscreteValue) crParameterFieldDefinition.ApplyCurrentValues(crParadateValues) For i As Integer = 0 To rentalinvoices.CheckedItems.Count – 1 str = rentalinvoices.CheckedItems(i).ToString() crParameterDiscreteValue.Value = str crParameterValues.Add(crParameterDiscreteValue) crParameterFieldDefinition.ApplyCurrentValues(crParameterValues) Next crParameterFieldDefinition.ApplyCurrentValues(crParameterValues) crViewer.ReportSource = cryRpt crViewer.Refresh()

Hi: I write the code in C# but getting the error: 'CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions' does not contain a definition for 'Item' any idea why this error? pls help me......... thnx in advance maksuda

Hi Mahesh Chand: I tried your code in C#. But I am getting an error: 'CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions' does not contain a definition for 'Item' why this error? can someone pls help? thnx in advance

How do I create a datatable or dataset in memory and pass (bind) to crystall reports

How to bind sqlXml Stored procedure to a Crystal report dynamically

I am passing date parameter to the report but bit doesnot load the data but,in sql the same parameter load the data.What is the problem of this?

Hello mahesh, dear i have copy ur code and paste it but it is giving one error as : Error 1 'DataDefinition' is not a member of 'CrystalDecisions.Web.CrystalReportViewer' Please sort out this problem also please please if u can then plz provide me the code for filtering report according to given start date and end date as in my database(in one table) there is one column of date and i want that user should see report accordingly in between by giveng start date and end date.So plz plz provied me the code for passing start date and end date..i'll be very thankfull to u....

Hello mahesh, dear i have copy ur code and paste it but it is giving one error as : Error 1 'DataDefinition' is not a member of 'CrystalDecisions.Web.CrystalReportViewer' Please sort out this problem also please please if u can then plz provide me the code for filtering report according to given start date and end date as in my database(in one table) there is one column of date and i want that user should see report accordingly in between by giveng start date and end date.So plz plz provied me the code for passing start date and end date..i'll be very thankfull to u....

Just curious if there is anything I should know about linked parameters in subreports. I have tried to use your code, which is very helpful in loading reports as embedded resources, however I am having trouble loading reports which have subreports with linked parameters. Any tips? Thanks,

Thanks for this Tip it's very usefull

This is the error message: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) This is my code: Dim crReportDocument As New CrystalReport1 Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldDefinition As ParameterFieldDefinition Dim crParameterValues As ParameterValues Dim crParameterDiscreteValue As ParameterDiscreteValue crParameterFieldDefinitions = crReportDocument.DataDefinition.ParameterFields crParameterFieldDefinition = crParameterFieldDefinitions.Item("StartDate") 'Error source crParameterValues = crParameterFieldDefinition.CurrentValues crParameterDiscreteValue = New ParameterDiscreteValue() crParameterDiscreteValue.Value = CDate("7/1/7") crParameterValues.Add(crParameterDiscreteValue) crParameterFieldDefinition.ApplyCurrentValues(crParameterValues) crParameterFieldDefinition = crParameterFieldDefinitions.Item("EndDate") crParameterValues = crParameterFieldDefinition.CurrentValues crParameterDiscreteValue = New ParameterDiscreteValue() crParameterDiscreteValue.Value = CDate("8/31/7") crParameterValues.Add(crParameterDiscreteValue) crParameterFieldDefinition.ApplyCurrentValues(crParameterValues) crParameterFieldDefinition = crParameterFieldDefinitions.Item("CustomerRN") crParameterValues = crParameterFieldDefinition.CurrentValues crParameterDiscreteValue = New ParameterDiscreteValue() crParameterDiscreteValue.Value = CInt("3") crParameterValues.Add(crParameterDiscreteValue) ParameterFieldDefinition.ApplyCurrentValues(crParameterValues) crReportDocument.Load("D:\MyWorks\DMB\Windows Apps\FinOrg\FinOrg\FinOrg\CrystalReport1.rpt") crReportDocument.SetDatabaseLogon("Administrator", "autumninnewyork") crReportDocument.Refresh() Me.CrystalReportViewer.ReportSource = crReportDocument Any suggestion? thanks :)

I created a sql command in the crystal report and load this report in vb.net . now the location of datasource is changed and moved to new server , I want to change server by coding in vb.net I use report.setdatabaselogon(userid,password,servername,database) But error failed logon and incorrect logon parameter occured.

I am passing the datatable/dataset to the SetDataSource method. And also passing the parameters as shown in your piece of code. But I can't see the parameters being populated in the report. Some additional information. There report files were original developed in Crystal 8.5 I am using Crystal DotNet runtime version 10.0.3300.0 The parameters are used in the header section using following sytnax {?@ParamName} I heard that we cannot used both SetDataSource and Parameters i.e. either use SetDataSource or use Parameters with ConnectionInfo. Is that true? From your article I guess the answer is No. Thanks, Bhavesh

we have developed a front end application in .NET using SQL as backend. We have designed report Using Crystal Decision . But when we try to execute the program, We have encountered the problem with error msg "Login failed ! try Again"... Moreover in Crystalreport.Viewer .. we had to press REFRESH button for every change in Report Value.. We need help from you... regards Prabhakaran

Can someone provide the C# version of the code?

Mahesh, I'm getting the data in xml file once the dataset is saved to. But the same dataset data is not displaying in the report using crReportDocument.SetDataSource(dataSet) after binding dataset to crystal report. Kindly advice Thanks, Jayaram

Hi, I am passing my values programmatically by asp.net code. But still I am getting a prompt to enter the value. Why?

How can i seve or export a filled rpt.viewer as a .rpt file passing the filename as parameter. I need to avoid the user interaction and the savedialog control. Thenks in adv.

Is it possible to generate report without using dataset / stored procedure or anything related to a database or XML. Like generating report using the Windows forms control texts that are not bound to any database. Are there any samples available?

i am trying to generate crystal reports based on a combobox selected value in C#.net can any body help me regarding that. very very urjent

Also, I am trying to make table of content for company's very confidentianl report. Could you please tell me how can I do that?

Hi Mahesh, Could please tell me how can I pass integer and date time type parameters for crystal report in code?(if possible in C#) Thanks, Kalpna Parmar

hello when I Pass The parameter from .Net to REports and Change Teh Connection (login To DataBase) not Work? why please if u can help me :what code to define Connection in .Net (log To Sql)and work the Crystal Reports Thank u