How to display a date range in crystal report

Question

0.00/5 (No votes)

See more:

Hello Everyone,

I Have an application that when i want to run a report to print on crystal report, i have two DayTimePicker to choose from one date to another to filter the data from the database but i only have a one single colunm for date in my database.

How can i display the selected date range from both the DayTimePicker on my crystal report generated.

eg.

From: DateTimePicker1 To: DateTimePicker2

What I have tried:

all i did is to pick the date column and place on my report template Section 1 header but it shows only the DayTimePicker1 selected date on the template but in my Section 3 which is the details in crystal report it filtered the selected dates as queried.

Posted 12-Jun-16 7:29am

Member 12414126

Updated 12-Jun-16 11:55am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 7434378 · Answer 1 · 2016-06-12T11:55:00

Solution 1

I don't know how you retrieve your data from the database and which database are you using, but if you using SQL for your database use a stored procedure where the parameters include from date and to date, you can filter this by using between on the date column in the db.

eg.

create procedure spWhatever
@startDate date,
@endDate date
as
begin
--do your select statement here
select * from tlbName where date_column between @startDate and @endDate
end

on the report set your datetimepickers to pass the values to the @startDate and @endDate parameters and on the report template pass the parameters

From: [@startDate] To: [@endDate]

Posted 12-Jun-16 11:55am

Member 7434378

Comments

Member 12414126 12-Jun-16 18:39pm

Below is my code to fetch out the data from the database and paste to crystal report
private void button10_Click(object sender, EventArgs e)
{
Commstore com = new Commstore();
DataSet ds = new DataSet();
rptSalesFromDates rptsales = new rptSalesFromDates();
string from1, from2;
from1 = Datefromsales.Text;
from2 = Datetosales.Text;
ds = com.Getsalesdate(from1, from2);
if (ds.Tables[0].Rows.Count > 0)
{
rptsales.SetDataSource(ds.Tables[0].DefaultView);
crvsalesbydate.ReportSource = rptsales;
}
else
{
MessageBox.Show("No Sales Made");
}
}
while this is the sql statement
public DataSet Getsalesdate(string date1, string date2)
{
DataSet ds = new DataSet();
//string sql = "select * from POS where Date between '" + Convert.ToDateTime(date1) + "' and '" + Convert.ToDateTime(date2) + "'";
string sql = "select itemname, SUM (QntSold) AS QntSold, SUM (TotalAmnt) AS TotalAmnt from POS where Date between'" + Convert.ToDateTime(date1) + "' and '" + Convert.ToDateTime(date2) + "'GROUP BY Itemname";
SqlDataAdapter dadbt = new SqlDataAdapter(sql, mycon.Opencon());
dadbt.Fill(ds);
dadbt.Dispose();
return ds;
}
How do i go about the suggested solution you gave me cos am new to programming. any help plz