This topic is locked

Creating reports based on user submitted variables

3/5/2009 10:51:20 AM
PHPRunner General questions
S
smalltime author

I am playing with phprunner, and think it may be quite useful, but I have a couple of questions;
a) can you create a report that prompts for user input (say,a date) and uses that as part of the SQL query , e.g. to report on records between two dates, etc
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=11122&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' /> I have created master / detail relationships between fields in tables, but in 'edit' mode I can't figure out how to show the field as a drop down list.
Are either of these things possible?

Sergey Kornilov admin 3/5/2009
  1. You can point users to Advanced Search page where they can enter search criteria including fate interval.
  2. To change field 'Edit as' type proceed to Visual Editor and double-click on field. Set 'Edit as' type to 'Lookup wizard'.

S
smalltime author 3/5/2009

Thankyou for the prompt response, I'll have at look at these and see if they solve my problems.