Crystal Report issue in VS

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
frmReports.CrystalReportViewer1.Refresh()

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 13.0.18.2192

If anyone can help then that would be great.

Regards
Simon

Answer 1

User1724605321 posted

Hi Simon1976 ,

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

https://forums.asp.net/76.aspx/1?Crystal+Reports 

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

dateserial(year(currentdate),month(currentdate)+1,1-1)

Or :

date(year(currentdate),month(currentdate)+1,1)-1 

Best Regards,

Nan Yu

Answer 2

User1659195581 posted

Hi,

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

Simon