Post reply

report generation

  • April 12, 2010 at 4:16 am

    #213639

    Hi

    Need to generate a report for migration project . The report should look like

    Header

    Field Value

    Start program Date time

    Body

    Field value

    tbl_name1 xxxxx

    tbl_name2 xxxxx

    tbl_name3 xxxxx

    ...

    ...

    Footer

    Field Value

    End program Date time

    This is all in tabular format. The data is colected in table and I need to just fetch the data and display it correctly.

    I'm migrating data using SSIS

    I'm able generate word document with table but there remains no space between header, body, footer

    (they all come as one table)

    any idea of how this can be done. would xml, html, others help me

  • April 12, 2010 at 4:26 am

    #1149899

    The obvious reply is to look at reporting services, in which you should be able to produce the report you want.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • April 12, 2010 at 4:29 am

    #1149901

    we cant use reporting services.. 🙁

    the destination server will have only sql engine and ssis

    so i think it has to be done using TSQL or some other way

    (and frankly speaking i'm not good at any language)

  • April 14, 2010 at 8:37 am

    #1151407

    If you post some example data perhaps someone here can give you a head start.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply