2. ASPRunnerPro General questions
  3. Use queries in "Pages" section
This topic is locked

Use queries in "Pages" section

 		12/4/2009 6:44:00 AM
ASPRunnerPro General questions
D
 danivale author

Hi to everybody,

I'm new in ASPRunner, I created test pages using table.

For example using "Project" table and "People" table AspRunner created two tabs Project and People with respective list pages, edit pages etc. OK this was a good test.

But now I need to have ONE tab containing a list page direclty from a join query, for example like the list below.

Project name comes from project table, Manager name comes from people table, all the purchases from purchase table. All the 3 tables are in join.

How can I create that list? I expected to create a query in the "query" section and then to find that query in the "pages" section, but it's not so, I see only tables in "pages" section.

I need a help, thanks!!
-------------------------------------------------------

Project name: Manager name

-------------------------------------------------------

  • Project Purchases

    -----------------------------------------------------

    -- Software XXX € 10,00

    -----------------------------------------------------

    -- Software YYY € 20,00

    -----------------------------------------------------

    -- Hardware ABC € 10,00
J
 		Jane 12/4/2009

Hi,
I recommend you to have a look at the reports.

To create report right click on the table name on the Datasource tables tab and choose Create report option. Then join all tables for this report on the Edit SQL query tab and select Project name and Manager name as group fields on the Reports: Groups fields tab.
D
 		danivale author 12/4/2009



Hi,
I recommend you to have a look at the reports.

To create report right click on the table name on the Datasource tables tab and choose Create report option. Then join all tables for this report on the Edit SQL query tab and select Project name and Manager name as group fields on the Reports: Groups fields tab.


Thanks, I try it soon.

I want that only some rows of my report could be modified (only those of purchases) I hope reports make me do it.
J
 		Jane 12/7/2009

Hi,
unfortunately reports are non-editable.

You can just set up master-detail relationships between these tables and then show data from master table manually:

http://www.xlinesoft.com/asprunnerpro/docs/show_data_from_master_table_on_detail_view_edit_add_page.htm