Crystal Reports - Get data between two dates

"http://4.bp.blogspot.com/_UeWJDdIKSOo/SnbLc1ysELI/AAAAAAAAAFU/8ELmqyCOL6Y/s1600-h/CR1.bmp"

Crystal Report to display records between fromdate and todate


1) First step is to make new parameters by right clicking on paramaters fields in field explorer.
Then click on New.

"http://4.bp.blogspot.com/_UeWJDdIKSOo/SnbIVtQR1BI/AAAAAAAAAE8/PMKCR4ptR-k/s320/CR3.bmp"

















2) Now create a parameter called fromdate for start date
"http://4.bp.blogspot.com/_UeWJDdIKSOo/SnbI1UFaVII/AAAAAAAAAFE/dbWl6HznV-w/s320/CR4.bmp"

















3) Similarly create a parameter called todate for end date



















4) On form I have taken two datetimepicker controls for selecting from and to date


"http://4.bp.blogspot.com/_UeWJDdIKSOo/SnbLc1ysELI/AAAAAAAAAFU/8ELmqyCOL6Y/s320/CR1.bmp"
"http://4.bp.blogspot.com/_UeWJDdIKSOo/SnbLCraRHtI/AAAAAAAAAFM/WzuRYZKYAVQ/s1600-h/CR5.bmp"









 
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.ReportSource;
using CrystalDecisions.Shared;
using CrystalDecisions.Windows.Forms;

namespace sampletest
{
public partial class frmReturnReceipt : Form
{
DataSet ReportDB;
String str = "";
String FromDate, ToDate;

private void frmReturnReceipt_Load(object sender, EventArgs e)
{
}

public void Set_Report_Dataset()
{
try
{
RR rptRR = new RR();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
Tables CrTables;

ParameterFieldDefinitions crParameterFieldDefinitions ;
ParameterFieldDefinition crParameterFieldDefinition ;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

crParameterDiscreteValue.Value = dateTimePicker1.Value.ToString("yyyy-MM-dd");
crParameterFieldDefinitions = rptRR.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["fromdate"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

crParameterDiscreteValue.Value = dateTimePicker2.Value.ToString("yyyy-MM-dd");
crParameterFieldDefinitions = rptRR.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["todate"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

crConnectionInfo.ServerName = "servername";
crConnectionInfo.DatabaseName = "database_name";
crConnectionInfo.UserID = "username";
crConnectionInfo.Password = "password";

CrTables = rptRR.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}
crystalReportViewer1.ReportSource = rptRR;
crystalReportViewer1.Refresh();
}
catch (Exception e1)
{
MessageBox.Show(e1.ToString());
}
}

private void btnpreview_Click(object sender, EventArgs e)
{
Set_Report_Dataset();
}
}
}


Reference: http://angeldeeps.blogspot.com/2009/08/crystal-reports-get-data-between-two.html


Comments

Author: Pawan Awasthi21 Jul 2011 Member Level: Gold   Points : 0

Nice article Deepika..
Good effort..

Author: Deepika Haridas08 Aug 2011 Member Level: Gold   Points : 0

Thanks Pawan!!

Regards,
Deepika

Author: Suresh08 Sep 2011 Member Level: Gold   Points : 1

Hi Deepika,

This Article is very informative. I have learnt lot from this article about Get data between two dates in Crystal Reports.

very Good. Keep it up.

Regards
S.Suresh



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: