1. cid lopes
  2. Report Editor
  3. Thursday, April 12 2018, 11:58 AM
  4.  Subscribe via email
Hello, how do I set a variable session in sql Ex: SET SESSION group_concat_max_len = 1000000;
When I associate in the datasource, it returns an error :
08:55:34 SELECT * ,extravios AS InternalReportField0 FROM (
SET SESSION group_concat_max_len = 100000;
SELECT......
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Cid,

Please try to use the pre_build SQL script of the report.

1. Click on the empty space of the report
2. Edit the pre_build property
3. Switch script language to SQL
4. Input text
Attachments (2)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
cid lopes Accepted Answer
It worked !!
Thanks Sergey Pashkov.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories