Ensure no one security is split over two pages. If there is insufficient room, the entire block should be moved to the next page.
for the above requirement i am displaying the security in header and in detail section records related to security.
can any one let me know how to do the above.
thanks in advance.
Loading
Sivaraman DhamodaranPosted Nov 9, 2010, 11:27 AM
When the displayed security detail for a perticular group (in your discussion it is Security 3) is not fit in one page, You want to start the Group header and the corrosponding details in the next page.
1. Goto Section Manager.
2. Select Your Group header1 Security
3. Click the Formula button next to Page After
4. Write a formula : Count(fld) > (Number of record)
fld is any field name in the detail. Number of record decides whether you need a page break or Not.
1. [ I do not have X'tal on my Home PC] So experiment with Page After First if that does not give the result, then go with Page before.
2. Count(fld) > number record; I do not remember correct crystal syntax. Make the correction when you are trying.
Bye.
sruthi ramachandrulaPosted Nov 10, 2010, 8:28 AM
i am picking from the database so normally it contains more number of records.
When i am using the formula internally count{fld}>record number defaultly it is using "new Page After" option.
As mentioned earlier is there any option or function to compare against the field in the section (group header 1)
thanks in advance
sruthi ramachandrulaPosted Nov 9, 2010, 1:44 AM
Thanks for reply.
if i am having 3 securities for an account. my report will be of below:
page header 1 account----new page after
group header 1 security
details records
group footer1 security
page footer
suppose if 2 securities are having records 2 each and 3rd security is having 10 records then usually my report preview will be like below
report header
page header 1 account----new page after
group header 1 security1
details records
group header 1 security2
details records
group header 1 security1
details records
group footer1 security3
page footer
here when security 3 is displayed since the page is full records goes to next page. Then since i had give "New Page After" option to pager footer next account is displayed in next new page.....
Problem here is when security 3 is displayed since all records cannot be displayed in one single page whole security 3 should be displayed in new page rest 1 and 2 securities should be displayed in same page.
Please suggest how to do and let me know if explanation is still not clear...
Sivaraman DhamodaranPosted Nov 8, 2010, 9:26 PM