1. Scott
  2. Valentina Database ADK
  3. 火, 8月 23 2016, 06:18 PM
  4.  メールで購読
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