soiram
July 2nd, 2008, 07:25 AM
Hello,
I am relatively new in Crystal Reports.
I am using CR (as it exists in VS2008) to generate a report consisting of many pages. You can consider the report as being relatively simple; it has only two columns containing the description and price of items that have been sold (these items are taken from a database). The problem that i face occurs at the transition between pages. Since the description of the item can be big enough and hence expand to multiple lines, the 'Can grow' property has been checked. Also a specific item (entry) is not supposed to be split between pages therefore the 'keep object together' has been checked. At the bottom of the page i have a page total. This displays the sum of all the prices of the items that exist in every single page.
The problem is the following
If there is very little space left at the bottom of the page and on the same time the size of the object (entry) to be written is bigger than this available space, then the object correctly moves to the next page BUT its price is considered in the calculation of the total of both pages. (it should have been considered only in the new page and not in the page that the entry didn't fit)
I suppose that if there was a function or a property that tells me the remaining available space and the size of the current object to written then i could detect a priori that the item will move to the next page and explicitly not consider its price in the calculation of the page total.
I would appreciate some help on this matter.
Thanks
I am relatively new in Crystal Reports.
I am using CR (as it exists in VS2008) to generate a report consisting of many pages. You can consider the report as being relatively simple; it has only two columns containing the description and price of items that have been sold (these items are taken from a database). The problem that i face occurs at the transition between pages. Since the description of the item can be big enough and hence expand to multiple lines, the 'Can grow' property has been checked. Also a specific item (entry) is not supposed to be split between pages therefore the 'keep object together' has been checked. At the bottom of the page i have a page total. This displays the sum of all the prices of the items that exist in every single page.
The problem is the following
If there is very little space left at the bottom of the page and on the same time the size of the object (entry) to be written is bigger than this available space, then the object correctly moves to the next page BUT its price is considered in the calculation of the total of both pages. (it should have been considered only in the new page and not in the page that the entry didn't fit)
I suppose that if there was a function or a property that tells me the remaining available space and the size of the current object to written then i could detect a priori that the item will move to the next page and explicitly not consider its price in the calculation of the page total.
I would appreciate some help on this matter.
Thanks