1. Manasi pardeshi
  2. Report Editor
  3. 月, 11月 18 2019, 06:18 AM
  4.  メールで購読
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