Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Unanswered: Conditional Formatting Save reverts back to original subReport

    I have a report which includes a subReport.

    The report detail data is from a query. No problem here.

    The sub report is based on a calculation query.

    I use "Save As . . ." to create a new report and subReport. (Why recreate a whole new report from scratch, right?)

    The problem is that when I use "Conditional Formating" in the copied subReport to change a field value it is saved back to the original subReport. Not my intention!

    If I change the field value back in the original subReport with "Conditional Formatting" it changes back in the copied subReport.

    Back and forth . . . back and forth . . . I'm going nuts here. Ha!

    What am I missing?

    Thanks.

    Rick

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    It sounds like you have the same subreport in two different reports. Look at the subreport control in each of the main reports, and see what the source object is.
    Paul

  3. #3
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    subReports

    Hi Paul - Yes I've created a subReport and then saved it with a different name.

    Then I selected a different query as the source.

    Next I changed one field using the "conditional field" formatting.

    When I save the subReport with the new conditional field formatting it saves the change back to the original subReport.

    This is very confusion.

    Thanks . . . Rick

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Can you post the db? What you describe should not happen.
    Paul

  5. #5
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    subReport Matrix

    I tried to create a matrix sort of file.

    Please see attached.

    Sometimes when I "save as" I see save to A, SAVE to All, etc.

    If I save to all then I supose that is the problem.

    How do I correct this?

    Thanks.

    Rick
    Attached Thumbnails Attached Thumbnails subReport.jpg  

Posting Permissions

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