Create Reports - Githubissues

mtcuison / Telemarketing-Sales

0 stars 0 forks source link

Create Reports #8

Open mtcuison opened 1 year ago

mtcuison commented 1 year ago

Request for additional report:

[x] Leads and Status (Customer | Mobile | Status | Agent)
- source table are Call_Outgoing, xxxSysUser, Client_Master
- Reports -> Leads
- Filter form -> Date Range, Status(Open, Queued, Called, Discarded)
[x] MC Sales Encoded Report (Customer | Mobile No | Agent | DR No | Brand | Model | Selling Branch)
- source table are TLM_Sales, MC_SO_Master, Client_Master
- Reports -> MC Sales
- Filter form -> Date Range, Selling Branch, Agent

mnv121 commented 11 months ago

INSERT INTO xxxReportOther (sReportID, sReportNm, sFileName, sProdctID, nUserRght, cRegularx, cLogRepxx, sModified, dModified) VALUES('TLMC3','Telemarketing MC Sales','TLMMCSales','TeleMktg','255','0','0','imayn',NULL);

INSERT INTO xxxReportOther (sReportID, sReportNm, sFileName, sProdctID, nUserRght, cRegularx, cLogRepxx, sModified, dModified) VALUES('TLMC2','Telemarketing Lead Status','TLMLead','TeleMktg','255','0','0','iMac',NULL);

\192.168.10.254\c\GGC_Systems\vb.net\ReportsTLMMCSales.rpt \192.168.10.254\c\GGC_Systems\vb.net\ReportsTLMLead.rpt

mnv121 commented 11 months ago

mtcuison07 commented 11 months ago

For testing.

Point person: Maynard Valencia