The total for multiple months would use the total booked orders / (total web leads + total phone leads)
I would just average the closing ratios but this would not be representative for longer time frames.
Question on Crystal Report XI
I have a cross tab report which has dates as columns, Month over month.
Summaries are displayed in columns under the date.
the rows are Job type broken down by location. the Summary data is sum of web leads, phone leads and booked orders.
**I need to add a...
Linda,
Thank you!
This is why you are the GURU!
Looks like knowing the order of the formatting makes the difference in this case.
Sorry for the delay, was on vacation.
Linda,
I used the formulas that you sent and modified for the appointment types.
The only issue is that I need to reset the value of T1 for each column. Any Ideas?
whileprintingrecords;
numbervar t1;
if (gridrowcolumnvalue("Command.Appointment Type") = "Delivery" or...
Yes, the Cross tab report is different.
1 Dynamic Column: AppointmentDate - Uses a date range
2 Rows: Resource - This is value is either "Truck" or "Warehouse"
Appointment Type - The value is "Delivery", "Re-Delivery", "Pick Up Empty", "Pick Up Full", "Access", "Dock In", "Dock Out"...
Thanks Linda, I knew I could count on a great solution from you.
I am using CR XI
Will this work for multiple of appointment types?
I have three types of appointments that are defined as a Gain and three that are defined as a loss.
I have a cross tab report that produces the sum of daily appointments and sum of the units by appointment type.
This was straight forward use of the crosstab wizard. The problem is that I need to have a summary calculation on the report that is something like (Units of Appointment type 1) -...
I am working with a system that has a canned crystal report that generates payment receipt data for customers. The canned report is 32KB in size with the data generated. In order to brand the report, we have added OLE Images, text boxes and hyperlinks which increased the size to 2717KB.
Does...
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.