Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts

    Format/style problems (xpp 2003)

    Hi

    We have a very strange problem that has suddenly arisen with text formats being inexplicably changed.

    Background.
    Our organisation accredits testing laboratories against international standards as being capable of carrying out specific tests. Once the laboratory has been assessed a "Scope of Accreditation" is produced. We are using a newly developed SQL database to store all information, including scope parts, for all clients. The scopes are built from "Master Files" where the classes of test are stored as separate database entries. Once the scope for a specific client is built (in the database) a "Provisional Scope" is generated using a Word template (see attached).

    The problem we have is that some of the tests are required to be shown in italics (international standards specify this). When the classes of test are entered for storage in the database, they are formatted correctly. However, when the provisional scope is produced they are shown as non-italicised text.

    The only way we have found to overcome this is to put an extra character at the end of the text, format it as white text, and save it. Now when the provisional scope is generated it generates correctly!!

    Can anyone help!
    Attached Files Attached Files
    cheers

    Phil Carter

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

    Re: Format/style problems (xpp 2003)

    Can you tell us something about how the provisional scope is generated from the database?

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts

    Re: Format/style problems (xpp 2003)

    Hans hi

    Each of the scope items is created in Word using specific styles depending on their applicability. These are then stored in RTF format..

    A separate database record is created for each scope by adding items from a pic list of scope items. Once again this is then stored as an RTF file. When it is required to generate the scope a Word template is called up by an xml function that has bookmarks for all the required information. One of these bookmarks is called "bmkstart" where the entire scope for that client is dumped. At this bookmark a table is created where a new row is inserted each line item depending on its hierachy.
    cheers

    Phil Carter

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

    Re: Format/style problems (xpp 2003)

    This is out of my scope, I fear (sorry for the pun). I hope someone else can help.

Posting Permissions

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