1. Manasi pardeshi
  2. Report Editor
  3. Monday, November 18 2019, 06:18 AM
  4.  Subscribe via email
Hi Team, I want to create a graph in Valentina free studio when I write an SQL query it reflects the same graph which we visualize when we drag the charts in the report editor, suppose I write any wrong query in graph still the graph result is same. Please refer below-mentioned screenshots for your reference. kindly do the needful.
Attachments (4)
Comment
There are no comments made yet.
Manasi pardeshi Accepted Answer
Thanks Ruslan its working followed the steps
Comment
There are no comments made yet.
  1. 3 weeks ago
  2. Report Editor
  3. # 1
Ruslan Zasukhin Accepted Answer
I have take standard Valentina Studio example project 'valentina_sakila_reports'
(you must see it on the start page in the third column)

* make here a new report, with dummy SQL Query: SELECT 1; see pict1

* added chart to body of report, double click to edit it
in the query made simple SQL query with 2 fields in SELECT, see pict2
OK - to close dialog for chart

* Click PREVIEW button and see resulting graph pict 3
Attachments (3)
Comment
There are no comments made yet.
  1. 3 weeks ago
  2. Report Editor
  3. # 2
Ruslan Zasukhin Accepted Answer
Hi Manasi,

picture 2: why here Plot5?

picture 4: In SELECT you have few fields selected, but must be only two

SELECT somethingThatIs_Y, somethingThatIs_X
FROM ...
Comment
There are no comments made yet.
  1. 3 weeks ago
  2. Report Editor
  3. # 3
Sergey Pashkov Accepted Answer
And make sure the query returns Y-axis data as the first column, and ticks on the X-axis as the second column.

What do you set for the query of the report (not a chart)?
To print just one chart in the report it is necessary to define query which returns one record, no matter of content, like:
SELECT 1
Attachments (1)
Comment
There are no comments made yet.
  1. 3 weeks ago
  2. Report Editor
  3. # 4
Sergey Pashkov Accepted Answer
Hello,

Please click Preview button to run the report.
In the Editor mode, it shows a sample data and query is never executed.
Comment
There are no comments made yet.
  1. 3 weeks ago
  2. Report Editor
  3. # 5
  • 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