logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
cyracks  
#1 Posted : Sunday, June 28, 2020 7:59:53 PM(UTC)
cyracks

Rank: Member

Groups: Registered
Joined: 6/5/2020(UTC)
Posts: 12
Slovenia

Thanks: 4 times
Hello,

when setting date restriction, format set in where part of SQL statement is not correct even if custom format is yyyy-MM-dd.
How to reproduce an error:
1) add table with smalldatetime/datetime column to repository. I set date format to "Short Date" but error is the same even if date format is something else.
2) use date column as an restriction
3) when report is run restriction is set as
Quote:

AND vbi_acct_trans.d_key_date >'28.06.2019 00:00:00'


Even if I set format = Custom and Custom format = yyyy-MM-dd under restriction options -> Advanced restriction is not applied correctly (it does not change). I even tried to set format in all places possible (dataset -> table -> column, Report model -> column -> options -> Format, Report -> Restriction -> advanced -> custom format) to yyyy-MM-dd and restriction is not applied correctly but it is shown differently in data table.

My connection and database type = MS SQLServer.

Regards,
Tomaž
cyracks  
#2 Posted : Sunday, June 28, 2020 9:18:28 PM(UTC)
cyracks

Rank: Member

Groups: Registered
Joined: 6/5/2020(UTC)
Posts: 12
Slovenia

Thanks: 4 times
I figure it out that problem is because Connection type is MS SQLServer, if I set it to OleDb then it works ok. With OleDb I have some problems with the use of temporary tables so I would like to find a solution for MS SQLServer connection type.

Elf is that a bug or some setting ?
cyracks  
#3 Posted : Sunday, June 28, 2020 9:41:53 PM(UTC)
cyracks

Rank: Member

Groups: Registered
Joined: 6/5/2020(UTC)
Posts: 12
Slovenia

Thanks: 4 times
I fixed the problem with a setting in Data source -> Connection -> Date Time format :)
epf  
#4 Posted : Monday, June 29, 2020 6:49:51 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
yes, the display format is not related to the format used for the where clause, this one is defined in the data source connection...
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.