Help Needed in Displaying LiveReport

Elanthirayan_Jeyaraman

Hi,I have a LiveReport SQL Query, which looks something like this."select distinct(WF_ValStr),count(WF_ValStr) from [les971].[les971].[WFAttrData]where WF_ValStr in (select distinct WF_ValStr from [les971].[les971].[WFAttrData] where WF_AttrType=10) group by WF_ValStr"This query basically returns the status value of the workflow and its count.The above mentioned returns the following output in the LiveReport.STATUS APPROVED 9 PENDING 3 My requirement is how do i make the output look likeHi STATUS APPROVED 9 PENDING 3 How do you tamper the livereport to insert some message and the username above the query results.Any help would be highly appreciated.Cheers,Elan

Donna Nalls

Hello Elan,You might want to consider using the WebReports module - you can create very attractive reports with dynamic content, such as the user name and message, in your letter format.For more info about the module, contact the folks at Resonate KT. http://www.resonatekt.comRegards,Donna