Print Page | Close Window

Crystal report 9

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13605
Printed Date: 02 May 2024 at 8:13am


Topic: Crystal report 9
Posted By: cry_Deepu
Subject: Crystal report 9
Date Posted: 27 Jun 2011 at 3:49am
I am generating a report using crystal reports, i am getting 1st page as blank and remaining pages im getting data?? And for less data im not getting any blank page ,If my report is having more  records then it is coming in multiple pages at the time im getting 1st page as blank............
Any body have any idea plz..........
 
Thanks in advace,
Cry_Deepu


Replies:
Posted By: DBlank
Date Posted: 27 Jun 2011 at 4:23am
are you using new page before on a group int he sectino expert?
if so use the syntax
not onfirstrecord

Posted By: cry_Deepu
Date Posted: 27 Jun 2011 at 4:35am
No, iam not using new page before on a group in the report.
but there exists a new page between report header and page header
kindly advice me to solve it.
 
Thanks in advace,
Cry_Deepu

Posted By: DBlank
Date Posted: 27 Jun 2011 at 4:37am
are you using keep group together or keep section together?

Posted By: cry_Deepu
Date Posted: 27 Jun 2011 at 4:44am
Thanks for the quick response.
 
In crystal 9, "Keep togther" option is enabled in all sections defaultly.
i have RH,PH,5GRP,RF,PF in my report.
 
Thanks in advance,
Cry_Deepu

Posted By: DBlank
Date Posted: 27 Jun 2011 at 4:48am
if the section is marked as keep togther (like your GH1) then it will move it to the next page to try and keep it all on one page. Make this value false (uncheck it) and see if it breaks the GH up and gets rid of the unwanted page break.
FYI-sub reports have similar qualities so if you are running one of these in a header that will also cause the break.

Posted By: cry_Deepu
Date Posted: 27 Jun 2011 at 4:53am
i have unchecked the option in GH1, but even though the issue still existing.
no sub reports are used in the reports.
 
Thanks in advace,
Cry_Deepu

Posted By: DBlank
Date Posted: 27 Jun 2011 at 4:57am
play around with the keep togther option in each of the sections.

Posted By: cry_Deepu
Date Posted: 27 Jun 2011 at 5:23am
i have unchecked "Keep togther" option in all sections, but the same problem occurs again.
 
Thanks in advance,
Cry_Deepau.

Posted By: DBlank
Date Posted: 27 Jun 2011 at 5:31am
in preview mode where exactly is the break happening? You should be able to see the secion names on the left of the screen

Posted By: cry_Deepu
Date Posted: 27 Jun 2011 at 5:37am
yes, in the GRP 1, i am having the mentioned problem.
 
 
Thanks in advace,
Cry_Deepu

Posted By: DBlank
Date Posted: 27 Jun 2011 at 5:43am
does GH1 show on page 1 or page 2?
Do you have multiple GH1 sections (e.g. GH1a, GH1b, GH1c, etc.)?
If so where is the break?

Posted By: cry_Deepu
Date Posted: 27 Jun 2011 at 9:51pm

hi Dblank,

Thanks for your immediate responses,
 
In the report,  GH1 shows in second page only.
i don't have any multiple GH1 sections.
 
Reprot shows with the report header and balnk page in the first page and they are followed with page header and the GH1,GH2,GH3,GH4,GH5,RF,PF in the upcoming pages.
 
If i have select the date for two 0r three days, the report is showing correctly but more than those days , i am getting the issue.
 
Thanks in advance,
Cry_Deepu.

Posted By: DBlank
Date Posted: 28 Jun 2011 at 3:44am

Open the group expert

select group 1
select options
select the options tab
is the 'keep group togther set as TRUE? if so uncheck it.
 
Looka at your other group levels to make sure they are not set to keep togther either.
IN the section expert the keep togther tries to keep the section for group together on one page. This setting tries to keep a whole group (GH, details and GF) togther on one page.

Posted By: cry_Deepu
Date Posted: 30 Jun 2011 at 2:41am
HI DBlank,
 
Thanks for your responses,
 
The issue was resolved when 'Keep group togther' option was unchecked in the group expert.
 
But in section expert 'keep togther' option is still checked.
 
My question is when to use these options. ie., simultaneously or in different way.
When i remove the above 'keep togther' option in section expert i didn't see any changes in my report.
 
Kindly explain if possible. Thanks for your patients and replies.
 
Thanks,
Cry_Deepu


Print Page | Close Window