Solved

# crystal formula - date range 1,2,3 months

Posted on 2008-10-28
285 Views
Hi,
How can I create formula like this ? What function should I use ?
Example:
if {date.field} in last0to30days then {qnty} * {price}  else 0
I need formula for:
0to30 days back from currentdate
31to60days back from currentdate
61to90days back from currentdate
Maybe I should use something with month({date.filed)=....
henry
0
Question by:henryk123
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
• 5
• 3

LVL 77

Expert Comment

ID: 22823573
if {date.field} in Aged0to30days then
{table.qnty} * {Table.price}
else
0
0

LVL 77

Expert Comment

ID: 22823601
Sorry - posted too early...
For your 30 days formula use...

if {table.datefield} in Aged0to30days then
{table.qnty} * {Table.price}
else
0

Then create similar formulas using
Aged31to60days
Aged61to90days
0

Author Comment

ID: 22823776
thx working good
Can I ask something more ?
0

LVL 77

Expert Comment

ID: 22823934
As long as it is related to this Q, then Yes.
Otherwise post a new Q.
0

Author Comment

ID: 22823970
ok ,
I have subreport in my main report.
I'd like show in main report's footer sums from subreport's report footer. How to do that ?
0

LVL 77

Expert Comment

ID: 22824590
You have to declare a shared variable in the main report
(formula field in the report header - example:
shared numbervar mytot:=0;
""

In the subreport footer, create a formula field, declare the same variable and assign it the value you want it to have.

In the main report footer, create a formula field and declare the shared variable again and also specify it as the output .
0

Author Comment

ID: 22824996
In my subreport i have formula field in report header {@sum shipments}
inside: sum ({@ship0to30}) + sum({@ship31to60}) + sum ({@ship61to90})
I need this field use in main report:

I prepared something like that:

In main report header:
WhilePrintingRecords;
Shared NumberVar SubValue1;

In subreport - report footer:
WhilePrintingRecords;
Shared NumberVar SubValue1;
SubValue1:={@ship0to30};

In mainreport after subreport:
WhilePrintingRecords;
Shared NumberVar SubValue1;
SubValue1

Finish formula:
I'd like show diffrenece between sums (sum from main report and sum from subreport)
My formula:
WhilePrintingRecords;
Shared NumberVar Subvalue1;
{@sum backlog}- subvalue1

Unfortunately, doesn't work.
Shows me numbers but completely incorrect.
Did I any mistakes in formulas or this share values don't work good with sums ?
h

0

LVL 77

Accepted Solution

peter57r earned 500 total points
ID: 22825076
All looks as it should to me.
Can you temporarily show the result of this formula as below and see if looks OK...

In subreport - report footer:
WhilePrintingRecords;
Shared NumberVar SubValue1;
SubValue1:={@ship0to30};
subvalue1
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Title # Comments Views Activity
Crystal Reports - Trim Data 7 83
Mask on Parameter CR2008 28 80
Calculation - Mini/Max Removed then average 8 37
Crystal Reports date formatted as string, how to group 2 27
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customerâ€™s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. â€¦
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 biâ€¦
Starting up a Project
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
###### Suggested Courses
Course of the Month7 days, 1 hour left to enroll

#### 734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.