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...
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...
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...
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}...
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.
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])...
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...
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.