Creating a Horizontal Row of Text Boxes with Conditional Suppressions

[kebbusobj]

Hello,

I am having a problem with text boxes. I have a need to put a row of text boxes, with single line borders on all 4 sides, directly beside each other in a horizontal row, and only display the text box if data exists. If the text box doesn't display, the row is supposed to remove that blank spot and move those text boxes that do have data in them next to each other, centered on the page.

For example:

If you have 4 text boxes side-by-side in a horizontal row and boxes 2 and 4 are suppressed based on the conditional suppression formula then the report should look like this:

| Text Box 1 | Text Box4 |

But, with a single line border all the way around.

If all 4 text boxes have data then the report will look like this:

| Text Box 1 |Text Box 2 | Text Box 3 | Text Box 4 |

But, with a single line border all the way around.

Currently, I have conditional suppression formulas for each text box in the horizontal row that suppresses the text box, when the condition is true. That part is working. But I am having trouble figuring out a way to force the boxes that do display together, side-by-side and centered on the page. I have tried several things, but nothing is working.


Is there someone that might know how to accomplish this?

Thank you!
KB

 

[Turkbear]

Hi,
Difficult to do..Try this:
Create a formula that concatenates the 4 data fields with vertical lines where needed , being sure to test for NULLS in each field before the actual concatenation..Place this formula in a text box with single line border format and stretch the box to fill the entire width of the section - then format it for Centered text.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[kebbusobj]

Hi,

Thank you very much for the suggestion. I will give it a try and let you know how it goes.

Thanks again!
KB

 

[Charliy]

Why not put conditional formulas on the borders?

IF < whatever > THEN crSingleLine ELSE crNoLine

 

[kebbusobj]

Hi Charily,

Thank you very much for the suggestion; however, the problem with my solution is not with the border suppression.
The problem is I can't figure out a way to to force the remaining text boxes that aren't suppressed, to display side-by-side and centered on the page.

Hi Turkbear,

Your suggestion got me VERY close, but the top and bottom borders span accross the entire text box, and I am also dealing with two lines of text in each box, each with different fonts. I failed to mention that earlier. Sorry about that. :0

Anyway, I ended up creating two text boxes, one for the top line of text and one for the bottom. It is forcing the text together side-by-side with lines in between and centered now. However, the vertical lines are too small and the top and bottom borders span the entire length of the text boxes. Also, the vertical lines within each of the text boxes do not line up because of the different font sizes that are required.

Thanks again for the suggestion.

KB

 

[lbass]

I would just set up the different scenarios in separate sections (two boxes, four boxes, etc.), and then conditionally suppress the sections.

-LB

 

[kebbusobj]

LBass-

Thank you for your response. It's been since before you responded that I have logged back in, and I just saw your response.

I actually ended up submitting a case to SAP Tech Support, and I have been working with someone there. We have tried a few things already, but nothing has worked so far. On the 15th, they sent me another potential solution, and I think it might actually work this time. I am testing it out today to see if it will work. If it does, I will post the solution in this thread. If not, I will definately try your great suggestion.

Thanks again and stay tuned!