1. Dale
  2. Report Editor
  3. Tuesday, November 05 2019, 03:29 AM
  4.  Subscribe via email
Valentina Studio Pro 8.3.3 report keeps on crashing.

Here's the story:
1. In the query I called a stored procedure and tested it (pic 1).
2. Designed a report and preview it (pic 2). So far so good.
3. Now, I disable any calls from the query (pic 3) and
4. Simulate the calls in the pre-build script as I plan to call this from my Xojo app.
When I preview the report, Valentina crashes.
Attachments (4)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Dale,

I can't reproduce such issue in my Xojo test app.
Maybe try to simplify call in the pre_build script, run without getting parameters? Just to know if it is executed and the table is created.

Also, you can try to use parameters in the report query:
CALL getstockcard( $P('vDateFrom'), ...

$P adds quotes to values of string parameters. $!P was added in 9.0.7 and it never quotes the parameter value.

But we can't define sorting or grouping if there are multiple statements in the report query.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 21
  • Page :
  • 1
  • 2


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