Newbie Questions

Re: Concat Repeating SQL Data

dannylam4 — Mon, 12 Mar 2012 13:21:17 GMT

Oooo, that makes sense. Awesome, everything worked out. Thanks!

Re: Concat Repeating SQL Data

Anson Hidajat — Fri, 09 Mar 2012 17:41:31 GMT

You'll need to create a repeating control (table or section) that is bound to the secondary data connection. Then inside the repeating control you can create a calculated value control whose value is the concat of those 2 fields that you mentioned. That should allow the data to repeat rather than only give you the first row.

Eval only works for when you want to concat repeating data into a single line of text, which I don't believe is what you want.

Concat Repeating SQL Data

dannylam4 — Wed, 07 Mar 2012 18:44:51 GMT

Hey there, I feel like this question has been asked and answered already, but I couldn't really find anything. I'm looking to concat two dataFields pulled in from SQL into a single text field. It's simply grabbing a Site and their Comments all into one field, but the two fields are repeating data. When I try and do a standard concat(../dfs:dataFields/d:program/@Site, " - ", ../dfs:dataFields/d:program/@comments) The data won't repeat the data even if placed in a repeating section. I'm expecting something like: PA - These are my comments NY - Here are my comments But I'm just getting PA - These are my comments PA - These are my comments I saw some topics using eval with concat, but I wasn't sure what the purpose of that was. Thanks!