1. Trevor Campbell
  2. Report Editor
  3. Friday, November 11 2016, 12:37 AM
  4.  Subscribe via email
I have made a report with a bar graph. It works really well, but the labels on the bottom are running into each other. Is there a way to have the label data to appear vertical instead of horizontal? If the report editor isn't able to do this, maybe this would be a good feature to add.

Thanks
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hi Trevor,

Right, currently there's no way to do it in the Report Editor.
I think we'll add in one of the next releases, thank you.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Ruslan Zasukhin Accepted Answer
Sergey,

I think this can go into Hotfix
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
Trevor Campbell Accepted Answer
I have downloaded and installed version 7. This is the version I was told would have the ability to change graph labels to vertical. I can't see where this can be done.:D
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 3
Sergey Pashkov Accepted Answer
Hello Trevor,

1. Select chart control
2. Change property "gnuplot" in the "Scripts" section to "set xtics rotate"

GnuPlot - is a library that currently is used for charts.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 4
Trevor Campbell Accepted Answer
Thanks, this is great.

It would also be good to be able to set the angle, eg "set xtics rotate=45" for 45degress or what ever angle is required.
:D :) :D
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 5
Ruslan Zasukhin Accepted Answer
For Info

- gnu plot is C library, which our dev have plug with big efforts.
- we cannot update it easy.

We going todo:

- improve integration of JS
- allow to use a third party JS Graph library to replace gnu plot.

ETA - is not known.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 6
Sergey Pashkov Accepted Answer
Rotate by angle works too, but it is necessary to set bottom offset of the X axis labels to fit them.

For example, to fit date values mm/dd/yyyy I set:
set xtics rotate by 45 offset -0.8,-3
set bmargin 4
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 7
Trevor Campbell Accepted Answer
Excellent. That worked great. Thanks:D :D :D

Is there a way to set the date format to dd/mm/yyyy.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 8
Sergey Pashkov Accepted Answer
Hi Trevor,

Currently this format is not well controlled on chart, so it is better to format date as string in the SQL.

What database do you use?
I know MySQL has such function.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 9
  • 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