ReportViewer doesn't show in deployed web app
I have created a pretty basic web application in Visual Studio 2010. It uses Access databases with Crystal 13. I created a report based directly from the mdb files (no datasets) which are located in my app_data folder (the same location my report resides). Everything is working perfectly on the development machine, when I publish it to the web server, the Crystal Report Viewer doesn't show. No errors, no messages, just a blank white page. I'm not sure why this is happening, but I did discover that the source code for the page with the Crystal Report Viewer shows full paths to the databases on my C: drive. Is that where my problem is?
If that's the issue, how do I make my database paths relative? I can go to "Set Data Source locations" in the report, but no matter what I do (I tried creating new connections using Access/Excel DAO as well as OLE DB ADO), it always shows a full path.
I have pulled my hair out on this one for a while now. Please help!