1. Scott
  2. Report Editor
  3. Saturday, February 18 2017, 11:50 PM
  4.  Subscribe via email
Using the 7.0.1 VStudio for both a local VDB an VReport (On Windows):

In studio the Locale starts out blank and I can't set a specific Locale. I click on the editing pencil and set it to en_US but it will not persist. It remains blank.

Design a local DB - one of the fields (sDate) is a date field (MM/DD/YYYY) set for each record.

Query: SELECT * FROM tblCOPP WHERE sDate BETWEEN $P(startDate) AND $P(endDate)

Then I use the new interactive function in VStudio for parameters, I set two: (same parameter names as in the DB query)

startDate (inDate)
endDate (inDate)

Run the report and set the two dates via the popup in the MM/DD/YYYY format and the report errors out telling me the date parameter is invalid (illegal character at position yada yada) because the interactive parameter date has been encoded in the YYYY-MM-DD format instead of the MM/DD/YYYY I am using.

In the query editor if I set a default date for my two parameter fields it works fine when you click the test tab.

Any idea what I am doing wrong?

Scott
Comment
There are no comments made yet.
Scott Accepted Answer
I also just connected to our VServer (7.0.1) and again the Locale is blank and cannot be set.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Scott Accepted Answer
I disabled the interactive feature in the parameter section of VStudio and hard coded two dates in the startDate and endDate parameters as 02/10/2017 and 02/28/2017 and now the report works as expected.

The dates must default to the YYYY-MM-DD format in the interactive popup when sent to the report.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
Sergey Pashkov Accepted Answer
Hello Scott,
Thank you, I've reproduced these issues
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 3
Sergey Pashkov Accepted Answer
Fixes will be available in the version 7.0.2.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 4
Scott Accepted Answer
Thanks Sergey for your help!
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories