Click here to Skip to main content
14,732,921 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear All,

Kindly guide as I'm try to make a crystal report.

As I'm using VB2008 & Sql Server is with that.

Actually first I create a dataset & than combine this data set with Crystal report.

Now probelm occer when I run the report it shows only head name & not showning the data.

If I try to Process instead of SQL file, I user some old database to generate report it become OK and report showing all data of old database.

Kindly guide how I findout the reason of none supporting to SQL Data.

Whereas SQL is not creating any problem when I try to inseart,delete or modify the data through Forms.


Jatinder Gupta.

1 solution

Your question is not quite clear. You tried to create a crystal report with a dataset - didn't work...but report with 'database'-worked?

Put some code part what/how you made dataset. Also look at the dataset formed if it contains the data expected before binding the same to the crystal report.

Make sure you have provided a table stucture in crystal report where columns are defined. You might be missing a mapping in the detail row of table in crystal report.

Go step by step. First make sure dataset is fine then move to crystal report. Your first step should be to troubleshoot the reason then try to resolve it.
Jatinder Gupta 31-Aug-10 21:25pm
You r right sir as the problem at datasets. Kindly help me in step to see the error in datasets. Nextly report become ok when I use the old kind of databases i.e DBF file of other software. For just to see the problem occer at where I used the other databases to see output. With that I find that the problem occers with Sql datasets. Pl guide for the next. Regards,

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