Custom Report Help - Excel plugin to Webreports

Reporting
1

(imported topic written by eenglish)

I used the excel plugin to the report I require…I would like to put it into webreports so i can have an automatic report generated. I am unable to get it to format properly so the info is in column when using session relevance.

Here is the code from the excel plugin if anyone can assist with how to get it into session relevance for webreports:

( item 0 of it as string & “$x$” &

item 1 of it as string & “$x$” &

(if ((year of date (local time zone) of it) as integer = 1980)

then ("")

else (

(year of it as string & “/” &

month of it as two digits & “/” &

day_of_month of it as two digits) of date (local time zone) of it & " " &

(two digit hour of it as string & “:” &

two digit minute of it as string) of time (local time zone) of it))

of (item 2 of it as time)& “$x$” &

item 3 of it as string & “$x$” &

item 4 of it as string )

of (

(if (exists ID of it)

then (ID of it as string)

else ("")),

(if (exists Issuer of it and exists Name of Issuer of it)

then (Name of Issuer of it as string)

else ("")),

(if (exists Time Issued of it)

then (Time Issued of it as string)

else (“Fri, 15 Feb 1980 00:00:00 -0000”)),

(if (exists Name of it)

then (Name of it as string)

else ("")),

(if (exists Targeting Method of it)

then (Targeting Method of it as string)

else ("")))

of

BES Actions

whose (

(Targeting Method of it as lowercase = “by list”))

Thanks very much!

2

(imported comment written by Lee Wei)

Here is a simple but complete Session Relevance statement that you can use in Web Reports.

(html 
"<table border=1><th>Action ID</th><th>Issuer</th><th>Time Issued</th><th>Action Name</th>" & it & html 
"</table>") of concatenation of trs of ( td of item 0 of it & td of item 1 of it & td of ((

if ((year of date (local time zone) of it) as integer = 1980) then (
"<none>") 

else ( (year of it as string & 
"/" & month of it as two digits & 
"/" & day_of_month of it as two digits) of date (local time zone) of it & 
" " & (two digit hour of it as string & 
":" & two digit minute of it as string) of time (local time zone) of it)) of (item 2 of it as time)) & td of item 3 of it) of ( (

if (exists ID of it) then (ID of it as string) 

else (
"<none>")), (

if (exists Issuer of it and exists Name of Issuer of it) then (Name of Issuer of it as string) 

else (
"<none>")), (

if (exists Time Issued of it) then (Time Issued of it as string) 

else (
"Fri, 15 Feb 1980 00:00:00 -0000")), (

if (exists Name of it) then (Name of it as string) 

else (
"<none>"))) of BES Actions whose ((Targeting Method of it as lowercase = 
"by list"))

Attached is a better formatted report using the same Session Relevance above.

Lee Wei

3

(imported comment written by eenglish)

Thanks so much…that helps me going forward and was exactly what I was looking for…Cheers!