Originally Posted by
Bob Cergol
Hi Albin,
You are correct that Dynamic AI is not seeing the 'DATE' type column as date data. It is a long-standing flaw that I have complained about to Cintac. Grouping and sorting would work just fine on the text date strings but you lose the date-picker and all the built-in date functions.
Your choices are:
1) Change the date types back to DateTime. The fact that you don't use the time portion is irrelevant -- they will all be emtpy values. This would be my choice.
2) Cast the date columns back to DateTime in either dyn-views and/or report formulas
Microsoft introduced this simpler date data type way back in 2008 so it is hard to explain why Cintac never supported. I am told it has something to do with the ADO driver they use.
Regards
Bob
Bob or anyone else,
I have one report that refuses to play ball after these date conversions..
Maybe you coud tell me why because I just don´t get it.
It is a simple report showing the time we spent on different projects grouped by developers and date.
If I do a simple SQL View like this:
Code:
select User, Date, SUM(Time) as Time from MyTable where User IN ('001', '002', '003', '007', '008', '010')
GROUP BY User, Date
ORDER BY Date DESC
I get a great report showing the data exactly like we want it. Like attached picture 1.
But since we also want to see this as a Graph (HC Line) we need to let Dynamic do the grouping so we change the SQL View code to:
Code:
select User, Date, Time from MyTable where User IN ('001', '002', '003', '007', '008', '010')
ORDER BY Date DESC
Then we create a report with HC Line graph and groups on Date, User.
This results in duplicates.. I don´t get why, but if Dynamic is doing the grouping here we get a couple of duplicate rows per user. Picture below:
Have you seen anything like this?