This topic is locked

Reports using Custom Views

12/19/2011 5:19:03 PM
PHPRunner General questions
E
espiker author

I just learning PHPRunner 6.0.
The menus on program appear to be able to do the following:

  1. Create a custom view of a table - I can make this work
  2. Create a report using a table - I can make this work
  3. Create a report using a custom view - this does not work. no custom views are listed as available.
  4. In the "Query Designer" tab of the Report there is a "Add Table" tab, which when I select it has 3 tab's "Table", "View", "System".
    I assumed the tab marked "View" means I can select a custom view to use in the report generation, but it does not list the custom view I created.
    So the question is can "Custom Views" be used as the basis of a Report generation and if so how?

    Also, what do the tabs "View" and "System" mean on the table selection part of the report query designer?
    I have looked through the manual and the forum, but can find no reference to this question.
    Thanks in advance for any assistance.

Sergey Kornilov admin 12/20/2011

'View' tab means database view, 'System' tab means system tables.
Proceed to your custom view, copy SQL Query of that custom view, proceed to your report and paste that SQL there. This is it.