Timothy Ackerman Posted August 2, 2016 Share Posted August 2, 2016 How can I create a merge field that contains the values in portal rows? For instance: Let's say I have 3 kids, and each kid has a list of food preferences, medical conditions, prescriptions. My kids are on a portal on the "minors" layout. Now, I want to put all of the kids data on a report for the parents. Kid1 -- (portal row1) Medical Condition: <<medical conditions>> (portal row1) Prescriptions: <<prescriptions>> (portal row1) Now, how to I list the next row in the portal? Kid2 -- (portal row2) Medical Condition: <<medical conditions>> portal row2 Prescriptions: <<prescriptions>> portal row2 And so on. Right now I'm using portals on my report, (Initial row = 2 with number of rows =1) but the fields don't slide up when the parent doesn't list something in say the prescription field, so I'm left with whitespace wherever the parent left it blank. My attachment shows my current problem using portals on the report. You can see that everything is set to sliding up. Also I have set to shrink the enclosing fields. Also, I have set to hide objects when they are left blank. If anyone knows why these portals will not slide up, that would be great, but I suspect it would be best to learn how to stick merge fields in that are portal rows 1.2.3... to make the solution faster. (tons of portals is slow) Thanks in advance! Link to comment Share on other sites More sharing options...
Wim Decorte Posted August 2, 2016 Share Posted August 2, 2016 I don't think you want to do this in merge fields. Create the report from the context of the conditions and show the kids data related in a sub-summary part. No sliding needed this way... Link to comment Share on other sites More sharing options...
Timothy Ackerman Posted August 5, 2016 Author Share Posted August 5, 2016 Wim Thanks! Created a report, and it works great! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2819 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