Hi,

We have CRXI, Oracle 10g, via ODBC, Logicity 1.6.3.

In the report for testing purposes, there are just two fields.

{SAMPLE.SAMPLED_DATE}
and the formula field
Time({SAMPLE.SAMPLED_DATE})


If we use LSB to view the report, everything works as it should.

If we use LSB to save the report, as any type of file, it does not save.

If we remove the formula, then everything exports/saves as it should.

If we view a report first, then the export works too, although a csv option is not available.

Crystal exports the report in all cases.

To sum up, if we have a Time(DateTime) this stops Logicity from saving files, viweing the report still works.

Any ideas?

Is this a mug-worthy bug?

Cheers, Kai.

Hi again,

I've just figured out a solution to my problem

Initially, I was going down the Mid(ToTEXT(DateTime),n,n) to extract the time portion of the the datetime.

But in the end, I realised, not sure why I hadn't before, but Irealised I should have just formatted the the field as a time in Crystal.

This wouldn't really work, if you need to do some arithmatic on this field though.

Kai.