Welcome to SPN

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

Sign Up Now!

Table to Report

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

Tags:
  1. Tdahlman

    Tdahlman
    Expand Collapse
    Guest

    I created a report based a query involving 3 tables. It worked fine. Then I
    realized that in one of the tables I had 2 fields that I didn't need in my
    database at all. So I went into that table and deleted two fields. These
    fields were in my query which was related to the Report. Now everytime I open
    my report it asks me to enter the parameter value for each field before it
    will let me in. I don't have these anywhere in my report anymore and i want
    to know how to get rid of hte prompt boxes for the parameter values.
    Thanks in advance.
    Travis
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Cong defers plans to table Nanavati report (NDTV) Breaking News May 7, 2005
    Sikh News Govt not to table Nanavati report in current session (Outlook India) Breaking News May 6, 2005
    Sikh News India: Government unlikely to table Nanavati riot report Breaking News Feb 25, 2005
    Sikh News Government unlikely to table Nanavati riot report:- Breaking News Feb 25, 2005
    Sikh News Nanavati report to be tabled in Budget session Breaking News Feb 14, 2005

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Four places that I can think of that you need to check:
    1. The query - mybe the field still defined there (run the query separatly
    and check if you get prompt by the parameters

    2. The Report Record Surce, just as th query it might stll be defined there

    3. In the report you might have this fields, open he report in design view,
    and check if any of the text boxes there is bound to this fields - if that
    the ase remove the fields

    4. You might have used this fields in the sortin and groupng of the report -
    if that the case remove them from there

    It might be even all of the above, so you might need t check them all
    --
    Good Luck
    BS"D


    "Tdahlman" wrote:

    > I created a report based a query involving 3 tables. It worked fine. Then I
    > realized that in one of the tables I had 2 fields that I didn't need in my
    > database at all. So I went into that table and deleted two fields. These
    > fields were in my query which was related to the Report. Now everytime I open
    > my report it asks me to enter the parameter value for each field before it
    > will let me in. I don't have these anywhere in my report anymore and i want
    > to know how to get rid of hte prompt boxes for the parameter values.
    > Thanks in advance.
    > Travis
     
  4. betwalk@gmail.com

    betwalk@gmail.com
    Expand Collapse
    Guest

    Tdahlman wrote:
    > I created a report based a query involving 3 tables. It worked fine. Then I
    > realized that in one of the tables I had 2 fields that I didn't need in my
    > database at all. So I went into that table and deleted two fields. These
    > fields were in my query which was related to the Report. Now everytime I open
    > my report it asks me to enter the parameter value for each field before it
    > will let me in. I don't have these anywhere in my report anymore and i want
    > to know how to get rid of hte prompt boxes for the parameter values.
    > Thanks in advance.
    > Travis

    ----------------
    Even though you may have deleted the text boxes from the report, the
    references are still there somewhere. Two places to look:

    --Go to the sorting and grouping dialog and be sure they are not in
    there
    --Go to the data tab of the report's properties, look in the underlying
    query and be sure the references to these fields has be deleted. (If
    the query is saved with a name, you can also just edit that.)

    hth-

    Betsy
     

Share This Page