Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Help about Crystal Reports in VB.net Post Reply Post New Topic
Author Message
deien
Newbie
Newbie
Avatar

Joined: 28 Nov 2007
Location: Philippines
Online Status: Offline
Posts: 2
Quote deien Replybullet Topic: Help about Crystal Reports in VB.net
     Posted: 28 Nov 2007 at 2:52am
Hello Everyone!
I'm just new in using Crystal Reports and my problem is, I used a stored procedure as a database field for my crystal report. And then, after plotting all fields that I need to finish the report format, I then retrieved a record. But the report only reflects some fields that are in String format. The fields that are in NVARCHAR, Numeric, and decimal, and some String formats are not displayed. I can't figure out what's wrong.
Please help me.. Smile
Deien Fernandez
AMTI Programmer
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 04 Dec 2007 at 9:56am
Step #1 - Test the stored procedure in the database.  Do you get the expected results?

Step #2 - Test the stored procedure in the simplest possible report.  Just add the fields to a blank report, with no formatting or other options.  Do you get the expected results?

Step #3 - In Field Explorer, right-click on one of the fields.  Select Show Field Type.  Are the types what you expected?


IP IP Logged
deien
Newbie
Newbie
Avatar

Joined: 28 Nov 2007
Location: Philippines
Online Status: Offline
Posts: 2
Quote deien Replybullet Posted: 04 Dec 2007 at 11:50pm

Solved this already.. Thanks a lot!

Deien Fernandez
AMTI Programmer
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum