Hi,
To total the number of hours:
Use the formula only for displaying on the report, but use actual database fields for adding the number of hours. Then apply the same formula on the total and display that.
In your example, you would get 45.8 as the total, then converting it to hrs and...
Hi,
I solved my problem last week... a very simple solution provided by Crystal Reports. I wanted to share it with other users incase someone else encounters the same problem.
I had created the fake pagegroup to work around the 'Virtual or horizontal pages' created by Cross tab. In the Format...
Hi,
I am using CR XI. I have a table containing data like
Date Amount
Jan 1990 5
Feb 1990 2
Mar 1990 3
.... ....
Jan 2006 6
The requirement is to create a triangle report like
Jan1990 Feb1990 Mar1990. .. Jan 2006
Jan1990 5 F(5,2) F(5,2,3)...
Sorry, I had been pulled away from this for a while and could only look at this last week.
Thank you for the solution. Once I sorted-out how to use GridRowColumnValue("table.row") = 'TopRowLabel', it all worked great!
Hi ReillyC,
It may seem strange to you that someone is coming back on this thread. I am new to Crystal reports and need to build a report similar to your example here.
I am struggling to get the columns right on my report. In your example, you have 31-March-2005, 30-Jun-2005 etc. as column...
Sorry, these are different instances of the same field.
I am looking at using log() and then exp() functions to get the result I want. But if you have a simpler solution, it would be great and your response is much appreciated.
Thanks
Hi,
I am new to Crystal reports and using Crystal XI. I need to create a cross tab report.
Can some one tell me if it is possible to create a custom formula for summarizing a field? What I need to get is a running product like
(X1+1)*(X2+1)*(X3+1)...
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.