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.