Print Page | Close Window

Single Page Report repeating

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=9279
Printed Date: 19 May 2024 at 3:49pm


Topic: Single Page Report repeating
Posted By: Turtleburn
Subject: Single Page Report repeating
Date Posted: 03 Mar 2010 at 6:36pm
Hello, first I will state I am new to using Crystal Reports.  I am creating a windows application and I want to display a 1 page report. I began designing the report using the crystal reports provided in Visual Studio 2008.   I have most most of the data I want displaying correctly on the report.  I reciently added a view to the sql tables I am using in the report. I dropped a field from the new view on the report on the footer section.  When I run the report, now I get muliple pages repeating all the data on the report above the footer section.  The last page lists the full report with the footer.  The view is a 1 to 1 relationship to the main table used.  Why am I getting mulitple pages?  


Replies:
Posted By: DBlank
Date Posted: 04 Mar 2010 at 7:12am

When linking tables (or views or stored procs) in crystal the joins are not enforced automatically. They will become enforced once any field is used from both linked items anywhere in the report (e.g. on the report canvas or in a formula or the select statement, ...) OR if you make them enforced in the crysal linking process.

Go into the Database > Database Expert Links tab
First verify that the correct one-to-one link is being used.
If it is not fix it.
If it appears OK try this test.
remove the view field from your report that is causing the issue.
View the reprot and verify that it appears correcty.
Now go  intop the DB expert Open the Link Options and CHange the Enforce Join to Enforce Both and save the change.
View report again. Did it go haywire again? If so then it has to do with the Join not being a 1-1.


Print Page | Close Window