Crystal Reports Using Local Database

Submitted by admin on Monday, May 14, 2012 - 09:36.

Language

I receive one comment on one of my post “How to Print Using Crystal Reports” asking on how to create a crystal reports using a local database.

I told him to create a video on this, but I decided to create a project before I publish the video.

Local database has an extension filename “.sdf”. By default you cannot see it (Data Source) when you create crystal reports using a wizard.

There is no other way of displaying a report from local database other than hard coding.

You need to import “System.Data.SqlServerCe” in order to print crystal reports using local database.

Here’s the code to populate the DataSet in order to display the reports when you preview it.

        Dim sqlQRY As String = "SELECT * FROM Customers"
 
        Dim cmdExec As SqlCeCommand = New SqlCeCommand(sqlQRY, conn)
 
        'create data adapter
        Dim da As SqlCeDataAdapter = New SqlCeDataAdapter(sqlQRY, conn)
 
        'create dataset
        Dim ds As DataSet = New DataSet
 
        'fill dataset
        da.Fill(ds, "Customers")
 
        Dim Report As frmReports = New frmReports
 
        Dim mReport As rptCustomers = New rptCustomers
 
        mReport.SetDataSource(ds)
 
        Report.CrystalReportViewer1.ReportSource = mReport
 
        Report.ShowDialog()

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

I think thats me .. xD ..

hi sir, i think thats me .. hehe .. i just want to add up some question .. i think i'm using local database but the extension is .mdf not the .sdf you use in your program is there any difference between the two ..

I think thats me .. xD ..

hehe .. it happens that i ask question regarding using crystal report with the local database as back end, but i have some question about your program .. your using the .sdf local database .. and it will really help me in my next program .. but i'm using the the other one with .mdf extension .. can you teach me on how to use it in .mdf database .. and by the way I check the program i downloaded here but there was an error .. the import system.data.sqlServerCe has a problem, it has a color green line on it .. do you how to debug it .. thanks ..

Not Working

hi, the program is not working on my computer i think the import sqlserverce has an error .. it has a color yellow with a "!" on the inside .. i think i don't that reference in my computer i try to add reference but i can't see the dll file .. do you know how can i fix it .. thankz ..

Try to change the target cpu

Try to change the target cpu to x86. follow the steps here: http://www.sourcecodester.com/Tutorials/how-debug-visual-studio-net-project-64-bit-os.html

I manage to debug it

oh its working .. the problem is that i didn't have a dll file of system.data.sqlserverce and i try to download that dll and install it to my computer and it works .. but how can i manage to deal with crystal report using serivce-based database(.mdf) ..

did you attached the database

did you attached the database using management studio tools? where did you create that database?

i think i didn't

what i just did is to create a database inside the visual studio .net 2008(enterprise),i just add new item and add the serviced-based database(.mdf) to my project,and i begin to manipulate the databse,create table and everything .. and it seems like it like a sqlserver with in your computer, like a local database,