By using this website, you agree to our Terms of Use (click here)
I'm new to report designer and learning as I go. We are currently trying to use the notes section in project quotes to write out our scope of work and avoid having a customization done. Not sure why the project quote section wasn't set up the same as the change request with a separate tab for description. The information pulls in, but if our scope is lengthy, we would like to be able to put a page break in the string to prevent the entire section from automatically going to a second page. From a previous post I tried the II and {br}, but received the following error: Cannot interpret the token "II" at position 27. Context. TextBox 'textBox70' property 'Value'
Here is how I entered the string: =Replace([PMQuote.NoteText].'II'.'{br}')
I also added the characters in the notes section where I wanted the page break to be:
I don't know what I'm missing to make this work, or maybe it's not possible? Any help would be greatly appreciated. Thanks!
I've never used the Report Designer, but does it allow you to use periods as separators instead of commas for function arguments? If not, then I'd say it should read
=Replace([PMQuote.NoteText],'II','{br}')
@charles-craig Thank you, that helps! Changing it to commas made the error go away, but it still isn't providing a page break when I print the quote.
@mnecaise this probably won't make a difference, but could you try it with double quotes around the parameters?
=Replace([PMQuote.NoteText],"II","{br}")
Have you tried modifying the CanSplit setting to True on the Note Field?
If that doesn't work, in the report section that contains the note field, there's a setting to "Keep Together". Update Keep Together = "False"
Lastly, if the note field is in a group section rather than the Details section, you can update the "Keep Together" setting to None in the Group settings.
From the Main Report Properties, locate your Groupings Collections. Select the Applicable Group and set "Keep Together" = None
@staceypoll Thank you, that worked!! I had to modify both the Cansplit and Keep Together. I knew this group would be able to help! Thank you!