[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Crystal Reports Connecting to SQL Server Express

Posted on 2007-04-04
6
Medium Priority
?
611 Views
Last Modified: 2012-05-05
I have a website that uses ASP .net and SQL Server Express 2005.  I was wanting to add CrystalReports functionalty to it.  My database is in an .MDF file, but whenever i Go to crystal Reports it finds the SQL Express server, but only shows these Database: Master, Tempdb.  How do I get it to connect to a SQL Server Express  (.mdf) file?
0
Comment
Question by:bryant1
  • 3
  • 2
6 Comments
 
LVL 71

Accepted Solution

by:
Éric Moreau earned 2000 total points
ID: 18854673
i like to retreive a dataset (from any source) and pass it to CR. see an article I wrote on this topic at http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 18855139
Make sure you have permissiions to the database.

mlmcc
0
 

Author Comment

by:bryant1
ID: 18855303
If the database is in the Project folder shouldn't it have permissions?  How do i check?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 101

Expert Comment

by:mlmcc
ID: 18855431
I don't know how to check with SQL Server Express.  Do you have an administrator?

mlmcc
0
 

Author Comment

by:bryant1
ID: 18860081
Yes
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 18860681
The administrator should be able to check the database for permissions.

mlmcc
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Get the source code for a fully functional Access application shell with several popular security features that Access VBA application developers desire, but find difficult or impossible to figure out how to code. You get the source code for managi…

611 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question