Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    46

    Unanswered: How to generate HTML report?

    can we generate html report?
    eg

    use mydb
    go
    select * from Mytable

    The output will be save in html format

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    That's one feature included in SQL Server Reporting Services.

    -PatP

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you are using SQL 2005 or later, the FOR XML clause is also an option. It creates XML instead of HTML, but a simple CSS would get you where you want to go easily enough using nothing but SQL Server and whatever you are already using to present your HTML.

    I'd still use SQL Server Reporting Services.

    -PatP

Posting Permissions

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