Click here to Skip to main content
12,700,957 members (29,641 online)
Rate this:
Please Sign up or sign in to vote.
Hi All,

Hi, I know it is a real pain to integrate Crystal reports with SQL Server Compact 4.0. I tried the above approach(link) to create a crystal report using SQL Compact 4.0 as back end. It works like a charm on my development machine. This approach basically creates a link between the report and the SDF.
I am able to see the correct report with data populated from the SDF.
But the catch is when I install the app in a different computer. It asks for logon information when I run the reports as NewDataSet in Server field. But there is no server, database is a SQL compact file and sits in a folder. SDF is password protected. I tried putting the password in the logon screen. It fails.
I can't find any information on this issue anywhere.

Has anyone encountered this problem? Do you have ideas to fix the logon problem? Please help.
Posted 13-May-12 20:57pm
ShaikhM 15-May-12 0:03am
I am not sure about this in your case, but most of the time that I have faced Logon issues in reports, i fixed them by Checking the INTEGRATED SECURITY check box.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 6 Jun 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100