Avatar of gcook17
gcook17
Flag 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
.NET ProgrammingInstallationDB Reporting Tools

Avatar of undefined
Last Comment
gcook17

8/22/2022 - Mon
gcook17

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.
13598

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
Mike McCracken

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
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.
gcook17

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

What is the difference between the 2 installations?

DO they install everything to the same directories?

mlmcc
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
13598

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
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.
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.