Help creating report with starting date

[Arthur Jansen]

Hi There,

I'm looking for a way to create a report with a list with the name of the cliënt, the name of the product and the starting date.

Strangely enough when you go to Reports > Services there is no way to select the starting date there.

When contacting support they just send me here: https://docs.whmcs.com/Reports#Creating_your_own_Reports

But I have no idea how this works, and the option to select de starting date is just a missing feature (see screenshot).

Anyone here who can help me getting this report?

[brian!]

20 hours ago, Arthur Jansen said:

Anyone here who can help me getting this report?

1. duplicate the /modules/reports/services.php file and call it services_startdate.php (or anything you like - but this will be it's visible name on the report index page and sidebar... the reason to duplicate the file is because if you edited the original, the auto updater would overwrite it with its own file...

2. edit the duplicate report and change...

$filterfields = array("id"=>"ID","userid"=>"User ID","clientname"=>"Client Name","orderid"=>"Order ID","packageid"=>"Product ID","server"=>"Server ID","domain"=>"Domain Name","dedicatedip"=>"Dedicated IP","assignedips"=>"Assigned IPs","firstpaymentamount"=>"First Payment Amount","amount"=>"Recurring Amount","billingcycle"=>"Billing Cycle","nextduedate"=>"Next Due Date","paymentmethod"=>"Payment Method","domainstatus"=>"Status","username"=>"Username","password"=>"Password","notes"=>"Notes","subscriptionid"=>"Subscription ID","suspendreason"=>"Suspend Reason");

to...

$filterfields = array("id"=>"ID","userid"=>"User ID","clientname"=>"Client Name","orderid"=>"Order ID","regdate"=>"Start Date","packageid"=>"Product ID","server"=>"Server ID","domain"=>"Domain Name","dedicatedip"=>"Dedicated IP","assignedips"=>"Assigned IPs","firstpaymentamount"=>"First Payment Amount","amount"=>"Recurring Amount","billingcycle"=>"Billing Cycle","nextduedate"=>"Next Due Date","paymentmethod"=>"Payment Method","domainstatus"=>"Status","username"=>"Username","password"=>"Password","notes"=>"Notes","subscriptionid"=>"Subscription ID","suspendreason"=>"Suspend Reason");

if you need to move where the checkbox is displayed (and hence it's column position in the output), you can just adjust the position of the "regdate"=>"Start Date" code in the above array.

[Arthur Jansen]

Damn Brian, thanks for the quick help!

I'll set it asap, thank you very much 🙂

[brian!]

Hi Arthur,

20 hours ago, Arthur Jansen said:

Damn Brian, thanks for the quick help!

no worries - glad to have helped.