Click here to Skip to main content
15,878,852 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello,
I have followed a tutorial on how to create a crystal report in VB .NET 2008 connected to an SQL 2008 SERVER database, I have followed this tutorial http://vb.net-informations.com/crystal-report/vb.net_crystal_report_step_by_step.htm but when I preview the report I get data which are irelevant with the database and when I run the VB project and press the button I get no data in the crystal report viewer. Any help?

Thank you
Kyriakos
Posted
Comments
dimpledevani 25-Jun-12 5:09am    
At design time, when you preview the data, its a dummy data according to the datatype given by you, at runtime it is necessary that column names should be same as those in database..

Either post your code what error you're getting and where exactly you get stuck'd or refer some CP articles & answers:
How to Load and Display Crystal Reports in VB.NET[^]

and CodeProject Search[^]
 
Share this answer
 
I get no error just null data as the reports datasource is not getting data from the database.
 
Share this answer
 
Hello,
The problem was that I was using sqldataadapter (ADO XML), I have used oledbdatadapter (ADO .NET) and got the results normally. I don't know why the first object didn't work.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900