Crystal Reports crystal syntax

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: crystal syntax

Post Reply

Post New Topic

Author	Message
lavenzo Newbie Joined: 24 Oct 2011 Online Status: Offline Posts: 1	Topic: crystal syntax Posted: 24 Oct 2011 at 6:28pm
	hi i'm trying to sum up a field which is construct from (LogOut_Time - LogIn_Time) as @TotalOnline_Time(in text format)...how should i construct my formula? when i Sum ({@TotalOnline_Time}) i got an error "A number field or currency amount field is require here"
	IP Logged


Robotacha Groupie Joined: 11 Nov 2009 Location: United Kingdom Online Status: Offline Posts: 97	Posted: 25 Oct 2011 at 4:43am
	probably because you cant SUM a text field. Why do you need it in text format? You could always, do a formula: @totaltime (LOGOUT_TIME - LOGIN_TIME) then, SUM this field in the report, then write another formula: @totaltimetext totext(sum ({@totaltime}, {Table_user})) obviously replace the TABLE_USER with what ever group you are summarizing.
	Regards, Michael Jones
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum