Newbies pindymx Posted January 26, 2011 Newbies Share Posted January 26, 2011 I wonder if anyone could point out a more stylish way to handle this basic problem of sliding layout items in a printed report: In those records where the text exceeds the basic boundaries, is there another way to establish grid lines and borders (as you can see) but covering the dynamic blank space? Ideally, you could tell the lines to shrink as well, but I don't think it works that way. I would love to see some examples of graphically successful sliding objects. Thanks for any ideas. Link to comment Share on other sites More sharing options...
ljm Posted February 22, 2011 Share Posted February 22, 2011 I wonder if anyone could point out a more stylish way to handle this basic problem of sliding layout items in a printed report: In those records where the text exceeds the basic boundaries, is there another way to establish grid lines and borders (as you can see) but covering the dynamic blank space? Ideally, you could tell the lines to shrink as well, but I don't think it works that way. I would love to see some examples of graphically successful sliding objects. Thanks for any ideas. The only way I have found to make the vertical lines work when you have variable long text to accommodate is to make it a calculation based on the number of characters. You can make the number of lines of the border part of a case statement. In my situation, I use VerticalLine (a couple of pix wide field with a left or right border turned on) placed across the entire grid, and once I get it more or less aligned I group all the vertical lines and send them to the back. This way every time you add a return (a new line to the field, you get another couple cm of border). It takes a little while to get the length right and it helps if you keep consistent the font and size of the font in the field with the variable notes. It seems like a pain, but in fact it works and it isn't that bad. In my case I had to examine a couple of fields across the grid to determine which would drive the need to make the row larger or smaller, in your case it looks like you only have to measure one field to see how long it is. Case( MaxLengthâ¤40; Replace(VerticalLine;1;1; ¶); MaxLength>40 and MaxLengthâ¤80; Replace(VerticalLine;1;2; ¶ & ¶); MaxLength>80 and MaxLengthâ¤120; Replace(VerticalLine;1;3; ¶ & ¶ & ¶); MaxLength>120 and MaxLengthâ¤160; Replace(VerticalLine;1;4; ¶ & ¶ & ¶ & ¶); MaxLength>160 and MaxLengthâ¤200; Replace(VerticalLine;1;5; ¶ & ¶ & ¶ & ¶ & ¶); MaxLength>220 and MaxLengthâ¤264; Replace(VerticalLine;1;6; ¶ & ¶ & ¶ & ¶ & ¶ & ¶); MaxLength>264 and MaxLengthâ¤308; Replace(VerticalLine;1;7; ¶ & ¶ & ¶ & ¶ & ¶ & ¶ & ¶); MaxLength>200 and MaxLengthâ¤352; Replace(VerticalLine;1;8; ¶ & ¶ & ¶ & ¶ & ¶ & ¶ & ¶ & ¶ & ¶); ) Link to comment Share on other sites More sharing options...
Newbies pindymx Posted February 22, 2011 Author Newbies Share Posted February 22, 2011 The only way I have found to make the vertical lines work when you have variable long text to accommodate is to make it a calculation based on the number of characters. You can make the number of lines of the border part of a case statement. Very clever—I'll try that. At the moment, I have the vertical lines in my grid just barely extending past the part boundaries and it's working about 95% as a good solution, only the lines show at the bottom of each list of records in list view. Thanks for that. Link to comment Share on other sites More sharing options...
skearton Posted April 29, 2011 Share Posted April 29, 2011 The only way I have found to make the vertical lines work when you have variable long text to accommodate is to make it a calculation based on the number of characters. You can make the number of lines of the border part of a case statement. In my situation, I use VerticalLine (a couple of pix wide field with a left or right border turned on) placed across the entire grid, and once I get it more or less aligned I group all the vertical lines and send them to the back. This way every time you add a return (a new line to the field, you get another couple cm of border). It takes a little while to get the length right and it helps if you keep consistent the font and size of the font in the field with the variable notes. It seems like a pain, but in fact it works and it isn't that bad. In my case I had to examine a couple of fields across the grid to determine which would drive the need to make the row larger or smaller, in your case it looks like you only have to measure one field to see how long it is. Case( MaxLengthâ¤40; Replace(VerticalLine;1;1; ¶); MaxLength>40 and MaxLengthâ¤80; Replace(VerticalLine;1;2; ¶ & ¶); MaxLength>80 and MaxLengthâ¤120; Replace(VerticalLine;1;3; ¶ & ¶ & ¶); MaxLength>120 and MaxLengthâ¤160; Replace(VerticalLine;1;4; ¶ & ¶ & ¶ & ¶); MaxLength>160 and MaxLengthâ¤200; Replace(VerticalLine;1;5; ¶ & ¶ & ¶ & ¶ & ¶); MaxLength>220 and MaxLengthâ¤264; Replace(VerticalLine;1;6; ¶ & ¶ & ¶ & ¶ & ¶ & ¶); MaxLength>264 and MaxLengthâ¤308; Replace(VerticalLine;1;7; ¶ & ¶ & ¶ & ¶ & ¶ & ¶ & ¶); MaxLength>200 and MaxLengthâ¤352; Replace(VerticalLine;1;8; ¶ & ¶ & ¶ & ¶ & ¶ & ¶ & ¶ & ¶ & ¶); ) I'm trying to do this in a report as well, but I still don't get the steps involved. Can you explain further or supply an example file? Link to comment Share on other sites More sharing options...
snowbound Posted April 30, 2011 Share Posted April 30, 2011 If I understand that you want all of the vertical lines to fill the vertical space then you could set the boarders on your expanding text field and then duplicate it for each column, set it to the width of each column, set the text to white and place it behind your other fields. This would shrink like the actual expanding text field but because the text is white it will not appear. I have not tried this but it might do what you want. Edit: Did a quick test and it looks like you would need to keep all of the duplicates of the expanding text field the same width otherwise they would resize differently and then align the left edge in line with the left edge of each column. Link to comment Share on other sites More sharing options...
snowbound Posted April 30, 2011 Share Posted April 30, 2011 Here is the quick sample file that I built. I set the duplicate text boxes green to so you can see what is going on better and added a yellow box in behind to give me a right boarder for smaller text amounts but you could probably keep your vertical lines. Text Slide.fp7.zip Link to comment Share on other sites More sharing options...
skearton Posted April 30, 2011 Share Posted April 30, 2011 Here is the quick sample file that I built. I set the duplicate text boxes green to so you can see what is going on better and added a yellow box in behind to give me a right boarder for smaller text amounts but you could probably keep your vertical lines. Thanks for taking time to do that. I can see how that works if one only has a single field column that has the most text. I'm dealing with any of the field columns having varying lengths depending how much text is in each. I have attached a screenshot of an example. How would you handle this situation? Link to comment Share on other sites More sharing options...
snowbound Posted April 30, 2011 Share Posted April 30, 2011 If you duplicate each set of boxes and keep them the same width you place them at the edges of all the other boxes. I have attached another example and colour coded each set of fields to make them easier to pick out but you would set them all to a fill of white and the text to white. If you dig down there are several layers of fields. You also need to turn off borders on some edges and I placed a line at the bottom and turned off field boarders on the bottom. Text Slide2.fp7.zip Link to comment Share on other sites More sharing options...
snowbound Posted April 30, 2011 Share Posted April 30, 2011 I just noticed that the top level field "One" should have the bottom field boarder turned back on in order for it to appear correctly. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4737 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now