?
Solved

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

Posted on 2011-02-27
10
Medium Priority
?
1,116 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 101

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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
LVL 101

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 101

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 101

Accepted Solution

by:
mlmcc earned 1500 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Integration Management Part 2
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

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