Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Show fields if data present (Access2000-03)

    Hi, long time no see? :-)

    I have a design issue.
    My Report has subreports.
    Subreport need to have additional field that will only show when there is a data.
    What is the best way to handle this having in mind that headers will have to be appearing only if data is present as well.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show fields if data present (Access2000-03)

    Is it really that important to hide the header if there are no data for that field? Why make life so difficult for yourself?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show fields if data present (Access2000-03)

    Wellllll...
    when there is date in those fields it means someone isn't doing their job very well.
    So when there is no need to show - we would like to not to. You know - to have prettier face!
    Make sense?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show fields if data present (Access2000-03)

    No doubt it is possible, but I'd need to see (a stripped down copy of) the database to form an idea of how it works.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show fields if data present (Access2000-03)

    Let's say (before the stripping:-)) that it use to be the most regular Report.
    Headers and text fields displaying the data. Based on Crosstab query made into a table.
    So when crosstab query is pulling NULL values - it looks like: <> FT PT
    There shouldn't be any <>.
    But we can not be losing these records so we have decided to display them in UNKNOWN field.
    We are hoping that people are going to enter data properly and UNKNOWN field will be having no values but IF there is one - we can't lose it - we need to have it counted.
    So it is simple Headers:
    ID, Name, SumOfFTPT<>, FT, PT,UNKNOWN.

    Nothing complicated except hiding it part.
    Can I do If NULL then "" and same for the Headers?

    Thanks

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show fields if data present (Access2000-03)

    If you designed the report with fixed controls, you'll have a problem anyway - if <> doesn't occur, you'll get an error message.
    If you designed a dynamic report, the problem will solve itself - if <> doesn't occur, it will not be displayed in the report.

  7. #7
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show fields if data present (Access2000-03)

    But Headers!!!! Headers!!!!!!:-(

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show fields if data present (Access2000-03)

    See my previous reply!!!!

  9. #9
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show fields if data present (Access2000-03)

    I am sorry I can't see how this will affect headers!

    If I will code in If Unknown.Value="" then Header.value true
    Something like that should work right?

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show fields if data present (Access2000-03)

    Without seeing your database I cannot offer further assistance. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •