Search results for query: *

Thank you very much.

What is the highest version of Crystal Reports that allows a user to save down to Version 7 formatting? We're using a program here at my work that is unable to work with versions higher than 7. Thanks

If you want to add Hrs into the mix you can use the following. I built off of Mike's existing code, so as not to grab all the credit. numbervar sec:={Sec value here}; numbervar nMins; numbervar nSecs; numbervar nHrs; stringvar sMins; stringvar sSecs; stringvar sHrs; nHrs:=truncate(sec/3600)...

Found this answer through a few searches. numbervar sec:={your.seconds.field}; stringvar mins; stringvar secs; mins:=totext(truncate(sec/60),"0"); secs:=totext(remainder(sec,60),"00"); mins +":" + secs Gave the guy a star to! =)

Does Crystal come with a function that allows the easy conversion of Seconds to minutes? I am needing to run reports from a database that is storing its times in Seconds. I'd like to avoid, but may have to just accept the fact that I'll need to come up with my own conversions.

That did the trick!! I went to Database > Convert Database Driver > and selected the "OLE DB" driver. Fixed it!!! Thank you!

I have a SQL Database that has numeric data-type fields. When I assign the database to a Crystal Report, the data that is being pulled over is having decimals added to the information. For example, if I have a value in the database equal to "3600", for some reason it sees that value as 36.00...