db-nbtc

Combining Tables/Rows with a SOQL Query

Discussion created by db-nbtc on Jul 14, 2017
Latest reply on Jul 17, 2017 by db-nbtc

Hi everyone!

 

I have an interesting scenario with hopefully a good solution available. I'd like your help, please!

 

I have several tables and rows where in a DDP that I'm using to put data into word. I have no problems repeating the table and rows inside the table where necessary.

 

The wrinkle came when I was asked for a summary of an amount field. I wrote a custom SOQL query using the SUM function and tested in dev console--it works great. However, when I try to use it in Drawloop--I can't figure out how-to make Drawloop treat it like a row within my table.

 

Is there a special way I need to write the query perhaps? I'm seeking the expertise of the community!

Outcomes