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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. info12suchi

    Crosstab Crystal Report error while Refresh data

    When I Uninstalled and Re installed the Crystal Reports it worked :)
  2. info12suchi

    Crosstab Crystal Report error while Refresh data

    I have a cross tab report in the report footer. I am using Crystal Reports 2008. The report was working fine earlier. But now while the user is trying to refresh the data it is giving an error saying "Not supported" It is working for some users. when I remove the crosstab from the report, then...
  3. info12suchi

    Formula field on the Crystal reports Charts

    Inorder to show the time in Hours I wrote a new formula "Actual_time" (Sum ({@Actual time Duration}, {@DatePart_DateWorked}, "daily"))/60 Actually the time I should show on the graph is a cummulative time. So I created a running total of the "Actual Time Duration" and which has the value in...
  4. info12suchi

    Formula field on the Crystal reports Charts

    Hi, I have a formula field "Actual time Duration" which has the following formula. Stringvar array Std_Time := split(cstr({WOMNT_LABOR.ACT_TIME_DURATION}),"."); val(Std_Time[1])*60+val(Std_Time[2]) And the Display is shown in the Hours.Minutes format with formula in the display string as...
  5. info12suchi

    showing Percentage work completed on the bar graph

    Hi, I am trying to Chart/graph the data. Vw_rp_job_status.CARD_TYPE on X-axis And the Percentage of the work completion on Y-axis. Here is the formula for the Percentage_work_Completed. numbervar WIP_Cards := (Sum ({@QA Final}, {Vw_rp_job_status.CARD_TYPE})+ Sum ({@Work Complete}...
  6. info12suchi

    How to add a summary formula of group footer in the crosstab

    Hi, When we do a normal sum of the time field it will show only the mathematical sum. For example Mathematical sum of 2.30+3.40 = 5.70 Where as the time sum is 6.10. That is the reason why i am doing this in a formula instead of the direct sum. I hope this helps.
  7. info12suchi

    How to add a summary formula of group footer in the crosstab

    Table name - WOMNT_LABOR Fields in the Main report 1) WOMNT_LABOR.Work_Date 2) WOMNT_LABOR.Billing_Type 3) WOMNT_LABOR.Time(In hours) 4) WOMNT_LABOR.Name Grouping Fields 1) WOMNT_LABOR.Work_Date 2) WOMNT_LABOR.Billing_Type(Billable/Non Billable) Group Summary 1) Final_Time (Formula for the...
  8. info12suchi

    How to add a summary formula of group footer in the crosstab

    Fields in the Main report 1) Work Date 2) Billing Type 3) Time(In hours) 4) Name of the Employee Grouping Fields 1) Work Date 2) Billing Type(Billable/Non Billable) Group Summary 1) Final_Time (Formula for the Sum of Hours) Details of the formula: Total_Mins := sum(Split(Cstr(Time),".")[2])...
  9. info12suchi

    How to add a summary formula of group footer in the crosstab

    Hi, I have a formula in the Group footer, which calculates the total hours worked by the employees for a work date. In report footer I have added the Cross tab to show the total hours worked by the employees for each day. When I try to add the formula in the Cross tab summarized field. I feel...

Part and Inventory Search

Back
Top