2. ASPRunnerPro General questions
  3. How to base graphs on advanced search results?
This topic is locked

How to base graphs on advanced search results?

 		10/20/2008 2:21:46 PM
ASPRunnerPro General questions
J
 jla001 author

Using ASPRunner 6.0 build 506, we are looking to an option to make the graphs more flexible. In fact the only thing we would need is to get the graph based upon the results of the advanced search (that is also providing a kind of filter option) from our base table. Is it possible to get the graph based upon these results instead of on it's own data?

In case we would be able to use the advanced search from within the graph page itsselves, it would be OK as well, but so far we found only a search option on the two dimensions of the graph itsselves. The graph is based upon a group by function.

How to do this? I found some other Forum topic that told this would be possible, but we did not find how. We would need this option soon in order to deploy our application. Anyone suggestions?
J
 		Jane 10/24/2008

I recommend you to have a look at the online report/chart builder.

Here is the report/chart builder live demo:

http://demo.asprunner.net/mikl_xlinesoft_c...p/webreport.asp
J
 		jla001 author 10/24/2008

We have checked that indeed. Thereafter we initially we concluded that it is not possible to obtain a graph for which it is possible to filter the source data. That is why we posted the question. How to work around this? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=34353&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' />
Sergey Kornilov admin 10/28/2008

Every chart comes with advanced search page that you can use to filter data. This applies to both ASPRunnerPro charts and web reports.
J
 		jla001 author 10/28/2008

Yes, but we can only filter on the dimensions of the graph it selves, not on the other fields that are in the table of the graph. Suppose a table has 10 fields, we currently can only filter on the dimension and the graph value, not on the other 8 fields, which is what we need...
Sergey Kornilov admin 10/28/2008

You can search on any field that belongs to SQL query.
This means you need to add all required fields to SQL query.
If you send to support@xlinesoft.com your sample database along with SQL query we'll figure out something.