1. Wolfgang Kriener
  2. Report Editor
  3. Tuesday, March 01 2016, 01:46 PM
  4.  Subscribe via email
Hello, my name is Wolfgang, i am new to this discussion board. Hope someone can help.

Evaluating report generator using Studio for Mac and/or Windows.

I am looking for a way to generate a report with dynamic size of detail depending on the amount of characters in text area (Database Field). Documentation says something like evaluating space using first and last record of recordset. That is what i can produce, larger data of records in the middle of record set shows error in preview and data is cut off..

Here is what i did
-installed free version of Valentina Studio 6.3 for Mac (El Capitan) and Windows (7) - works
-created a connection to MS SQL Server - works
-created query - works
-created report - works
-can't find a combination of option settings for report database field that grows and shrinks report detail
-tried to put text area in subreport (primary key as parameter) - got error during execution of query

Is it possible to produce dynamic Reports using ADK(xojo)?
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello, Wofgang

The height of the text area for some records is bigger, than page, right?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Wolfgang Kriener Accepted Answer
Sergey,
the database field is defined as VARCHAR(5000). Maximum used is about 800 characters.
In the situation i am evaluating the field should be between 1 and 12 lines of text, depending on font definition.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
Sergey Pashkov Accepted Answer
Have you set the property 'can_grow' for this field?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 3
Wolfgang Kriener Accepted Answer
yes.
growing of detail works, but it is fixed after loading some records.
from then on records with more text it is cut off.
records with less text there is space left.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 4
Sergey Pashkov Accepted Answer
Confirmed, looks like a bug.
I'll create an issue in mantis with a sample project.
We'll try to fix it as soon as possible.
References
  1. http://valentina-db.com/bt/view.php?id=7546
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 5
Wolfgang Kriener Accepted Answer
Thank You for answer.
Wolfgang
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 6
  • 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