Crystal Report issue in VS RRS feed

  • Question

  • User1659195581 posted

    Good afternoon,

    Not sure if anyone can assist me with this but i'm banging my head against a brick wall.

    I have a project which has been written in Visual Studio 2013, here is the code i'm using to call the report (quite simple)

    frmReports.monthlyProjectsEnquiries1.SetParameterValue("Month", Now.Month)
    frmReports.monthlyProjectsEnquiries1.SetParameterValue("Year", Now.Year)
    frmReports.CrystalReportViewer1.ReportSource = frmReports.monthlyProjectsEnquiries1

    However the report does not show me the date range i'm requiring, instead it just shows me all entries for the entire table!

    Here is the Record Selection formula

    {quotation.quoteStatus} <> "Delete" and
    cdate ({quotation.quoteEnqDate}) >= cdate ({?Year},{?Month},1) and
    cdate({quotation.quoteEnqDate}) <= cdate ({?Year},{?Month},Day(DateSerial({?Year}, {?Month} + 1, 0)))

    I am using Crystal Reports - Version

    If anyone can help then that would be great.


    Thursday, October 11, 2018 12:12 PM

All replies

  • User1724605321 posted

    Hi Simon1976 ,

    Since the issue is related to Crystal Report , i suggest you could post to Crystal Report :


    Have you tried to use some simply way to get last day of current month , for example :


    Or :


    Best Regards,

    Nan Yu

    Friday, October 12, 2018 3:26 AM
  • User1659195581 posted


    Thank you for your reply.

    I have put this on the other forum as you suggested, but no i haven't tried that method as yet but will do later.

    Kind regards


    Friday, October 12, 2018 12:42 PM