Skip to Content
0

Can I import Queries designed in SQL server to crystal reports

Jul 05, 2017 at 05:51 PM

23

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Don Williams
Jul 05, 2017 at 06:06 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded