Link to home
Start Free TrialLog in
Avatar of gcook17
gcook17Flag for United States of America

asked on

VB.Net 2005 app Crystal Reports Doesn't Display Any Data

I have a VB.net 2005 windows app that uses Crystal Reports 2008. Originally the reports were developed in Crystal 8.5. Reports display properly as expected when run in VB.Net IDE. Probl;em when built application is deployed the reports do not display any data in them. There are no errors being generated.  Literal text (such as report title are properly displayed at runtime. There are no column header or any indication of a database connection with report though. Installer is Installshield 2010. All connection info is being passed properly. Reports were converted to Crystal 2008 as a possible solution but this had no effect.
cr.txt
Avatar of gcook17
gcook17
Flag of United States of America image

ASKER

Addition to Original Question: I have craeted a deployment project in VB.net and it does properly display these reports. Installshield seems to be the problem. All installed files are the same.
Do you have any error trapping in your app (try/catch statementes) to raise any errors to give you a clue as to why connection or log on is not successful?
When you say all connection info is passed properly? what do you base that statement on?
What uer/authentication does the report use? Is it windows authentication or sql (if you are using sql which I don't know (it would help to know your db engine))?
If it is windows is the user setup to have permissions to the db?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gcook17

ASKER

To 13598: Thank you for your post We do have error trapping and also created an .exe with messages that displayed Crystal Connection info at runtime to see that it was being passed properly as it is in debug. It is being passed properly. "Passed properly" I mean that this same connection info displays report data in debug. Using Windows auth. The user does have permission to this DB and the DB data is displayed in the data grids on thie UI. Same data does not display in CR though but only at runtime. Runtime license key is properly entered in Installshield merge module too.
Avatar of gcook17

ASKER

To mlmcc: We have tried installing program on same .Net dev machine that original development is being done on with same results =no data displayed in reports. We also tried on other machines including clean machines = same negative result. If we install with VB.net 2005 created setup then all works fine other than the many limitations of the ,Net 2005 setup creation capability we would stick with it instead of Installshield. We have compared file for file between both deployment projects and they are the same.
Avatar of gcook17

ASKER

BTW: no errors are thrown anywhere during the report creation process. I wish one was though.
Avatar of Mike McCracken
Mike McCracken

What is the difference between the 2 installations?

DO they install everything to the same directories?

mlmcc
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gcook17

ASKER

13598: thnaks for your comment (sorry for the slow response) the report doesn't use an ODBC connection. Also when depoyed using VB.Net 2005 deployment reports do dispaly properly. However when deployed using Installshield 2010 the data is missing. I have checked the projects and same files are bing installed. It doesn't matter if I depoly to dev machine, cleam machine or not so clean non-dev machine.
Avatar of gcook17

ASKER

mlmcc:  I'll comment on folders question in a seperate post once I've checked this. Also when depoyed using VB.Net 2005 deployment reports do dispaly properly. However when deployed using Installshield 2010 the data is missing. I have checked the projects and same files are bing installed. It doesn't matter if I depoly to dev machine, cleam machine or not so clean non-dev machine.