I have tried my query on db and its successfully working ... here is my query which declare as $genSQl
WHERE recType = 'I' AND customerID IN ('064') AND branchCode IN ('0025') AND
categoryCode IN ('15-03') AND statusCode IN ('6') AND severity IN (3) and
(DATEADD(dd, 0, DATEDIFF(dd, 0, createDate)) between
DATEADD(dd, 0, DATEDIFF(dd, 0,'2016-01-05 10:19:46.000'))
and DATEADD(dd, 0, DATEDIFF(dd, 0,'2016-01-11 12:14:42.000')))
group by prCode, prCategory, category, severity, getDate, shortName, logNo, resoCreateDate , custReportNo,customerId,branchCode,branchName,callerName,callerPhone,
dateReport,timeReport,dateClose,timeClose,severity,prCode,category,
cmDescription,dateCreate,timeCreate,dateEnd,timeEnd,action,resolutionDesc
,aging,statusCode,statusDesc,recType,createDate,cbState,agingClose, agingActr,cmCreateId,cmGroupId,crAction,crCreateId,cmVendorId,
cmAssetSn,cmFwdTo,catCode,rcgCheckGroup order by shortName, logNo, resoCreateDate
Hi .....My report successfully generate on local but not working on server . When i try copy the result of the code to my server terminal as below
It terminal show error like below statement
Error filling reportError executing SQL statement for: listReport
Here is my code
I have tried my query on db and its successfully working ... here is my query which declare as $genSQl