| Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-276879 - PLease correct the script to generate the quarterly report |https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-276879]
*Steps:*
Please make this Query to work to generate Quarterly reports in i21 dashboard
Select Convert(NCHAR(8),tblCFTransaction.dtmTransactionDate,112) As 'dtmTransactionDate', Replace(Convert(varchar(5),tblCFTransaction.dtmTransactionDate,108), ':', '') As 'dtmTransactionTime', Convert(NCHAR(8),tblCFTransaction.dtmInvoiceDate,112) As 'dtmInvoiceDate', Replace(Convert(varchar(5),tblCFTransaction.dtmInvoiceDate,108), ':', '') As 'dtmInvoiceTime', tblCFTransaction.strTransactionId, tblCFSite.strSiteNumber, tblCFSite.strSiteName, tblCFSite.strSiteAddress, tblCFSite.strSiteCity, tblCFSite.strTaxState, tblCFCard.strCardNumber, tblCFCard.strCardDescription, tblCFTransaction.intOdometer, tblCFTransaction.dblQuantity, tblICItem.strItemNo, tblCFTransaction.dblCalculatedNetPrice, tblCFTransaction.dblCalculatedTotalPrice, tblICItemLocation.strDescription, tblCFTransaction.dblCalculatedGrossPrice, tblCFTransaction.dblOriginalGrossPrice, vyuCFAccountCustomer.strCustomerNumber, vyuCFAccountCustomer.strName, tblCFTransaction.dblOriginalNetPrice, tblCFItem.strProductNumber, tblCFTransaction.ysnInvoiced, tblARInvoice.strInvoiceNumber, tblCFVehicle.strVehicleNumber, tblCFTransaction.strMiscellaneous, tblCFVehicle.strVehicleDescription, tblCFCard.strCardPinNumber, Right('00000' + LTrim(RTrim(Cast(tblCFCard.strCardPinNumber As varchar))), 5) As PIN1, Right('00000' + LTrim(RTrim(Cast(tblCFCard.strCardPinNumber As varchar))), 5) As PIN2, Right('00000' + LTrim(RTrim(Cast(tblCFVehicle.strVehicleNumber As varchar))), 5) As [Veh #], tblCFTransaction.dblCalculatedTotalTax From tblCFTransaction Left Join tblCFSite On tblCFTransaction.intSiteId = tblCFSite.intSiteId Left Join tblCFCard On tblCFTransaction.intCardId = tblCFCard.intCardId Left Join tblICItem On tblCFTransaction.intARItemId = tblICItem.intItemId Left Join tblICItemLocation On tblCFTransaction.intARLocationId = tblICItemLocation.intLocationId And tblCFTransaction.intARItemId = tblICItemLocation.intItemId Left Join tblARInvoice On tblCFTransaction.intTransactionId = tblARInvoice.intTransactionId Left Join tblCFItem On tblCFTransaction.intProductId = tblCFItem.intItemId Left Join tblCFVehicle On tblCFTransaction.intVehicleId = tblCFVehicle.intVehicleId Left Join tblCFAccount On tblCFCard.intAccountId = tblCFAccount.intAccountId Left Join vyuCFAccountCustomer On tblCFTransaction.intCustomerId = vyuCFAccountCustomer.intCustomerId Where @DATE@
*Issue:*
Not able to export the dashboard with '#' on column name
*Acceptance:*
Should be able to export the dashboard with '#' on column name
|