Blank Crystal Report at runtime after deployment

[artyk]

Hi.
I am currently trying to deploy my first VB.NET 2005 application. After much work, I got it installed on a client machine and it is writing to the database and everything just fine. However, when I try to view the report all I get is the layout, but no data. I know it's probably something to do with the datasource location differences between the folder where it is deployed and where my .sln file is on the development computer (the "Program Files" folder where it is deployed, and "My Documents" where I have my development files on my computer). I tried to fix the datasource to point to the correct location to account for this and it currently says in the "File Path" section of the properties: "|DataDirectory|mydataset.mdf, which should be correct. I also used the "Current Connections" node to select the dataset. I wasn't really clear on that, but since it has the correct path I thought it would be fine. I still get no data in the report. If anyone has anything I could try or look for I would greatly appreciate it. Also, if this is unclear let me know and I will see if I can explain it more effectively. Thanks in advance.

 

[artyk]

Maybe I should rephrase the question a bit. What has to be done with the Report Datasource location so that the report will show up when it is run? I had it working perfectly as I was debugging because all the datasources were pointing to where my project files are located. When it is installed it has to point to |DataDirectory|...That much I know and I have the database working perfectly with the program. For some reason I haven't been able to hit on the right Datasource location to make the report read from the database. If you're not sure what I need to do, let me know how you set up your Report Datasource. That might point me in the right direction. Thanks!

 

[artyk]

Here's a strange twist. When I go back and set up the project connection string to look into my projects folder instead of the Program Files folder, the report still won't work. I haven't changed anything with the report in over a week. I even updated the report datasource by browsing to the dataset and selecting the one I wanted to use. This must be a unique problem since I haven't heard from anyone and it just keeps getting stranger. Anyway, if anyone would happen to have ANY suggestions it might point me in the right direction. Thanks.