multiple parameter filtering & printing in crystal reports in .net

Question

0.00/5 (No votes)

See more:

plaese help to solve this crystal report printing problem for school program

form having 1 textbox for Student ID and two date picker & access database stored Student ID, Fees month, Amount & Date of Payment.Print the Crystal report of Particular Student with given date of Range & code as follows, which is not working (showing only plan sheet)

Dim myreport As New CrystalReport21

dbCommand.CommandText = "SELECT * From StudentPayments Where StudentID ='" & CStr(TextBox1.Text) & "' and FeesMonth >='" & CDate(FromDate.Text) & "' and FeesMonth <='" & CDate(ToDate.Text) & "'"

da.SelectCommand = dbCommand
da.Fill(Dt)
myreport.SetDataSource(Dt)
CrystalReportViewer1.ReportSource = myreport
CrystalReportViewer1.Show()

Posted 30-Sep-13 7:55am

bharat901

Updated 30-Sep-13 8:40am

Richard C Bishop

v2

Add a Solution

Comments

Kschuler 2-Oct-13 15:21pm

What do you mean not working? Have you debugged? What is in the Dt? Is it not pulling back any data? What data type is the FeesMonth column? We need more information to help.

bharat901 3-Oct-13 12:14pm

Thanks for your replay..... still i need help....
It is not puling any data from access database and FeesMonth column data type is 'datetime', only plain sheet will display

Kschuler 3-Oct-13 12:20pm

If you are not getting any data from the access database then it's your SQL statement that needs fixing, not the Crystal report. You likely do not have the date formatted in a way that access recognizes. You can google to find out the syntax that is needed, or if you look at the link in the solution thatraja posted, there is a sample that uses parms instead. Parms are nice because it knows when things are strings/numeric/dates, etc. And they help avoid sql injection attacks.

Kschuler 3-Oct-13 12:22pm

As for syntax...I googled and found this: http://stackoverflow.com/questions/12270816/datetime-format-issue-in-vb-net-with-ms-access-database-when-using-sql-statement

bharat901 3-Oct-13 12:33pm

thank u sir, let me look those examples and i will come back....
thanks once again.

bharat901 3-Oct-13 12:16pm

Dt is Data Table, sorry to mention

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)

thatraja · Answer 1 · 2013-10-03T04:16:00

Solution 1

Check this
C# Crystal Reports - Date to Date[^]

Posted 3-Oct-13 4:16am

thatraja