Skip to main content
N
naglists1-Visitor
1-Visitor
February 19, 2011
Question

sql server datamerge (7 emails, 6 files total)

  • February 19, 2011
  • 14 replies
  • 2118 views
1 of 7

Hi,
I hacked together a SQL Server datamerge and have now generalized it into a
sample like the Access and Excel ones that install with Editor. (Frankly,
it's better documented if I do say so myself.) I am going to send each of
the six files I've created one at a time as replies to this e-mail.
Eventually, I'll upload it to adepters.org. If you try it and it works (or
doesn't work), please let me know.

--
Paul Nagai

    14 replies

    Show previous replies
    N
    naglists1-VisitorAuthor
    1-Visitor
    February 19, 2011
    Here you go, Steve.

    N
    naglists1-VisitorAuthor
    1-Visitor
    February 19, 2011
    Doing his best Ron Popeil:

    BUT WAIT! THAT'S NOT ALL! THREE THREE THREE BONUS FILES!

    1) An "identity" XSL stylesheet used to return the raw datamerge markup.
    2) An example of the raw datamerge markup created by #1.
    3) An "enhanced" example of an XSL that names ALL elements in the datamerge
    markup. Even if it doesn't do anything different from the XSL delivered in
    the sample with the new elements. Plus this contains processing that will
    return a "row" as an <h1> with nested <h2> / para children.


    G
    GarethOakes16-Pearl
    16-Pearl
    February 20, 2011
    Very cool Paul, thanks for sharing!!


    M
    mjohn1-Visitor
    1-Visitor
    January 21, 2012
    Hi Everyone,

    I've been testing some files for an update from Editor 5.3 - 5.4M80
    and encountered a problem with the graphic spacing. It seems that in
    one of my file, the graphic was moved to another page because of an
    increase in the spacing between graphic and generated caption. I have
    nothing special in postspace setting just a zero space with
    precedence=none.

    I cant force it to use 0pt because it will re-flow the other pages.
    What I find weird also is that when I force it to use 8pt, then that
    graphic fit and look exactly as in 5.3, but decrease the space to 7pt,
    and again was pushed to the next page.

    I also tested this in 5.4 M60 and this is not a problem. Was looking
    at the release notes of 5.4 M70 and 5.4M80 and didnt see anything with
    regards to this.

    Anyone knows any work around for this or am I missing something?

    Thanks.

    Milton
    Terms & ConditionsAccessibility statement