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.
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. more than a month ago
  2. Report Editor
  3. # 1
Manasi pardeshi Accepted Answer
Thanks Ruslan its working followed the steps
Comment
There are no comments made yet.
  1. more than a month ago
  2. Report Editor
  3. # 2
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. more than a month 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. more than a month ago
  2. Report Editor
  3. # 4
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. more than a month 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories