Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

access 2003 using sql view report not reporting all data

Discussion in 'Information Technology' started by Don, Nov 7, 2005.

  1. Don

    Don
    Expand Collapse
    Guest

    hello, I have a access 2003 application that uses the sql server for
    the database the application has an extension of adp. I have wrote
    many reports from views as the recordset and all works fine but I have
    one report that uses one view that is made with parts of three tables
    and when I open the view under query the data that shows is correct.
    When I run the report I am missing some of the data. the data is based
    on a product code as the main connector between table but the product
    code is not indexed in main database table. but I must say that when I
    run the view as a query I get the right results. Why does the report
    not report all the data? Can anyone help. Thanks
     
  2. Loading...


  3. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    Maybe a filter: check that the properties Filter, Filter On and Server
    Filter are OK.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Don" <dmckee@crystaldist.com> wrote in message
    news:1131293047.189969.23490@o13g2000cwo.googlegroups.com...
    > hello, I have a access 2003 application that uses the sql server for
    > the database the application has an extension of adp. I have wrote
    > many reports from views as the recordset and all works fine but I have
    > one report that uses one view that is made with parts of three tables
    > and when I open the view under query the data that shows is correct.
    > When I run the report I am missing some of the data. the data is based
    > on a product code as the main connector between table but the product
    > code is not indexed in main database table. but I must say that when I
    > run the view as a query I get the right results. Why does the report
    > not report all the data? Can anyone help. Thanks
    >
     
  4. Don

    Don
    Expand Collapse
    Guest

    I have not set any filters but I will review the view again but when I
    run the query on the view all the records show but when I run the
    report several are missing.
     
  5. Don

    Don
    Expand Collapse
    Guest

    I have checked the filter on the report and the filter says no.
     
  6. Don

    Don
    Expand Collapse
    Guest

    I found the issue the sql was using top 100 and I think that it was
    taking the top 100 records where there were 236 records. redid the sql
    call and removed the top 100 and all worked fine.
     
  7. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    The « Select TOP 100 PERCENT ... » statement is required if you want to add
    an ORDER BY clause to a VIEW. However, for report, you don't really need
    this because the report can make its own ordering.

    Quite possibly, you have dropped the word PERCENT by accident.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Don" <dmckee@crystaldist.com> wrote in message
    news:1131301385.099736.106410@g47g2000cwa.googlegroups.com...
    >I found the issue the sql was using top 100 and I think that it was
    > taking the top 100 records where there were 236 records. redid the sql
    > call and removed the top 100 and all worked fine.
    >
     

Share This Page