Crystal 2013 Doesn't recognise jiwa DateTime fields  Topic is solved

Support for Crystal Reports within Jiwa.

Crystal 2013 Doesn't recognise jiwa DateTime fields  Topic is solved

Postby 2can2 » Tue Dec 13, 2016 2:32 pm

Hi, My version of Crystal 2013 won't see the DateTime format option for our Jiwa DateTime fields?? as one example SO_PrintLog.SysDateTime is only recognised as Date.
If I use a formula 'ToText({SO_PrintLog.SysDateTime} , "dd-MM-yyyy hh:mm:ss") it prints out as 13-12-2016 hh:mm:ss
Is there an easier way them me having to split fields?
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: Crystal 2013 Doesn't recognise jiwa DateTime fields

Postby Mike.Sheen » Tue Dec 13, 2016 9:01 pm

Hi Doug,

I created a new report, added a datasource to my 7.00.175.00 database and added SO_PrintLog using the database expert, then created a formula with the content "ToText({SO_PrintLog.SysDateTime} , "dd-MM-yyyy hh:mm:ss")" and it all worked as expected.

I'm not using Crystal Reports 2013 - I'm using crystal reports developer version for visual studio 2015 - which may be different in behavior, but that would surprise me if that is the case. Attached is the report I created and tested with - can you download it and open it with your Crystal Reports 2013, and see if you see the same or different results.

Mike

crystal_reports_formula.PNG
formula


crystal_reports_test.PNG
screenshot
Attachments
CrystalReport1.rpt
Sample Report
(16 KiB) Downloaded 234 times
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2440
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 755

Re: Crystal 2013 Doesn't recognise jiwa DateTime fields

Postby 2can2 » Thu Dec 15, 2016 9:57 am

Hi Mike, thanks for the rapid reply and effort. I downloaded your report and repointed it to my JiwaDemo db and Crystal recognises it as a DateTime field!!
What is really strange is my report sees it as DATE only! and even recognises DB_Main.LastSavedDateTime also as a DATE field? Screenshots attached.
The 2 reports are looking at the identical tables? I have checked in Sql and the design shows as DateTime obviously.
I have also checked other standard reports and they all show Date only for DateTime stamped fields SO it looks like a Crystal 2013 developer issue!
I have emailed Crystal as nothing listed on the web.
Thanks for the help anyway.
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: Crystal 2013 Doesn't recognise jiwa DateTime fields

Postby 2can2 » Thu Dec 15, 2016 10:02 am

[The extension docx has been deactivated and can no longer be displayed.]

I have attached screenshot now.
Attachments

[The extension docx has been deactivated and can no longer be displayed.]

2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: Crystal 2013 Doesn't recognise jiwa DateTime fields

Postby 2can2 » Mon Dec 19, 2016 11:50 am

Hi, Any idea how I can get this info out?? I can't seem to find the correct syntax to split time out. Thanks.
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: Crystal 2013 Doesn't recognise jiwa DateTime fields

Postby 2can2 » Mon Dec 19, 2016 12:01 pm

What is weird is my version of Crystal sees ALL DateTime fileds as Date - in DB_Main for instance LastSavedDateTime, LastPurchaseDate, LastPaymentDate are all shown as DATE in Crystal yet in the MNT30000 stored proc the RECORDDate is recognised as DateTime ??
Very odd.
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25

Re: Crystal 2013 Doesn't recognise jiwa DateTime fields

Postby 2can2 » Mon Dec 19, 2016 12:22 pm

Solved. Didn't find the answers 1st few times I tried. Cheers

This behavior occurs because the report was created with the 'Convert Date-Time Field' box set to 'To Date' or 'To String'. To display the date and time portion of the field, set the 'Convert Date-Time Field' box to 'To Date-Time'.
2can2
Frequent Contributor
Frequent Contributor
 
Posts: 171
Joined: Tue Feb 26, 2008 10:24 am
Topics Solved: 25


Return to Crystal Reports

Who is online

Users browsing this forum: No registered users and 1 guest

cron