Sql query to generate Live Report with forms fields in new line

dvt1985

We are using Content Server 10 and had used Sql table as storage mechanism only in Form Template. We want to generate a Live Report in which some form fields should be captured but among them, some should be in a new line.

For Example-

Account_Name       AveragePoints            Workflow_Name

Dev                                   2                              Reinsurance WF

 

Officer Comments

     Approved

 

Instead of getting a single row as a result, we want the form fields to be separated in the above mentioned way.

How can it be done?

Behzad_Khosa

If you have the webreports module you can easily do this and much more.