Welcome to SPN

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

Sign Up Now!

Empty Report

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

Tags:
  1. SPeterson

    SPeterson
    Expand Collapse
    Guest

    I have created a report based on a query. I know that I have several records
    in my query (8 total), and none of these records are showing up in my report.
    The record source for my report is set to the proper query. I am getting
    all of the right headings, just no data. Any tips. This seems like a pretty
    simple problem.
     
  2. Loading...

    Similar Threads Forum Date
    Elijah's Empty Chair of Freedom in Oslo Interfaith Dialogues Dec 13, 2010
    Journeying Inward: The beauty of the empty vessel Spiritual Articles Nov 29, 2010
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    How are you opening the report?
    Directly from the Database window?
    Or by code/macro that might apply a filter/WhereCondition?

    Is there any code in the report's events?

    Access might be misunderstanding some field types, as discussed here:
    http://allenbrowne.com/ser-45.html


    Open the query, and switch to SQL View (View menu.)
    Post the SQL statement.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "SPeterson" <SPeterson@discussions.microsoft.com> wrote in message
    news:CB340E7A-760D-46C5-A54C-91B9285B446C@microsoft.com...
    >I have created a report based on a query. I know that I have several
    >records
    > in my query (8 total), and none of these records are showing up in my
    > report.
    > The record source for my report is set to the proper query. I am getting
    > all of the right headings, just no data. Any tips. This seems like a
    > pretty
    > simple problem.
     
  4. SPeterson

    SPeterson
    Expand Collapse
    Guest

    No code behind the report. Here is my SQL statement

    SELECT [3 Way Collar Quotes].TimeStamp, [3 Way Collar Quotes].[Calendar
    Year], [3 Way Collar Quotes].Counterparty, [3 Way Collar Quotes].Underlying,
    [3 Way Collar Quotes].[Call Strike], [3 Way Collar Quotes].Done, [3 Way
    Collar Quotes].[Amount Done], [3 Way Collar Quotes].Trader,
    Commodities.Commodity
    FROM Commodities INNER JOIN [3 Way Collar Quotes] ON Commodities.[Commodity
    Code]=[3 Way Collar Quotes].[Commodity Code];


    "Allen Browne" wrote:

    > How are you opening the report?
    > Directly from the Database window?
    > Or by code/macro that might apply a filter/WhereCondition?
    >
    > Is there any code in the report's events?
    >
    > Access might be misunderstanding some field types, as discussed here:
    > http://allenbrowne.com/ser-45.html
    >
    >
    > Open the query, and switch to SQL View (View menu.)
    > Post the SQL statement.
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "SPeterson" <SPeterson@discussions.microsoft.com> wrote in message
    > news:CB340E7A-760D-46C5-A54C-91B9285B446C@microsoft.com...
    > >I have created a report based on a query. I know that I have several
    > >records
    > > in my query (8 total), and none of these records are showing up in my
    > > report.
    > > The record source for my report is set to the proper query. I am getting
    > > all of the right headings, just no data. Any tips. This seems like a
    > > pretty
    > > simple problem.

    >
    >
    >
     
  5. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    That's a simple query. No criteria at all.

    TimeStamp is a reserved word.
    Not sure if that will mess it up.

    Presumably [Commodity Code] is the same field type and size in both tables,
    and you have declared a relationship with Referential Integrity (Tools |
    Relationships.)

    You see 8 records when you open the query directly.
    But no records when you open the report itself?
    Are you opening it directly from the Database window, or via a button?

    With the report open (in Preview), press Ctrl+G to open the Immediate
    Window, and enter:
    ? Reports![NameOfYourReportHere].FilterOn
    ? Reports![NameOfYourReportHere].Filter
    ? Reports![NameOfYourReportHere].RecordSource
    It would be interesting to know if the filter is on, and if so what it is.
    (Even though Access cannot be trusted to maintain the FilterOn property
    correctly for reports, so this might not prove anything.)

    Always worth trying a compact/repair under:
    Tools | Database Utilities

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "SPeterson" <SPeterson@discussions.microsoft.com> wrote in message
    news:B717F111-A50E-4B60-BFF7-447A41C5784F@microsoft.com...
    > No code behind the report. Here is my SQL statement
    >
    > SELECT [3 Way Collar Quotes].TimeStamp,
    > [3 Way Collar Quotes].[Calendar Year],
    > [3 Way Collar Quotes].Counterparty,
    > [3 Way Collar Quotes].Underlying,
    > [3 Way Collar Quotes].[Call Strike],
    > [3 Way Collar Quotes].Done,
    > [3 Way Collar Quotes].[Amount Done],
    > [3 Way Collar Quotes].Trader,
    > Commodities.Commodity
    > FROM Commodities INNER JOIN [3 Way Collar Quotes]
    > ON Commodities.[Commodity Code]=
    > [3 Way Collar Quotes].[Commodity Code];
    >
    > "Allen Browne" wrote:
    >
    >> How are you opening the report?
    >> Directly from the Database window?
    >> Or by code/macro that might apply a filter/WhereCondition?
    >>
    >> Is there any code in the report's events?
    >>
    >> Access might be misunderstanding some field types, as discussed here:
    >> http://allenbrowne.com/ser-45.html
    >>
    >>
    >> Open the query, and switch to SQL View (View menu.)
    >> Post the SQL statement.
    >>
    >> "SPeterson" <SPeterson@discussions.microsoft.com> wrote in message
    >> news:CB340E7A-760D-46C5-A54C-91B9285B446C@microsoft.com...
    >> >I have created a report based on a query. I know that I have several
    >> >records
    >> > in my query (8 total), and none of these records are showing up in my
    >> > report.
    >> > The record source for my report is set to the proper query. I am
    >> > getting
    >> > all of the right headings, just no data. Any tips. This seems like a
    >> > pretty
    >> > simple problem.
     
  6. SPeterson

    SPeterson
    Expand Collapse
    Guest

    I don't think the time stamp is throwing it off, because that field is used
    in one of my section headers and it works fine.

    Commodity Code is the same field type and size in both tables and there is a
    relationship there.

    I am opening the report directly from the database window, and the report is
    showing everything correctly, but just no items in the detail section where
    the data should go.

    I tried entering that information into the Immediate Window and no result,
    same problem. No filter.

    Compact/Repair didn't help either.

    This is so confusing, no idea why this is not working. Thanks for you help.

    "Allen Browne" wrote:

    > That's a simple query. No criteria at all.
    >
    > TimeStamp is a reserved word.
    > Not sure if that will mess it up.
    >
    > Presumably [Commodity Code] is the same field type and size in both tables,
    > and you have declared a relationship with Referential Integrity (Tools |
    > Relationships.)
    >
    > You see 8 records when you open the query directly.
    > But no records when you open the report itself?
    > Are you opening it directly from the Database window, or via a button?
    >
    > With the report open (in Preview), press Ctrl+G to open the Immediate
    > Window, and enter:
    > ? Reports![NameOfYourReportHere].FilterOn
    > ? Reports![NameOfYourReportHere].Filter
    > ? Reports![NameOfYourReportHere].RecordSource
    > It would be interesting to know if the filter is on, and if so what it is.
    > (Even though Access cannot be trusted to maintain the FilterOn property
    > correctly for reports, so this might not prove anything.)
    >
    > Always worth trying a compact/repair under:
    > Tools | Database Utilities
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "SPeterson" <SPeterson@discussions.microsoft.com> wrote in message
    > news:B717F111-A50E-4B60-BFF7-447A41C5784F@microsoft.com...
    > > No code behind the report. Here is my SQL statement
    > >
    > > SELECT [3 Way Collar Quotes].TimeStamp,
    > > [3 Way Collar Quotes].[Calendar Year],
    > > [3 Way Collar Quotes].Counterparty,
    > > [3 Way Collar Quotes].Underlying,
    > > [3 Way Collar Quotes].[Call Strike],
    > > [3 Way Collar Quotes].Done,
    > > [3 Way Collar Quotes].[Amount Done],
    > > [3 Way Collar Quotes].Trader,
    > > Commodities.Commodity
    > > FROM Commodities INNER JOIN [3 Way Collar Quotes]
    > > ON Commodities.[Commodity Code]=
    > > [3 Way Collar Quotes].[Commodity Code];
    > >
    > > "Allen Browne" wrote:
    > >
    > >> How are you opening the report?
    > >> Directly from the Database window?
    > >> Or by code/macro that might apply a filter/WhereCondition?
    > >>
    > >> Is there any code in the report's events?
    > >>
    > >> Access might be misunderstanding some field types, as discussed here:
    > >> http://allenbrowne.com/ser-45.html
    > >>
    > >>
    > >> Open the query, and switch to SQL View (View menu.)
    > >> Post the SQL statement.
    > >>
    > >> "SPeterson" <SPeterson@discussions.microsoft.com> wrote in message
    > >> news:CB340E7A-760D-46C5-A54C-91B9285B446C@microsoft.com...
    > >> >I have created a report based on a query. I know that I have several
    > >> >records
    > >> > in my query (8 total), and none of these records are showing up in my
    > >> > report.
    > >> > The record source for my report is set to the proper query. I am
    > >> > getting
    > >> > all of the right headings, just no data. Any tips. This seems like a
    > >> > pretty
    > >> > simple problem.

    >
    >
    >
     
  7. SPeterson

    SPeterson
    Expand Collapse
    Guest

    Just figured it out. I was using the wizard and I chose to view the data by
    Commodities, which is the table with no information, I think I just thought
    that was a grouping option. I knew it was something simple.

    "Allen Browne" wrote:

    > That's a simple query. No criteria at all.
    >
    > TimeStamp is a reserved word.
    > Not sure if that will mess it up.
    >
    > Presumably [Commodity Code] is the same field type and size in both tables,
    > and you have declared a relationship with Referential Integrity (Tools |
    > Relationships.)
    >
    > You see 8 records when you open the query directly.
    > But no records when you open the report itself?
    > Are you opening it directly from the Database window, or via a button?
    >
    > With the report open (in Preview), press Ctrl+G to open the Immediate
    > Window, and enter:
    > ? Reports![NameOfYourReportHere].FilterOn
    > ? Reports![NameOfYourReportHere].Filter
    > ? Reports![NameOfYourReportHere].RecordSource
    > It would be interesting to know if the filter is on, and if so what it is.
    > (Even though Access cannot be trusted to maintain the FilterOn property
    > correctly for reports, so this might not prove anything.)
    >
    > Always worth trying a compact/repair under:
    > Tools | Database Utilities
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "SPeterson" <SPeterson@discussions.microsoft.com> wrote in message
    > news:B717F111-A50E-4B60-BFF7-447A41C5784F@microsoft.com...
    > > No code behind the report. Here is my SQL statement
    > >
    > > SELECT [3 Way Collar Quotes].TimeStamp,
    > > [3 Way Collar Quotes].[Calendar Year],
    > > [3 Way Collar Quotes].Counterparty,
    > > [3 Way Collar Quotes].Underlying,
    > > [3 Way Collar Quotes].[Call Strike],
    > > [3 Way Collar Quotes].Done,
    > > [3 Way Collar Quotes].[Amount Done],
    > > [3 Way Collar Quotes].Trader,
    > > Commodities.Commodity
    > > FROM Commodities INNER JOIN [3 Way Collar Quotes]
    > > ON Commodities.[Commodity Code]=
    > > [3 Way Collar Quotes].[Commodity Code];
    > >
    > > "Allen Browne" wrote:
    > >
    > >> How are you opening the report?
    > >> Directly from the Database window?
    > >> Or by code/macro that might apply a filter/WhereCondition?
    > >>
    > >> Is there any code in the report's events?
    > >>
    > >> Access might be misunderstanding some field types, as discussed here:
    > >> http://allenbrowne.com/ser-45.html
    > >>
    > >>
    > >> Open the query, and switch to SQL View (View menu.)
    > >> Post the SQL statement.
    > >>
    > >> "SPeterson" <SPeterson@discussions.microsoft.com> wrote in message
    > >> news:CB340E7A-760D-46C5-A54C-91B9285B446C@microsoft.com...
    > >> >I have created a report based on a query. I know that I have several
    > >> >records
    > >> > in my query (8 total), and none of these records are showing up in my
    > >> > report.
    > >> > The record source for my report is set to the proper query. I am
    > >> > getting
    > >> > all of the right headings, just no data. Any tips. This seems like a
    > >> > pretty
    > >> > simple problem.

    >
    >
    >
     

Share This Page