Click here to Skip to main content
15,908,166 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have create 3 formulas

1. ResetList in Group-Header
2. CollectList in Detail
3. DisplayList in Group-Footer

now, i want to show Groupfooter's value [DisplayList] in group header.
I have try EvaluteAfter but it shows prior group's valuelist instead of current one

Need help
:)
Posted
Updated 17-Oct-12 20:47pm
v3
Comments
Adersh Ram 18-Oct-12 7:37am    
Hi, this is not a clear question.
Say what exact you want to display
Aarti Meswania 18-Oct-12 8:34am    
formulas work fine
but I want to show result field named DisplayList in Group Header instead of Group Footer

1 solution

solved :)

I hope it will useful to you if you are facing same problem like this...

it is easy to achieve this for summary of Numeric field
we can create summary and paste it in header it will give proper answer...

but if you are trying to do this with formula, Running total or for string column it is not possible in crystal report.

then I have make a query in sql that give me running total or for string column, it give me field values with comma separator.

e.g
SQL
select col1,Col2, (select col1 + ',' as [text()] from table1 where col2=a.col2 for xml path('')) as summaryCol1 
from table1 as a


Happy coding!
:)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900