Crystal Report - 8 question????
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22324
Printed Date: 29 Apr 2024 at 2:10am
Topic: Crystal Report - 8 question????
Posted By: brije1982
Subject: Crystal Report - 8 question????
Date Posted: 06 Jun 2017 at 4:51am
Hello everyone,
I am new to this forum. I hope I get something out of this. I am very new to crystal report 8 and build and customize few reports. Now, I am stuck in between my modifying open order by customer report. My questions is "How do I right formula in select expert that pulls all data when date field is blank?" Here's what I did so far.
1) I created new parameters = fromdate and todate.
2) I put that parameters inside the report.
3) I selected that field in a select expert and added a formula in formula editor.
4) The formula goes something like this;
{Orderdates.Releasedate} in {?fromdate} to {?todate}
With this formula it only pulls data between that range but when I leave it blank it shows error message. Please advise me to a right path.
Thanks,
Brijesh
|
Replies:
Posted By: kevlray
Date Posted: 06 Jun 2017 at 6:38am
|
I do not believe you can have optional prompts in CR 8. You may be able to get creative with a formula. You did say date field, I believe you meant that you want to pull in all dates when the date prompt(s) are blanks. I have not used CR 8 for a number of years, so I will have to experiment a bit.
|
Posted By: brije1982
Date Posted: 06 Jun 2017 at 6:41am
Yes I want to pull all dates when you leave the field blank.
|
Posted By: Sastry
Date Posted: 13 Jul 2017 at 3:13am
Hi
CR 8 will not support optional parameter concept i.e. leaving blank parameters. But you can do below to over come this :
Put default value for your From & To date parameters like 01/01/1900
use below as record selection formula :
If {?Fromdate} = date(1900,01,01) and {Todate} = date(1900,01,01) Then true
else
{Orderdates.Releasedate} in {?fromdate} to {?todate}
This should work.
Thanks,
Sastry
-------------
Thanks,
Sastry
|
|