Custom reporting

[EZi]

Hi All,

 

I'm needing some help with creating a custom report.

 

I want to show the "userid", the "productname" and the "billingcycle" (but the latter only for those products that are labelled "Free Account").

 

I have included the sample with some adjustments but without any substantial results.

Is there anyone that can put in the relevant entries under "tableheadings" and "tablevalues" to achieve the above?

I can then probably reproduce this for other reports...

 

Thanks in advance for any advice...

 

Rene

 

<?php

 

# The title of your report

$reportdata["title"] = "Free Accounts Exception Report";

 

# The description of your report

$reportdata["description"] = "Report to check if client is paying";

 

# Header text - this gets displayed above the report table of data

$reportdata["headertext"] = "Free Accounts Exception Report";

 

# Report Table of Data Column Headings - should be an array of values

$reportdata["tableheadings"] = array("Column 1","Column 2","Column 3");

 

# Report Table Values - one of these lines for each row you want in the table

# should be an array of values to match the column headings

$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3");

$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3");

$reportdata["tablevalues"][] = array("Data 1","Data 2","Data 3");

 

# Report Footer Text - this gets displayed below the report table of data

$data["footertext"] = "";

 

?>