Export to Excel (Date Only) DateTime Problem

[cathey04]

I had some help earlier this month on this particular report and thought the export was fixed but it isn't. After many trial and error formulas, ODBC drivers, and different exports in Crystal, and wasting tons of time, I am hoping someone can help me out. I am using CR 10, Oracle DB, HPUX, pulling data from HP OpenView Service Desk.

I have a total of four Date/Time fields that at grouped by Service Call ID, then each Date/Time field (each field is a formula to figure out when the Service Call was escatlated to another team, when that team accepted and resolved it) is a summary field (maximum)along with the other details in the Group Footer. I had to use a summary filed for each date/time field because I am pulling specific data out of the history field and there is gobs and gobs of repetitive or multiple date/time entries for the same function. I have selected suppress for the GH1 and Detail Sections.

So this is what happens when I select export to Excel (I don't use this just an experiment), the Date/Time fields that are really empty show up as empty, but there is a column in between each field, so dumping that into another database won't work. When I select export to Excel (data only), and then try each option (custom, typical, minimal)no matter what I do in Crystal/Excel the blank date/time fields show up as 01/01/1990 00:00.

Thanks for any help!!

 

[IanWaterman]

Couple of things to try when getting spurious columns.

Make sure all fields in report are tied to vertical alignment markers. An they are continous, ie no gaps between markers and fields.

If you have headers with fields make sure they are tied to the same markers. If you like just minimise them to the samllest column nearby, won't look pretty in preview but will prevent fomation of merged cells in Excel

Finally when exporting to standard excel (Not data only), you should get a dialogue window which says something like base cell width on ---- drop down window.

Select the row, header or footer which has the most columns.

Hope this helps

Ian

 

[cathey04]

It worked like a charm! Thank you so much!!!