Results 1 to 7 of 7

Thread: SQL Report

  1. #1
    Join Date
    Jul 2011
    Posts
    30

    Unanswered: SQL Report

    I write a query which extract many informations from my database.
    Now,I want to run with query as report for my erp.How can I do this??
    the old reports have mss extension.

    thanks!

  2. #2
    Join Date
    Sep 2010
    Posts
    153

    use tools

    You can use tools for this purpose. I use SSIS (SQL SERVER INTEGRATION SERVICE) tool for report generation.
    When you open this tool, you will find SSRS option..select that optiona nd generate your own reports.

    You can also use Pentaho's kettle for report generation. It's highly in demand

  3. #3
    Join Date
    Jul 2011
    Posts
    30
    these are similar to crystal report??

    I suppose that they don't need changes in my query code.

    thanks for your answer!

  4. #4
    Join Date
    Jul 2011
    Posts
    30
    Quote Originally Posted by sunny_007 View Post
    You can use tools for this purpose. I use SSIS (SQL SERVER INTEGRATION SERVICE) tool for report generation.
    When you open this tool, you will find SSRS option..select that optiona nd generate your own reports.

    You can also use Pentaho's kettle for report generation. It's highly in demand
    A link for ssis,please...

    thanks again!!

  5. #5
    Join Date
    Sep 2010
    Posts
    153

    you can downlaod pentaho's kettle for BI from net (pentaho's official..it's freeware.

    and ssis comes with sql serevr license..i hv nt downlaoded it fr my personal purpsoe. i use it in office. Check whether you can find any link to downlaod. i will be thankful to you

  6. #6
    Join Date
    Jul 2011
    Posts
    30
    sorry,my mistake.

    if I am right,I must create a new server for integration services etc.
    I will try it in afternoon.
    now,I try Pentaho's kettle.

  7. #7
    Join Date
    Jul 2011
    Posts
    30
    another silly question from me

    how can I built a mss file from my sql query??

Posting Permissions

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