1. Manasi pardeshi
  2. Report Editor
  3. Понедельник, Ноябрь 18 2019, 06:18 AM
  4.  Подписаться через 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.
Вложения
Комментарий
There are no comments made yet.
Manasi pardeshi Ответ принят
Thanks Ruslan its working followed the steps
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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
Вложения
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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 ...
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello,

Please click Preview button to run the report.
In the Editor mode, it shows a sample data and query is never executed.
Комментарий
There are no comments made yet.
  • Страница :
  • 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