+ Reply to Thread
Results 1 to 5 of 5

viewing the Query's result saved as RPT

  1. viewing the Query's result saved as RPT

    What is best application to view or open the rpt file saved as result of a query in SQL ( ssms)? Crystal doesn't recognize it and excel or notepad shows as garbage.

  2. Re: viewing the Query's result saved as RPT

    It should be displayed properly in excel or notepad.
    Just tried viewing an .rpt extracted from SQL Server 2008 and works fine.

    Which version of SQL Server are you using?

    Regards.

    --
    Artemakis Artemiou
    B.Sc., M.Sc.,
    SQL Server MVP,
    MCP, MCTS:SQL Server 2005, MCTS:SQL Server 2008 (Charter Member)

    http://aartemiou.blogspot.com

    This post is provided "as-is" and confers no rights.



    "Viol-8-r" wrote in message news:eAB3Kc17JHA.3804atTK2MSFTNGP02dotphx.gbl...
    What is best application to view or open the rpt file saved as result of a query in SQL ( ssms)? Crystal doesn't recognize it and excel or notepad shows as garbage.

  3. Re: viewing the Query's result saved as RPT

    Thanks for the reply. I am using SQL 2005 and I also assumed the same way that I save the results to file and file's extention is rpt, I should be able to open it in CR or Excel but no.

    Am I missing something. I am opening the rpt file in Excel.
    Regards,

    "Artemakis Artemiou" wrote in message news:1C037BD8-3234-4846-B341-29ECCAA4ACA8atmicrosoftdotcom...
    It should be displayed properly in excel or notepad.
    Just tried viewing an .rpt extracted from SQL Server 2008 and works fine.

    Which version of SQL Server are you using?

    Regards.

    --
    Artemakis Artemiou
    B.Sc., M.Sc.,
    SQL Server MVP,
    MCP, MCTS:SQL Server 2005, MCTS:SQL Server 2008 (Charter Member)

    http://aartemiou.blogspot.com

    This post is provided "as-is" and confers no rights.



    "Viol-8-r" wrote in message news:eAB3Kc17JHA.3804atTK2MSFTNGP02dotphx.gbl...
    What is best application to view or open the rpt file saved as result of a query in SQL ( ssms)? Crystal doesn't recognize it and excel or notepad shows as garbage.

  4. Re: viewing the Query's result saved as RPT

    OK.

    I have tried it on my SQL Server 2005 installation and still works fine. I opened the .rpt file using notepad.

    Have you installed the latest Service Pack (3)?

    If you run the following statement you will get information about the current instance including which service pack is installed:

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    Also, how do you create the .rpt file? Have you selected the "Results to file" feature?

    Regards.

    --
    Artemakis Artemiou
    B.Sc., M.Sc.,
    SQL Server MVP,
    MCP, MCTS:SQL Server 2005, MCTS:SQL Server 2008 (Charter Member)

    http://aartemiou.blogspot.com

    This post is provided "as-is" and confers no rights.

    "Viol-8-r" wrote in message news:%23JZZDs27JHA.2456atTK2MSFTNGP02dotphx.gbl...
    Thanks for the reply. I am using SQL 2005 and I also assumed the same way that I save the results to file and file's extention is rpt, I should be able to open it in CR or Excel but no.

    Am I missing something. I am opening the rpt file in Excel.
    Regards,

    "Artemakis Artemiou" wrote in message news:1C037BD8-3234-4846-B341-29ECCAA4ACA8atmicrosoftdotcom...
    It should be displayed properly in excel or notepad.
    Just tried viewing an .rpt extracted from SQL Server 2008 and works fine.

    Which version of SQL Server are you using?

    Regards.

    --
    Artemakis Artemiou
    B.Sc., M.Sc.,
    SQL Server MVP,
    MCP, MCTS:SQL Server 2005, MCTS:SQL Server 2008 (Charter Member)

    http://aartemiou.blogspot.com

    This post is provided "as-is" and confers no rights.



    "Viol-8-r" wrote in message news:eAB3Kc17JHA.3804atTK2MSFTNGP02dotphx.gbl...
    What is best application to view or open the rpt file saved as result of a query in SQL ( ssms)? Crystal doesn't recognize it and excel or notepad shows as garbage.

  5. Re: viewing the Query's result saved as RPT

    This is what I have 9.00.3054.00 SP2 Standard Edition and yes I create the .rpt file selecting the "Results to file" feature
    "Artemakis Artemiou" wrote in message news7FAE336-00E5-4CA3-BB3B-28FFEC7A7977atmicrosoftdotcom...
    OK.

    I have tried it on my SQL Server 2005 installation and still works fine. I opened the .rpt file using notepad.

    Have you installed the latest Service Pack (3)?

    If you run the following statement you will get information about the current instance including which service pack is installed:

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    Also, how do you create the .rpt file? Have you selected the "Results to file" feature?

    Regards.

    --
    Artemakis Artemiou
    B.Sc., M.Sc.,
    SQL Server MVP,
    MCP, MCTS:SQL Server 2005, MCTS:SQL Server 2008 (Charter Member)

    http://aartemiou.blogspot.com

    This post is provided "as-is" and confers no rights.

    "Viol-8-r" wrote in message news:%23JZZDs27JHA.2456atTK2MSFTNGP02dotphx.gbl...
    Thanks for the reply. I am using SQL 2005 and I also assumed the same way that I save the results to file and file's extention is rpt, I should be able to open it in CR or Excel but no.

    Am I missing something. I am opening the rpt file in Excel.
    Regards,

    "Artemakis Artemiou" wrote in message news:1C037BD8-3234-4846-B341-29ECCAA4ACA8atmicrosoftdotcom...
    It should be displayed properly in excel or notepad.
    Just tried viewing an .rpt extracted from SQL Server 2008 and works fine.

    Which version of SQL Server are you using?

    Regards.

    --
    Artemakis Artemiou
    B.Sc., M.Sc.,
    SQL Server MVP,
    MCP, MCTS:SQL Server 2005, MCTS:SQL Server 2008 (Charter Member)

    http://aartemiou.blogspot.com

    This post is provided "as-is" and confers no rights.



    "Viol-8-r" wrote in message news:eAB3Kc17JHA.3804atTK2MSFTNGP02dotphx.gbl...
    What is best application to view or open the rpt file saved as result of a query in SQL ( ssms)? Crystal doesn't recognize it and excel or notepad shows as garbage.

+ Reply to Thread