Alpha Video Training
Results 1 to 5 of 5

Thread: Limiting detail records in report by number

  1. #1
    Roman Galaska
    Guest

    Default Limiting detail records in report by number

    I have a report for a set - it works fine and I get the parent record in the group section and the child records in the detail. I have used the filter & sort to give me the right recs in the order I want (most recent first) - how can I declare that I only want 5 records to appear on the report ? I can't think of a way to filter them ... help please

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

    Default RE: Limiting detail records in report by number

    Do you mean five per page?

    Do you mean first five, and only the first five?

    Do you mean any five, but only five?

    -- tom

  3. #3
    Member
    Real Name
    robert adler
    Join Date
    Apr 2000
    Location
    Boynton Beach, BL
    Posts
    591

    Default RE: Limiting detail records in report by number

    Roman:

    In the report design go to the Report menu;

    Select Records
    press the Create Filter/Order Using Genie
    in the sub select objects choose top nth selected records.



    I hope this helps.

    bob adler

  4. #4
    Roman Galaska
    Guest

    Default RE: Limiting detail records in report by number

    Just to make clear what I would like to do :-

    The parent table contains details of Agents - the child has notes made by/about the agent. The report shows the agent name & code in the group section - I then want only to show the last 5 notes entered by the agent in the detail. To limit the detail to the notes for that agent i had the following as my filter :-

    Agent_Code = Agents_Notes->Agent

    That works fine - I now only see details belonging to that agent. Using the subselect in the genie to restrict it to the top 4 records changes the code in the filter to :-

    top_records(4,"Agent_Code = Agents_Notes->Agent")

    When I try to run the report now - the filter doesn't seem to work at all - I get All child records as the detail on each agent.

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

    Default RE: Limiting detail records in report by number

    Roman,

    I can think of two brute force solutions:

    1) run a query before the report and mark the desired records, then change the filter to print only the marked records for each agent.

    or

    2) run a query before the report, and copy the desired records to a temporary table, then base your report on the temporary table.


    Perhaps others will suggest simpler ideas.

    -- tom

Similar Threads

  1. Report w/extra detail records
    By Steve Wood in forum Alpha Five Version 6
    Replies: 6
    Last Post: 05-11-2005, 02:56 PM
  2. Limiting records for a report
    By Russell Rowton in forum Alpha Five Version 5
    Replies: 2
    Last Post: 01-23-2003, 01:10 AM
  3. Ordering Detail records in a report
    By Rob Schippers in forum Alpha Five Version 4
    Replies: 5
    Last Post: 12-06-2002, 11:56 AM
  4. Limiting the number of lines on a report.
    By Alan Stern in forum Alpha Five Version 4
    Replies: 2
    Last Post: 04-24-2002, 09:05 AM
  5. Limiting detail records
    By GregOnline in forum Alpha Five Version 4
    Replies: 3
    Last Post: 11-01-2001, 03:57 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
  •