Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports Problem

Status
Not open for further replies.

arrian

Programmer
Nov 11, 2003
93
CA
I have a report that reads from an access database. I use 2 tables in the report. Right now, the report is coded to go to a database on my HDD. How do I change where it looks for the database? Also, it isn't showing me any data... What do I need to do to have it fill the fields?
 
I have a report that reads from an access database. I use 2 tables in the report. Right now, the report is coded to go to a database on my HDD. How do I change where it looks for the database?
The simple answer is: Go to "Database" -> "Set Location"

Also, it isn't showing me any data... What do I need to do to have it fill the fields?
Once again, the simple answer is: Drag and drop the fields from the field explorer. Or create formula fields and drag and drop them on the report using the field explorer as well.

I hope that helps!
Brett

--------------------------
Please visit my website!
 
The problem is, I have to dynamically set the database location... I can't just do it in the report, 'cause it may not allways be in the same place.

I've got the report with all the fields on it, but it's still not showing anything, unforutnatly..
 
Just point it at an ADO.Net dataset, which is basically the database structure needed for your report. Fill your dataset at runtime, and there is no need for hard coded database paths.


Sweep
...if it works dont f*** with it
curse.gif
 
Ok, how do I get 2 tables into the dataset? I'm not sure how to go about this...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top