Alpha Video Training
Results 1 to 7 of 7

Thread: Need advice ...

  1. #1
    Volunteer Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,784

    Default Need advice ...

    I use forms to allow users to select criteria for reports. If the fields on the form are form the underlying table, there are problems. For example, if 2 users on a network try running the report at the same time, the second user gets an error locking message. A way around this is to use layout variables instead of fields from the underlying table. Then, each field on the form is based on a layout variable instead of being based on a table field. Then I use Record List-Combo box field types so that I can attach lookups to each field. This works great, but with one BIG exception. If more than 2 or 3 fields are on the form, the drawing of the screen is annoyingly SLOW. And even slower as more fields are added. So slow, as to be unacceptable. Has anyone else encountered this? If I am doing something wrong, please someone tell me. Or if there is a better way to design report selection screens that won't lock with simultaneous users, please let me know.

    All help would be greatly appreciated.

    Thanks.

    Gary

  2. #2
    Former Alpha Employee JerryBrightbill's Avatar
    Real Name
    Jerry Brightbill
    Join Date
    Apr 2000
    Posts
    5,173

    Default RE: Need advice ...

    Gary

    The Record List-Combo box uses a query to fill the lookup, so each instance adds another query which will make refreshing the data very slow. I don't have an answer to the other problem.

    Jerry

  3. #3
    Volunteer Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,784

    Default RE: Need advice ...

    Jerry,

    Thanks for responding.

    Okay, if that method is very slow, what other way would you recommend for report selection criteria?

    p.s., and what uses would be suggested for the Record List-Combo boxes, if they are so slow? How are they intended to be used?

    Gary

  4. #4
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: Need advice ...

    Gary,

    In one of my apps I've created a form with 30 checkboxes, each representing a filtering value for records to be included in the report. This has proven very popular and would be useful in situations where certain fields in your primary table have a finite number of potential field values. When the selections are complete the user presses button to run report. The button's script builds a filter expression based on which checkboxes were selected.

    -- tom

  5. #5
    Volunteer Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,784

    Default RE: Need advice ...

    Hi Tom,

    That is a very slick, neat way to go. Thanks.

    Gary

  6. #6
    Volunteer Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,784

    Default RE: Need advice ...

    Tom,

    I want to thank you again, big time! You have opened up a whole new approach for me with this. I am creating much more user friendly, and visually appealing report selection criteria screens.


    Have a great day ...

    Gary

  7. #7
    "Certified" Alphaholic
    Real Name
    Russ Boehle
    Join Date
    Mar 2000
    Location
    Connecticut
    Posts
    2,767

    Default RE: Need advice ...

    Gary,
    Any chance of posting a screen shot of what you end up with. I'm working in this area also and would love to see your solution.

    Russ

Similar Threads

  1. I really need some advice / help
    By wayne merchant in forum Alpha Five Version 6
    Replies: 1
    Last Post: 07-28-2005, 06:48 AM
  2. Need Advice
    By Tommy Thompson in forum Web Application Server v6
    Replies: 5
    Last Post: 04-01-2005, 09:35 AM
  3. Re: A Little Advice?
    By karlbeau in forum Alpha Five Version 5
    Replies: 3
    Last Post: 06-10-2004, 09:45 AM
  4. Your Advice
    By Phil Rolf in forum Alpha Five Version 5
    Replies: 2
    Last Post: 04-08-2003, 04:18 AM
  5. Advice Please
    By forskare in forum Alpha Five Version 4
    Replies: 0
    Last Post: 10-23-2000, 08:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •