Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TechiUser

  1. TechiUser

    Converting to hours:minutes

    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...
  2. TechiUser

    Cross Tab: record sort order and new page

    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...
  3. TechiUser

    Cross Tab: record sort order and new page

    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)...
  4. TechiUser

    Summary options in cross tab report

    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!
  5. TechiUser

    Attempting a manual crosstab - Crystal XI

    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...
  6. TechiUser

    Summary options in cross tab report

    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
  7. TechiUser

    Summary options in cross tab report

    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

Part and Inventory Search

Back
Top