Click here to Skip to main content
12,452,344 members (51,643 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB SQL-Server SQL-Server-2008 , +
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 24-Jun-12 23:06pm
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..
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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[^]
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

I get no error just null data as the reports datasource is not getting data from the database.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160826.1 | Last Updated 21 Sep 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100