I have been working on enhancing a system that sends letters.
There is enough customization between tasks that each project is implemented as it's own split application.
Some business rules are common about what headers and footers to use. So I implemented these as a common main report.
Then the letter body is on a sub report.
My issue is that I need to get page breaks in the sub report...
A thought would be to group on a key and use force new page. The problem I have here is that many of the the controls have rich text format. So when any grouping is used it fundamentally is running a group query behind the scenes and truncates values to 255 characters. This is a non starter.
My other thought was to use page break controls in the subreport. Apparently these do not work properly in subreports.
Please tell me there is a simple ingenious solution to this problem?
Right now I have two thoughts, neither of which seems good... Break the subreport into multiple subreports and place page break controls between them on the main report. I'd rather not have to deal with the same query running even more times for multiple subreports.
The other would be to have a way to store and recreate all the controls with maybe a particular tag, or not a particular tag, sections etc. So they can be stripped out to store the common business object report (Main Reprot) and polled for updates. I am already doing this for subreports which have few key properties and comparatively easier.
Neither of these feel like a good solution. I'm really hoping for a better idea...
Ultimately I may need the flexibility of the second option if that is it and that is the more cumbersome solution as I'd have to identify which properties to set if I logged them... Not to mention dealing with sections in vba... My brain hurts.
There is enough customization between tasks that each project is implemented as it's own split application.
Some business rules are common about what headers and footers to use. So I implemented these as a common main report.
Then the letter body is on a sub report.
My issue is that I need to get page breaks in the sub report...
A thought would be to group on a key and use force new page. The problem I have here is that many of the the controls have rich text format. So when any grouping is used it fundamentally is running a group query behind the scenes and truncates values to 255 characters. This is a non starter.
My other thought was to use page break controls in the subreport. Apparently these do not work properly in subreports.
Please tell me there is a simple ingenious solution to this problem?
Right now I have two thoughts, neither of which seems good... Break the subreport into multiple subreports and place page break controls between them on the main report. I'd rather not have to deal with the same query running even more times for multiple subreports.
The other would be to have a way to store and recreate all the controls with maybe a particular tag, or not a particular tag, sections etc. So they can be stripped out to store the common business object report (Main Reprot) and polled for updates. I am already doing this for subreports which have few key properties and comparatively easier.
Neither of these feel like a good solution. I'm really hoping for a better idea...
Ultimately I may need the flexibility of the second option if that is it and that is the more cumbersome solution as I'd have to identify which properties to set if I logged them... Not to mention dealing with sections in vba... My brain hurts.