Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2001
    Location
    Fort Worth,Tx, USA
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing report titles

    I have report titles ( Labels ) that change occasionally and I was trying to figure out if there was a was to change them without having to open up each report.

    The particular example I have is a company name in the report or page header.

    Seems like there should be an easier way.

    Any suggestions?

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing report titles

    You might try opening up the report(s)in design view and for a title use an existing field from the query or table from which the report gets its data. Something like a text box you could create in the report header that would have its date source set to ="Report"&" "&"ON"&" "&[CompanyNameField].

    Hope this helps.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Changing report titles

    The simplest way to handle this is have a table that holds constant values like Company Name. I usually call the table something like USysSetup or tblDBConstants. It has two fields, ConstName and ConstValue. You enter a record for each "constant" you want to store, i.e., [ConstName] ="Company Name" and [ConstValue]="My Company".

    Then you can use a user-defined function or a DLookup to retrieve the value to use in a textbox in the header of your report. That way the report updates itself when you change the value in the table.
    Charlotte

Posting Permissions

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