Crystal Reports Date Range Parameter

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Date Range Parameter

Author	Message
bremen Groupie Joined: 28 May 2013 Online Status: Offline Posts: 93	Topic: Date Range Parameter Posted: 02 Oct 2013 at 6:34am
	Good afternoon all. It has been a while since I have done a parameter and whe I was doing them I wasn't that great anyway..... I am trying to create a date range paramater. I follwed the directions on this link http://crystaltricks.com/wordpress/?p=102 I run into a problem where if I pick a an end date that has no data my report returns no records.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 02 Oct 2013 at 7:39am
	you mean your source have both begin and an end date fields and the end date may be null and you want to enter a date range to look for records that were active at any time int he range entered? table.startdate<=?enddate and (table.enddate is null or table.enddate>=?startdate)
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.