AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Is it possible to a...
 
Notifications
Clear all

Questions Is it possible to add a page break to note text?

 
Acumatica Report Designer
Last Post by Michelle Necaise 2 years ago
6 Posts
3 Users
2 Reactions
905 Views
RSS
Michelle Necaise
Posts: 16
 Michelle Necaise
Topic starter
July 28, 2023 10:05 am
(@mnecaise)
Eminent Member
Joined: 2 years ago

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:

image

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! 

Topic Tags
report designer project quote construction
5 Replies
Charles Craig
Posts: 21
 Charles Craig
July 28, 2023 10:58 am
(@charles-craig)
Eminent Member
Joined: 3 years ago

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}')

Reply
Michelle Necaise
 Michelle Necaise
(@mnecaise)
Joined: 2 years ago

Eminent Member
Posts: 16
July 28, 2023 11:07 am
Reply toCharles CraigCharles Craig

@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.

Reply
Charles Craig
 Charles Craig
(@charles-craig)
Joined: 3 years ago

Eminent Member
Posts: 21
July 28, 2023 12:20 pm
Reply toMichelle NecaiseMichelle Necaise
Charles Craig

@mnecaise this probably won't make a difference, but could you try it with double quotes around the parameters?

=Replace([PMQuote.NoteText],"II","{br}")

Reply
staceypoll
Posts: 2
 staceypoll
July 28, 2023 1:35 pm
(@staceypoll)
New Member
Joined: 5 years ago

Have you tried modifying the CanSplit setting to True on the Note Field?

image

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"

image

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

image

 

image
Reply
Michelle Necaise
 Michelle Necaise
(@mnecaise)
Joined: 2 years ago

Eminent Member
Posts: 16
July 28, 2023 2:24 pm
Reply tostaceypollstaceypoll

@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!

Reply
Tim Rodman and Anne Trockman reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • QR Code Size
    3 months ago
  • Print multiple report at the same time on a single printer using device hub
    7 months ago
  • Long text truncated/cut off
    9 months ago
  • Latest Vendor for
    11 months ago
  • Adding Variables Throwing Error: Exception has been thrown by the target of an invocation.
    11 months ago
Topic Tags:  report designer (46) , project quote (1) , construction (5) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,518 Topics
  • 10.9 K Posts
  • 5 Online
  • 2,309 Members
Our newest member: Jason Rhodes
Latest Post: Table linkage for adding a customer location note to the SO Shipment form
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×