Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Report not generating from sql server Post Reply Post New Topic
Author Message
rajibsarkar
Newbie
Newbie
Avatar

Joined: 11 Jun 2010
Location: India
Online Status: Offline
Posts: 2
Quote rajibsarkar Replybullet Topic: Report not generating from sql server
    Posted: 11 Jun 2010 at 6:48am
I have one sql db in which one table is very big (around 100 fields). Initially when I am creating the report .. it is a big report about 2 pages... it is coming. But after sometimes while designing the report suddenly I found on one full set of data is showing, other doesnot. But if you browse the field data it is showing all the values but only single set of data is showing i.e. only two pages.
 
Can anybody high light the issue ? Is this sql server issue or crystal level issue ... I couldn't find any solution yet as to me this is very simple report only few set of data has to be retrieved at a time on basis of single WHERE STATEMENT.
Regards, Raj
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 17 Jun 2010 at 8:12am
Hi
 
*How many fields are been selected in the report?
*Please explain when u mean "I found on one full set of data is showing, other doesnot"
*Some sample data will be helpful with the where clause and expected results
 
Cheers
Rahul
IP IP Logged
rajibsarkar
Newbie
Newbie
Avatar

Joined: 11 Jun 2010
Location: India
Online Status: Offline
Posts: 2
Quote rajibsarkar Replybullet Posted: 17 Jun 2010 at 8:35am
*How many fields are been selected in the report?
 
Around 40 fields, among which 12 are RTF fields, others are valus selected from list or simple text fields.
 
*Please explain when u mean "I found on one full set of data is showing, other doesnot"
 
All 40 fields filled up = one full set of data
 
*Some sample data will be helpful with the where clause and expected results
 
Sample giving will be difficult just now... but the thing is like this.
 
this is for making a Customer Complain Report.
I have a unique Complain ID followed by all supported data. When I select the Complain ID it generates the report with all supported data. If there is any empty field specially RTF field it is showing blank. I have to provide blank spaces in the RTF fields to generate the report now.
Regards, Raj
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 17 Jun 2010 at 8:46am
Hi
Try doing this
 
Open the report, Go to Menu File-->Report Options and Check Convert Database Null Values to Default
 
hope that helps
 
Cheers
Rahul
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2025 Brian Bischof. All Rights Reserved.