Đang Thực Hiện

Crystal Reports - Time display formula field

I'm wanting to add a formula field (I'm guessing) that will print a "Promise Time" on our work order. This would be calculated by adding the PrintTime field and database field in the report

rolines.Time.

I will tell you what I know the best I can. The [url removed, login to view] field duplicates on the work order for each service we perform and it is displayed as a fraction of the hours it takes for each service. For example: We

have an alignment on the workorder it will print [url removed, login to view] (roughly 45 min) next to the description for alignment. Now say we have an alignment and tire rotation it would print [url removed, login to view] next to the alignment and [url removed, login to view] (12 min) next to the tire rotation.

So what I want to do is ADD all of the

[url removed, login to view] fields together and then ADD them to the current time so that the result will be a "promise time" or the time the work order should be complete. I would like to round up the result to the nearest 0 or 5 so that it will be easier for the tech to plan completion, such as a

result of 2:43 PM would be rounded to 2:45 PM And finally I want to add 10 min to the result to allow for office paper shuffling before the tech receives the workorder so the time is realistic to the tech. So the final result would be 2:55 PM

Kỹ năng: Visual Basic

Xem thêm: crystal reports display time, crystal time formula, crystal print time, formula it, crystal reports service, crystal formula display time, print time crystal reports, adding time, time together, time so, time plan, the time, tell time, order field, time order, display field, pending order time, tech service, tire database, time report, crystal report database fields, crystal reports print, database tire, crystal report print, field service

Về Bên Thuê:
( 19 nhận xét ) Tahlequah, United States

Mã Dự Án: #1621106

Đã trao cho:

MattThrower

Over 8 yers of crystal experience.

$100 USD trong 5 ngày
(3 Đánh Giá)
3.3

8 freelancer đang chào giá trung bình $78 cho công việc này

sandeep25101982

Hi, We have .Net 3.5,4.0, ASP.net,MVC,WCF,WPF,Silverlight,sharepoint and PHP expertise.please have a look at private message for relevant work done. Awaiting a positive response from your end and looking forward to Thêm

$100 USD trong 6 ngày
(10 Đánh Giá)
4.8
junbest1986

Dear Sir, I am ready to work with you, please see PM

$35 USD trong 0 ngày
(3 Đánh Giá)
3.4
vijay200797

hello Please Allow me to do that work i am able to do this. last 6 years i am in development profession Thanks

$95 USD trong 5 ngày
(0 Đánh Giá)
0.0
nitookatyal

Hi, I've 5 years exp in Crystal report wrting with complex formula creation. provide me all the relevant materisl to start work Regards

$80 USD trong 1 ngày
(0 Đánh Giá)
0.0
srinivasanrajan

HI, I have lot of experience in Crystal Reports and it formulas. Can do it very easily. Regards Sri

$100 USD trong 1 ngày
(0 Đánh Giá)
2.6
CrysBoss

I'm System Administrator and Crystal Reports Consultant, just new on this website so want to do it for the minimum cost just to win a positive review. You'll be happy with the result. Thanks

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
csjith

Hi, I have more than 8 years of exp in Crystal report/vb/vb.net, have done lots of complex report with parameter fields and formula fields . Please provide me all the relevant material to start work. Thanks Sreejith

$80 USD trong 2 ngày
(0 Đánh Giá)
0.0