Print Page | Close Window

Missing subreport data

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3720
Printed Date: 20 May 2024 at 9:32am


Topic: Missing subreport data
Posted By: zinzaba
Subject: Missing subreport data
Date Posted: 16 Jul 2008 at 3:47am

I have a report that has a number of subreports. This report prints correctly most of the time but some users experience a problem where some of the subreport data is not printed. This means that their result is a few pages short.

I tried this from different pc's thinking it may be related to resources but this did not help either.
 
Could it have something to do with locks on the db tables when the report is trying to retrieve information for the subreports?


Replies:
Posted By: keval300
Date Posted: 18 Jul 2008 at 5:09am

hi Zin,

are u using odbc connection?
if that is the case
then please make sure that the user who is using the report has the DSN created.
This DSN should have the DSNname same as that of the DSN name used during the design of ur report.
if the DSN name differs then this issue will surely raise
 
Enjoy Crystal REPORTS.....
 


-------------
Enjoy...

Posted By: hilfy
Date Posted: 18 Jul 2008 at 12:43pm
What type of database are you connecting to?  Are you using a native connection or ODBC or OleDB?
 
Yes, record locks and/or table locks could be an issue.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: zinzaba
Date Posted: 21 Jul 2008 at 12:48am
I am using an ODBC. The users do have this ODBC created locally.

I am connecting to a MS SQL database.

How would I be able to determine whether this problem is related to record/table locks?

Posted By: hilfy
Date Posted: 21 Jul 2008 at 7:12am
I'm not very familliar with MS SQL (although I do know that there can be locking issues with it) so your DBA will have to help you with this.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window