Sliding objects to the left on a line

[CrossPoint Toledo]

In a custom report, I have several fields on one line (Name, DOB, email). They are all set at certain positions on the line. Sometimes the name is short, sometimes long. Is there a way to set an object or control to slide left so it comes right after the data in the first field, rather than at a set position on the line?

[Zorak]

You can change the expression on the first field to be something like this, which will print the data from all three fields in one:

Code: Select all

alltrim(profile_name) + " " + transform(born) + " " + alltrim(e_mail)

The alltrim() takes all the extra spaces off the beginning and end of the field. The transform() converts a date field into a string so it can be combined with the other string values.

If you want the fields to be tab separated instead of just a space in between, you can instead do this:

Code: Select all

alltrim(profile_name) + CHR(9) + transform(born) + CHR(9) + alltrim(e_mail)

ASCII character 9 is the tab.

In any case, you would then delete the other two fields that you have printing on that line and stretch the first field out to be full page or column width.