Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    Plymouth, UK
    Posts
    59

    Unanswered: Removing data from a report

    I am running a report for sales people, on business in the area, I have indicated when the business is a current advertiser or used to advertise and for graphical purposes I have given a default value of "other", can when a report runs with the actual information on the "other" be hidden, but still show "current", "lapsed" etc???????

    Please help if you can.

  2. #2
    Join Date
    Nov 2003
    Location
    Plymouth, UK
    Posts
    59

    Re: Removing data from a report

    Originally posted by Davekingwcp
    I am running a report for sales people, on business in the area, I have indicated when the business is a current advertiser or used to advertise and for graphical purposes I have given a default value of "other", can when a report runs with the actual information on the "other" be hidden, but still show "current", "lapsed" etc???????

    Please help if you can.
    COME ON GUYS THERE MUST BE A WAY?? ANY IDEAS??

  3. #3
    Join Date
    Jan 2004
    Posts
    75

    Re: Removing data from a report

    Originally posted by Davekingwcp
    COME ON GUYS THERE MUST BE A WAY?? ANY IDEAS??
    if [value] = "other" then
    [value].visible = false
    end if

    ??

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    I think you should put the code of sublimsos in the Report_Page() event


    Also you could make a Query in which you could make a new filed like

    anyName: if(yourValue = "other", [yourValue],"")

    then use this Query as a RecordSource for your Report

Posting Permissions

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