Alpha Video Training
Results 1 to 13 of 13

Thread: Report Problems

  1. #1
    Member
    Real Name
    graham miller
    Join Date
    Jul 2007
    Posts
    13

    Default Report Problems

    I have created a letter that includes name and ref at top and a detailed section of 5 products, name and code at bottom of page. The letter displays perfectly but then next page will include the details section again. This repeats through out the report. Any ideas?

  2. #2
    VAR
    Real Name
    Cheryl Lemire
    Join Date
    Jul 2003
    Location
    Pembroke Pines, FL
    Posts
    2,914

    Default Re: Report Problems

    Hi Graham,

    I am afraid we are going to need more information in order to assist. Is this a report or letter? I am going to assume 'report' for the remaining questions. Are the titles in a report header, page header, group header, detail header or in the actual detail section of the report? Same question for what you have at the 'bottom'. Is the report based on a table or set? What is the set structure if it is a set? It would be best to zip up your table/set that the report is based on and attach it to this thread and explain in detail the steps we need to take to see what you see and let us know what you want to see instead.
    Cheryl
    #1 Designs By Pagecrazy
    http://pagecrazy.com/

  3. #3
    Member
    Real Name
    graham miller
    Join Date
    Jul 2007
    Posts
    13

    Default Re: Report Problems

    using the report to send customers invoices.
    Report is from a set Orders--->orders products
    The report is layed out as follows,
    Report
    group order_id (break change on order_id, start each group on new page)
    group order header (contains customer address, order id and customers name)
    group 2 (break change on product model, region keep group togther on one page, columns in group 5, balance column height)
    details (region shrink contains of band)

    it displays fine for first record.. then repeats group 2 on next page.. this repeats through out the reports.

    max number of products per order is 5.

    thanks

  4. #4
    Member
    Real Name
    graham miller
    Join Date
    Jul 2007
    Posts
    13

    Default Re: Report Problems

    I attached an example of the database with the sets, tables used and the report.
    I must be missing something, I read other topics on it, but just can't seem to get it right. any help would be appriacated

  5. #5
    "Certified" Alphaholic
    Real Name
    Tom Baker
    Join Date
    Jun 2006
    Location
    Near Cherry Hill, NJ
    Posts
    1,296

    Default Re: Report Problems

    Your attached zip file is password protected - without the password file cannot be unzipped.

    Tom Baker

  6. #6
    Member
    Real Name
    graham miller
    Join Date
    Jul 2007
    Posts
    13

    Default Re: Report Problems

    Its the back up of the database. Should be able to restore it. The database is stored c:\database. I added below a zipped version of that folder.
    thanks for taking a look.

  7. #7
    "Certified" Alphaholic
    Real Name
    Tom Baker
    Join Date
    Jun 2006
    Location
    Near Cherry Hill, NJ
    Posts
    1,296

    Default Re: Report Problems

    Graham

    First - why was the detail section of group 2 over 7 inches with Product name up top and part number down the bottom. That would cause a large gap between the two records and would cause the second record or third record or fourther record to printed on another page due to exceeding the length of a page.

    I re - zip you file with a new report dnote2. All I did was to shorten the length of the detail region and moved the two fields closer together.

    Look at that and if that is not what you want - I will need a better explanation in order to understand the problem.

    Tom

  8. #8
    Member
    Real Name
    graham miller
    Join Date
    Jul 2007
    Posts
    13

    Default Re: Report Problems

    the codes at the bottom are ref for the factory to process the order. We have designed the letter and the codes need to be as close to the bottom as possible. The gap between the Product names and the code have pre printed text which is on the pre printed letter.
    The report is still duplicating the Detail region?
    If you go to next record the the detail section is duplated.
    and the next record does the same.

  9. #9
    "Certified" Alphaholic Tim Kiebert's Avatar
    Real Name
    Tim Kiebert
    Join Date
    Jul 2004
    Location
    Geelong, Victoria, Australia
    Posts
    2,785

    Default Re: Report Problems

    The duplicate records are a deleted record/index update kind a issue. If you notice the actual values in the report. One set of them are not in the table. If you undelete the deleted records you will see those values. If you just want to take my word for it then right click on the orders_products table and choose Update Indexes. They probably got outa synch during development.
    Tim Kiebert
    Eagle Creek Citrus
    A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

  10. #10
    "Certified" Alphaholic
    Real Name
    Tom Baker
    Join Date
    Jun 2006
    Location
    Near Cherry Hill, NJ
    Posts
    1,296

    Default Re: Report Problems

    Tim

    You are absolutely corrent - when the tables were packed and index updated - the report as is worked correctly. Didn't even think to go that route.

    I see you slept in today after your long night.


    Graham

    I did not know that the report was being printed on a preprinted form - that is why I improperly corrected your report. Sorry about that - but following Tim's advice, your report should be okay now. Keep us posted.

    Hope so

    Tom

  11. #11
    "Certified" Alphaholic Tim Kiebert's Avatar
    Real Name
    Tim Kiebert
    Join Date
    Jul 2004
    Location
    Geelong, Victoria, Australia
    Posts
    2,785

    Default Re: Report Problems

    Quote Originally Posted by Tbaker View Post
    I see you slept in today after your long night.


    Tom
    I wish.:( I got a call three hours after shutting my eyes that one of our trucks at work wouldn't start and had to go in to assist.
    Tim Kiebert
    Eagle Creek Citrus
    A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

  12. #12
    "Certified" Alphaholic
    Real Name
    Tom Baker
    Join Date
    Jun 2006
    Location
    Near Cherry Hill, NJ
    Posts
    1,296

    Default Re: Report Problems

    Tim

    I spent 20 odd years in the trucking business - believe me I sympathise - how about going in to a drop yard at 3 in the morning when the temp was about 12 degrees and snowing. At least it was warm this morning in Geelong.


    Tom

  13. #13
    Member
    Real Name
    graham miller
    Join Date
    Jul 2007
    Posts
    13

    Default Re: Report Problems

    thanks alot, worked
    5.45am here in the uk, maybe I'll get some sleep.

    Thanks again.

Similar Threads

  1. Report problems
    By Donald Duck in forum Alpha Five Version 5
    Replies: 4
    Last Post: 08-30-2006, 02:48 PM
  2. More report problems!
    By Martin in forum Alpha Five Version 4
    Replies: 15
    Last Post: 06-24-2006, 09:38 PM
  3. Report problems--could be me....
    By Monica Hammers in forum Alpha Five Version 5
    Replies: 21
    Last Post: 07-26-2005, 05:01 AM
  4. Report problems
    By mary Barkworth in forum Alpha Five Version 6
    Replies: 18
    Last Post: 12-20-2004, 11:49 AM
  5. Problems with summary report
    By Joseph Mann in forum Alpha Five Version 4
    Replies: 2
    Last Post: 04-03-2001, 10:49 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
  •