1. Scott
  2. Valentina Database ADK
  3. Tuesday, August 23 2016, 06:18 PM
  4.  Subscribe via email
I can't get report parameters to work in PHP. Are they supported? This is what I am using:

PHP 5.5.36 Latest PHP ADK download. OS X/Apache

$query = "SELECT tblJobs.seqNo as JobNumber,
tblDetails.RecID as DetailID,
rate,
vendorID,
firstName,
lastName,
fullrankname,
NameCaps,
permID,
cellPhone,
tblUsers.RecID as User_ID,
address,
city,
state,
zip,
rank,
detailName,
manager,
from_UTC(from_unix_timestamp(startDate)) as startDate,
from_UTC(from_unix_timestamp(endDate)) as endDate,
hoursWorked,
subpay2,
holidayRate,
invoiceComments,
submittedDate,
monthname(sDate) as reportPeriod
from tblJobs, tblUsers, tblCompanies, tblDetails
WHERE startDate BETWEEN $P(startDate) AND $P(endDate)";

$report = vproject_make_new_report_with_datasource($project, 'Weekly_Summary', $datasource, $query);
$report.SetParameterValue("startDate", $startTimeStamp);
$report.SetParameterValue("endDate", $endTimeStamp);
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hi Scott,

This command looks different for VPHP:
vreport_set_parameter_value($report, "startDate", $startTimeStamp);
vreport_set_parameter_value($report, "endDate", $endTimeStamp);
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Scott Accepted Answer
Thank you sir! You saved the day.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories