.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month

Home >> Articles >> ASP.NET >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Crystal Reports - Get data between two dates

Posted By:Deepika Haridas       Posted Date: February 08, 2010    Points: 25    Category: ASP.NET    URL: http://www.dotnetspark.com  

This article describes how to Get data between two dates in crystal report

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.

2) Now create a parameter called fromdate for start date

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



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()
                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;


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


                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;
                crystalReportViewer1.ReportSource = rptRR;
            catch (Exception e1)

        private void btnpreview_Click(object sender, EventArgs e)

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend