Skip to Content
avatar image
Former Member

Can I import Queries designed in SQL server to crystal reports

I have many queries and subqueries created in sql server that would like to convert from .sql to .rpt is that possible.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 05, 2017 at 06:06 PM

    Hi Connie,

    Not directly, convert those queries into Stored Procedures then CR can run them.

    Search for a KBA or WIKI on how to write Stored Procedures that CR can use. You need to use a Cursor and set NO COUNT on.

    Don

    Add comment
    10|10000 characters needed characters exceeded