Welcome to SPN

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

Sign Up Now!

Unexpected Values on Reports

Discussion in 'Information Technology' started by Simon Harris, Jul 28, 2006.

  1. Simon Harris

    Simon Harris
    Expand Collapse
    Guest

    Hi All,

    I have a report which includes two date fields. These are coming out with
    unexpected values.

    The reports data source is QRY_INVOICES. Looking at the query on its own,
    the values look fine.

    When I run the report, the values for the two dates are always 07/01/2006
    and 01/01/2006 (Thought I would mention the values in case there is anything
    significant about them).

    I have also noticed that these do not change when moving from record to
    record within the report - They always stay static. I thought perhaps I had
    done something to make them always retain some value, but if I drag these
    columns onto the report as fresh objects, I see the same behaviour.

    I should also mention that the database recently went corrupt, and I had to
    create a fresh DB and import all the objects.

    Very odd, I am at a loss as to what to try next. Any help/suggestions much
    appreciated.

    Thanks,
    Simon.

    --
    -
    * Please reply to group for the benefit of all
    * Found the answer to your own question? Post it!
    * Get a useful reply to one of your posts?...post an answer to another one
    * Search first, post later : http://www.google.co.uk/groups
    * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
     
  2. Loading...


  3. Simon Harris

    Simon Harris
    Expand Collapse
    Guest

    And I've just noticed that them two dates are not in the data any where!

    Dont geddit!

    "Simon Harris" <too-much-spam@makes-you-fat.com> wrote in message
    news:%23PZy4odqGHA.4760@TK2MSFTNGP03.phx.gbl...
    > Hi All,
    >
    > I have a report which includes two date fields. These are coming out with
    > unexpected values.
    >
    > The reports data source is QRY_INVOICES. Looking at the query on its own,
    > the values look fine.
    >
    > When I run the report, the values for the two dates are always 07/01/2006
    > and 01/01/2006 (Thought I would mention the values in case there is
    > anything significant about them).
    >
    > I have also noticed that these do not change when moving from record to
    > record within the report - They always stay static. I thought perhaps I
    > had done something to make them always retain some value, but if I drag
    > these columns onto the report as fresh objects, I see the same behaviour.
    >
    > I should also mention that the database recently went corrupt, and I had
    > to create a fresh DB and import all the objects.
    >
    > Very odd, I am at a loss as to what to try next. Any help/suggestions much
    > appreciated.
    >
    > Thanks,
    > Simon.
    >
    > --
    > -
    > * Please reply to group for the benefit of all
    > * Found the answer to your own question? Post it!
    > * Get a useful reply to one of your posts?...post an answer to another one
    > * Search first, post later : http://www.google.co.uk/groups
    > * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
    >
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 17 Jul 2006 21:25:46 +0100, "Simon Harris"
    <too-much-spam@makes-you-fat.com> wrote:

    >And I've just noticed that them two dates are not in the data any where!
    >
    >Dont geddit!


    Sounds to me like they're in unbound Textboxes. What is the Control
    Source property of the textbox in which one of these dates appears?

    John W. Vinson[MVP]
     

Share This Page