BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Crystal Report Results Issue


 
Search this topic... | Search Crystal Reports... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Author Message
SimonUK
Forum Member
Forum Member



Joined: 18 Sep 2018

Posts: 1



PostPosted: Tue Sep 18, 2018 8:50 am 
Post subject: Crystal Report Results Issue

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
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0286 seconds using 17 queries. (SQL 0.0024 Parse 0.0009 Other 0.0253)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo