Ashok
Ashok

Reputation: 1906

Crystal Report not showing correct data

Hi I am designing a report using Crystal Report in VS 2010 C# to show students details.

I have designed the Crystal Report like below. Report design

and my actual database table data is

Table data

but I am getting output is

Output

What will be the problem?

Upvotes: 1

Views: 2452

Answers (3)

theProgrammer
theProgrammer

Reputation: 181

Ashok as per your question information there might not be any error in your coding but might have error in Cristal report or Application setting.

Check your both that applications and try again.

Upvotes: 1

huMpty duMpty
huMpty duMpty

Reputation: 14460

It’s not quite clear what the issue you have at the moment. But based on your comments there are few areas that I think can be gone wrong.

  1. Check you have correct data source set up (Right click on student under Database fields and go to set data source location and check you are connected to correct database and table)
  2. Also go to file and check whether you have save data with report option is selected. If it is unselect that option
  3. Try go to database and do verify database
  4. Reason behind you seeing values like ###### is definitely because of not enough space been allocated

Hope this helps

Upvotes: 1

campagnolo_1
campagnolo_1

Reputation: 2750

You see the "######" because the field itself is not big enough to display the data. There are two ways you can solve this:

  1. Click on the field to highlight it. Then move the mouse along the frame until the cursor changes to an arrow that points left and right ( <-->). Click and hold the left mouse button and resize the field (just like you would resize a window).
  2. You can right-click on the field, select Format Field, and under the common tab you can check the "Can Grow" option.

Upvotes: 0

Related Questions