I am trying to export a time field from crystal reports into Excel. I have tried formating the Crystal Reports field and none will work. When I export to Excel the time field that should be 05:20hrs comes into Excel as 4292594338. Any suggestions?
Thanks,
Kat
Have you looked at the permissions of the user trying to delete the report?
In Info look at the folder properties and make sure the "Delete Folder Objects" is checked.
Good luck! :-)
It depends on if you want the detail from just the last service record and flow record or do you want to see them all. If you just want the last service and flow records you can sort on those fields decending and place the field in the Group header section. If you want to see all the service...
Have you tried to group on your unique id and have the service dates sort desending and put the fields in the group section. suppress the details line.
Right click on your page footer and go to format text
click on the x2 box to the right of the suppress (do not check the suppress check box)
then type the following formula:
PageNumber > 1
this will supress the footer past page 1
Good Luck
You might write a formula. I have a formula to show me the % of inc/dec between two years of data
if Sum ({@Quarter 1}, {INCIDENT.MAIN_OFF_CODE}) <> 0 then
(Sum ({@Quarter 2}, {INCIDENT.MAIN_OFF_CODE}) - Sum ({@Quarter 1}, {INCIDENT.MAIN_OFF_CODE})) / Sum ({@Quarter 1}...
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.