How to proceed using Allen Browne search interface

R

Rick

I am trying to build an application that will track printer usage. I
am using a search interface that I downloaded form Allen Browne's web
site (excellent stuff!!). My concept is this;
1. Interface allows user to choose search criteria based on type of
pages printed, specific printer, and time frame of printer usage
audit.
2. After user selects the criteria the form displays the filtered
data and changes the columns that are displayed based on the criteria
chosen.
3. A chart displays (preferably on the same screen as the current
search form) the filtered data.

I have number 1 above done and it works well. I am now at step 2 but
I am not sure of the best way to proceed. I the search form only has
room for 6 labels and text boxes. I have 36 groups of data that could
be displayed depending on the criteria the user chooses. I think I
could use fixed label and text boxes and use a loop to choose what the
labels and text boxes represent but I'm not sure on how to create
clean/short code for this. In addition, I'm not sure how to even
start number 3. I know of several ways to create the chart but I'm
not sure of the best way. Should I use a separate form that is
displayed at the same time as the search form? Should I put the chart
in the detail section of the current search form? What is the best
way to make it dynamic? Change the chart information via SQL or
connect the chart to the search form filter?

Hopefully this link will take you to an image of my interface:
http://docs.google.com/Doc?id=dpqcvxj_4gx6s6f

I appreciate any help provided. You guys provide a great service and
I appreciate what you do for guys like me.

Thanks.
 
Top