Solved

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

Posted on 2011-02-27
10
1,077 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

929 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now