Need help with crystal report formula using visual studio

Question

5.00/5 (1 vote)

See more:

SQL

SQL-Server

Visual-Studio

, +

I get the error saying "This date time literal was not understood" with this formula:

VB

Private Sub btnOPrint_Click(sender As Object, e As EventArgs) Handles btnOPrint.Click
        If MsgBox("Print Offertory Record?", MsgBoxStyle.OkCancel, "Print Record") = MsgBoxResult.Ok Then
            Dim report As New ReportDocument
            report.Load("C:\Users\Paolo\Documents\Visual Studio 2015\Projects\NewMonitoringSystem\NewMonitoringSystem\OffertoryReport.rpt")
            docprint.CrystalReportViewer1.ReportSource = report
            docprint.CrystalReportViewer1.SelectionFormula = "{tblOffertory.Date}=""" & dtpOffertory.Text & """AND {tblOffertory.Weekly}=#" & txtOffertory.Text & "#"
            docprint.CrystalReportViewer1.Refresh()
            docprint.Show()
        End If
    End Sub

But if I remove the LINE

VB

AND {tblOffertory.Weekly}=#" & txtOffertory.Text & "#"

and use just this LINE which is what i'm supposed to use:

VB

docprint.CrystalReportViewer1.SelectionFormula = "{tblOffertory.Date}=""" & dtpOffertory.Text & """"

It show the report form but has no data in it, just the columns. Can anyone help me with the formula where I only use the Date. Thanks

What I have tried:

I tried the codes mentioned above but to no avail.

Posted 28-Sep-16 18:29pm

Paolo Tansengco

Updated 29-Sep-16 17:05pm

Add a Solution

2 solutions

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)

Suvendu Shekhar Giri · Accepted Answer · 2016-09-28T21:11:00

Solution 1

Try-

totext({tblOffertory.Date})

Hope, it helps :)
Please let me know if it doesn't help or if I am missing something here.

Posted 28-Sep-16 21:11pm

Suvendu Shekhar Giri

Updated 28-Sep-16 21:12pm

v2

Comments

Paolo Tansengco 29-Sep-16 22:50pm

docprint.CrystalReportViewer1.SelectionFormula = "ToText({tblOffertory.Date})=""" & dtpOffertory.Text & """"

Still shows no data. just columns.

Paolo Tansengco 29-Sep-16 22:56pm

And when I add the line

{tblOffertory.Weekly}

. An error shows up again saying This date time literal was not understood

Paolo Tansengco 29-Sep-16 23:06pm

I got it work. Thanks for the idea.

Suvendu Shekhar Giri 30-Sep-16 1:55am

Great to know that :)

Paolo Tansengco · Accepted Answer · 2016-09-29T17:05:00

Solution 2

VB

docprint.CrystalReportViewer1.SelectionFormula = "ToText(CDate({tblOffertory.Date}))= ToText(CDate(""" & dtpOffertory.Text & """))"

This code worked. Thanks for the idea @Suvendu

Posted 29-Sep-16 17:05pm

Paolo Tansengco