Combining Tables/Rows with a SOQL Query

  • 14 July 2017
  • 2 replies
  • 22 views

Hi everyone!

 

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

 

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!


2 replies

Userlevel 4
Badge +8

‌,

Would you please post your query?

Cheers,

Ryan

I'll email you since there is some org-specific details I don't want to post publicly.

Reply