1. Ben Scofield
  2. Report Editor
  3. Thursday, July 12 2018, 05:30 PM
  4.  Subscribe via email
Hi, I have a query that is returning data for a Boxes type chart but when I switch over to pie charts, the example disappears and nothing is generated with the report at all.

Also where is the documentation that details how to customize the labels? For example here:

https://valentina-db.com/docs/dokuwiki/v7/lib/exe/fetch.php?cache=&;w=294&h=245&media=valentina:products:vstudio:picts:vs_reports_controls_chart_example_pie.png

It shows labels in the pie chart along with percentages. How is that done?

Ben
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Ben,

So when you switch to pie chart - nothing is shown in the design mode, right? Could you please make a screenshot (layout+property inspector with the chart selected)?

To show the labels, the query should return two columns: the first is the value, the second is the label.
Attachments (2)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 1
Ben Scofield Accepted Answer
Sergey,

Correct, even in the designer the chart shows empty.

In image bars1.png you see the designer with a working bar graph.
in image bars2.png you see the query/source data window for the bar graph
in image pie1.png you see me changing the type to pie.
in image pie2.png you see the result in the designer (blank) along with the properties on the right.

Is that what you needed?

Ben
Attachments (4)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
Sergey Pashkov Accepted Answer
Hello Ben,

Yes, thank you, I reproduced the problem on the Windows system.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 3
Ben Scofield Accepted Answer
Any ideas on how I can produce a pie chart?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 4
Sergey Pashkov Accepted Answer
Not yet, we’re working on it.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 5
Sergey Pashkov Accepted Answer
The fix will be available in the version 8.3.7, we'll release it in a few days along with other fixes.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 6
Ben Scofield Accepted Answer
Sergey,

I have another question. I have a chart that I suppose I'll eventually convert to a pie chart, but having it as a bar graph for the time being makes me wonder: See the amounts on the left? How can I get amounts higher than 999,999 to be formatted in something other than scientific notation? Further, how can I get all amounts formatted that way (so the bottom would show $500,000 instead of 500000)?
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 7
Sergey Pashkov Accepted Answer
Hello Ben,

We use the GNUPLOT charting library, so it is possible to change the format of Y-axis labels using the gnuplot script in the property inspector.

There are two ways.
1) Set the custom format
set format y "$%.2f"

But it doesn't print the thousands separator

2) Define the custom Y tics
set ytics ("$1,000,000" 1e6, "$500,000" 5e5, "$300,000" 3e5)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 8
Sergey Pashkov Accepted Answer
The version 8.3.7 is available for download.
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