Solved

crystal report (vs2005) - summary field1 evaluate after summary field2

Posted on 2011-02-27
10
1,086 Views
Last Modified: 2012-05-11
hi,

In my cross-tab crystal report. I want to put some formula on Summary field1.
But i want the formula calculate it after summary field2.

for example
the result of summary field 2 is 2
i want summary field1 to get that result and do some calculaion

I try to use EvaluatAfter(x), etc ... not working well. please advise,
Tommy

0
Comment
Question by:hongclub
  • 4
  • 4
  • 2
10 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 34994602
There is  no way that I am aware of to control the order of evaluation in a cross tab.

Perhaps if the crosstab is based on formula fields then you could control the order.

mlmcc
0
 
LVL 4

Expert Comment

by:musalman
ID: 34996477
Why don't u use the result of summary field 2 IN Summary Field 1?
0
 

Author Comment

by:hongclub
ID: 35000571
what i do is, i hide the summary2, then put the summaryfields 2 as the first object ( so it can be executed first), then summaryfield1 can use the result of summaryfield2 to do calculation.

but i definitely want to put the summaryfields2 at the end ... cuz when i hide the summaryfield2, it left some empty space, so it affected my layout a little bit.
Tommy
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 100

Expert Comment

by:mlmcc
ID: 35000767
Crystal by default evaluates from top to bottom and left to right.

You may be able to use a formula like

SF2_Field
{fieldfor SF2}

SF1
EvaluateAfter({SF2_Field});
formula for SF1

mlmcc
0
 

Author Comment

by:hongclub
ID: 35001192
Thanks for the input ....

one question ...

How can i do EvaluateAfter({SF2_Field}), i try it before, but not success, maybe my syntax is wrong or something.

cuz SF2_field is one of the summary field in cross-tab .... it is max_something .... so how can i refer to this?

Please advise,
Tommy
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35001440
You can't.  You need to create a formula that gets the value you want then you could evaluate after the formula.

It is possible that you then can't use the formulas in a cross tab.  That I don't know

mlmcc
0
 

Author Comment

by:hongclub
ID: 35002634
yeah, that's what happened, actually all my summary fields are formulas ... so when i do EvaluateAfter(formula for Summary Fields2}), it didn't really refer to the time when display summary field2.

Tommy
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 35002775
No, it means evaluate Formula1 after formula2 for that record.

mlmcc
0
 
LVL 4

Expert Comment

by:musalman
ID: 35004480
Better if you attach Report with Data Saved in it.
0
 

Author Closing Comment

by:hongclub
ID: 35169584
pretty good!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sort by a cross tab in crystal report 2 59
C# Crystal Reports 15 101
Crystal Report Date Range Parameters 2 88
Help with a Crystal Report Formula - remove time 5 34
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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

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

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

Join & Ask a Question