Rank: Member
Groups: Registered
Joined: 6/5/2020(UTC) Posts: 12  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ž
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 6/5/2020(UTC) Posts: 12 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 ?
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 6/5/2020(UTC) Posts: 12 Thanks: 4 times
|
I fixed the problem with a setting in Data source -> Connection -> Date Time format :)
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 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...
|
|
|
|
|
|
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.
