Alpha Video Training
Results 1 to 5 of 5

Thread: Suppress detail in report to show only totals

  1. #1
    Member Robert Rough's Avatar
    Real Name
    Robert Rough
    Join Date
    Sep 2004
    Location
    Hamilton, Scotland
    Posts
    307

    Default Suppress detail in report to show only totals

    Is there any way to suppress the details in a report to show only total values for each field or calculated values such as annualised totals derived from totalised fields.
    Thank you
    Robert

  2. #2
    "Certified" Alphaholic G Gabriel's Avatar
    Real Name
    G. Gabriel
    Join Date
    Oct 2004
    Posts
    7,204

    Default Re: Suppress detail in report to show only totals

    Robert:
    Eliminate the details section of the report.
    Put the totals in the report footer.

  3. #3
    Member Robert Rough's Avatar
    Real Name
    Robert Rough
    Join Date
    Sep 2004
    Location
    Hamilton, Scotland
    Posts
    307

    Default Re: Suppress detail in report to show only totals

    Thank you for your prompt reply Gabriel.

    My report runs to about 60 pages, about 70 sites giving detail invoice information for each site and then providing summarised totals for each site.

    2 questions.

    How do i eliminate the detail. I tried highlighting detail and rt click delete but nothing happened. i tried hiding the detail. the detail was hidden in design but still showed up in report. i tried deleting all objects in detail section of report and closing up detail but still left a gap abour quarter of inch which showed up on the report. Any clues how to eliminate the detail.

    Do i copy the site totals in the site footer to the report footer.


    Thanks, Robert

  4. #4
    "Certified" Alphaholic G Gabriel's Avatar
    Real Name
    G. Gabriel
    Join Date
    Oct 2004
    Posts
    7,204

    Default Re: Suppress detail in report to show only totals

    How do i eliminate the detail
    Click Report from the menu bar in design mode, choose properties, uncheck "has details section".

    Do i copy the site totals in the site footer
    No. Drag the field that has the value to the footer, a window will open asking you what do you want to do?, choose "totals". It will total it for you.

  5. #5
    Member Robert Rough's Avatar
    Real Name
    Robert Rough
    Join Date
    Sep 2004
    Location
    Hamilton, Scotland
    Posts
    307

    Default Re: Suppress detail in report to show only totals

    Brilliant Gabriel,

    I do as you suggest.

    Many thanks,
    Robert

Similar Threads

  1. Suppress Detail in Report
    By Doug Short in forum Alpha Five Version 7
    Replies: 1
    Last Post: 03-15-2006, 12:52 PM
  2. Suppress detail printing
    By John Gamble in forum Archived Wishlist
    Replies: 2
    Last Post: 02-02-2006, 09:30 AM
  3. suppress report-no pages
    By geoff m in forum Alpha Five Version 5
    Replies: 6
    Last Post: 12-02-2004, 06:28 AM
  4. Report - show no detail records
    By Tom Patten in forum Alpha Five Version 4
    Replies: 1
    Last Post: 04-20-2002, 07:29 AM
  5. Show 'child' record totals only in report.
    By Tony Grimley in forum Alpha Five Version 4
    Replies: 3
    Last Post: 01-21-2001, 04:03 AM

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
  •