Wednesday, April 8, 2009

Crystal Reports with SQL Compact

I stumbled across this post by Jason Irwin, that describes how to solve the mystery of connecting Crystal Reports to data from a SQL Compact file – by elegantly using a dataset as the “middleman” or common language, if you like.

kl.

5 comments:

  1. UnknownApril 13, 2009 at 4:21 PM

    Link died!!!

    Please repost

    Thanks

    ReplyDelete
  2. ErikEJApril 13, 2009 at 4:28 PM

    Seems OK to me ?!

    ReplyDelete
  3. UnknownApril 30, 2009 at 8:23 PM

    The link has indeed died.
    I tried at different time intervals just in case to take care of the internet-service-provider's hiccups.

    IF possible, please do a repost of "Jason Iriwn's" content on a well known SQL-CE forum (msdn may be)

    That was just a suggestion as many people like me seem to be stuck into this trap of SQL CE Vs Crystal Reports.
    ~Mukesh

    ReplyDelete
  4. ErikEJApril 30, 2009 at 8:46 PM

    The link works fine for me!? An alternative approach is described here: http://erikej.blogspot.com/2008/10/accessing-sql-compact-from-sql-server.html

    ReplyDelete
  5. AgasaravananApril 17, 2011 at 10:34 AM

    You are just convert dataset to xml file and save one particular location then you can easily do the crystal reports using sql server compact edition

    ReplyDelete