Hi,
I use a crystal report that does not have any database fields, only formula fields. I already know how to add a group with the addgroup method, but need to know how are summary fields added?
I need to add a sub total for a money field in each group that has to show at bottom of each group but am unsure as to how this is done. Any help would be very much appreciated.
Again, I don't use any database field and so CR does not allow me to physically add a group section and paste any formulas. It seems this needs to be done by code.
I'm desperate!
Regards,
MikeHi,
U need database fiels in crystal report, it is very important, without having any data what r u gonna show in your report.
Field on which u want to summarize,
In your report detail section, right click the desired field and "Insert" > "Summary". Select "count" and place it in group footer
U will have various options as maximum , minimum, count , Mode etc, select according to your report requirements.
Showing posts with label formula. Show all posts
Showing posts with label formula. Show all posts
Monday, March 19, 2012
Friday, February 24, 2012
How to add 12 months to the CurrentDate
Ciao, i'm using Crystal Report 6 and I have a formula field which must show the currentdate + 12 months, i.e.: today is 16/11/2004, i need 16/10/2004.
Could you help me?
I'm trying the data functions but i'm not able to solve my problem :-\Solution:
CurrentDate + 365
Ops... :-p
Ciao :-)|||above solution works except for Leap years.....
alternative is :
formula = dateAdd("m", 12, CurrentDate)
you can do add and subtract arithmetic on dates using DateAdd.
1st paremeter = either "d", "m", or "y",
2nd parameter is amount you want to inbcrement or decrement by,
last parameter is date you want to use as basis of calculations
Dave
Could you help me?
I'm trying the data functions but i'm not able to solve my problem :-\Solution:
CurrentDate + 365
Ops... :-p
Ciao :-)|||above solution works except for Leap years.....
alternative is :
formula = dateAdd("m", 12, CurrentDate)
you can do add and subtract arithmetic on dates using DateAdd.
1st paremeter = either "d", "m", or "y",
2nd parameter is amount you want to inbcrement or decrement by,
last parameter is date you want to use as basis of calculations
Dave
Subscribe to:
Posts (Atom)