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
Solved

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

Posted on 2011-02-27
10
1,084 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying 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

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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

839 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