1. Scott
  2. Valentina Database ADK
  3. Dienstag, August 23 2016, 06:18 PM
  4.  Abonnieren via E-Mail
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);
Kommentar
There are no comments made yet.
Scott Akzeptierte Antwort
Thank you sir! You saved the day.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hi Scott,

This command looks different for VPHP:
vreport_set_parameter_value($report, "startDate", $startTimeStamp);
vreport_set_parameter_value($report, "endDate", $endTimeStamp);
Kommentar
There are no comments made yet.
  • Seite :
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories