I was able to use that and it worked to a certain degree. I now have two formulas placed side by side to give the column effect. I would much rather have one formula that separates the two sections into columns.
The first formula:
split({X_T_ACTION.T_ACTION},chr(10)+chr(13))[1]
The second...
I hope someone can help me with this little mind bender. I have a report in which I'm trying to split a memo field into different sections based on a Hard Return. Example of Data in feild:
1st section of information
More info
More info
2nd section of Information
More info
More info
I want...
When I reorganized the placement of the formulas I was getting the result I wanted, but I was also getting repeated data on several rows. So I thought about what you said in regard to the grouping and I changed it to reflect the grouping in the main report and it worked like a charm. Thanks...
Hey Dana,
First of all thanks for your help. I was actually using these formula already from one of your previous posts, but this only lists them in the same way as if I just had the field in the details section of the subreport:
John Doe
Jane Doe
Jack Doe
I need them to be listed side by...
I have a basic subreport with one field in the details section of the report that brings back a list of individuals connected to the table in my main report.
Ex:
John Doe
Jane Doe
The number of people varies for each new instance in my main report. (There could be 2, 3, 9 etc. people listed)
I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.