1. Scott
  2. Valentina Database ADK
  3. Вторник, Август 23 2016, 06:18 PM
  4.  Подписаться через 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);
Комментарий
There are no comments made yet.
Scott Ответ принят
Thank you sir! You saved the day.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hi Scott,

This command looks different for VPHP:
vreport_set_parameter_value($report, "startDate", $startTimeStamp);
vreport_set_parameter_value($report, "endDate", $endTimeStamp);
Комментарий
There are no comments made yet.
  • Страница :
  • 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