Welcome, Guest. Please Login.
05/17/24 at 01:15:02
News:
Home Help Search Login


Pages: 1
Send Topic Print
Web site data (Read 836 times)
wrf46
Browser
*


I love YaBB 1G -
SP1!

Posts: 24
Web site data
10/18/06 at 12:00:03
 
Using Crystal Reports to print a report from the Customer table, I can setup the report to print the Customer Code, Customer name, phone numbers and contacts but can not figure out how to add the Web site field to the report.  All info for the report is selected from BKARCUST file.  What table holds the data for the Web Site?  
 
Thanks
Bill
Back to top
 
 
  IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Web site data
Reply #1 - 10/18/06 at 12:55:57
 
It is probably buried in a text string. They have had to do this in some cases due to not having an available field in the file set. Maybe?
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Web site data
Reply #2 - 10/19/06 at 07:02:37
 
I changed a web address and the only files that changed were BKARCUST and BKARDESC. Neither one of them seem to have the data.
 
Guess we'll have to have the programmers tell us...
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
dameng
Senior Member
****


DBA / EVO Software
Consultant

Posts: 275
Gender: male
Re: Web site data
Reply #3 - 10/20/06 at 05:57:11
 
It is in the BKARDESC file as you found out. the web address is in BK_DESC_NOTES, however, they use the BK_DESC_CODE to list the customer code joined with a prefix of WEB.
 
i.e. if my customer code is AJAX for ACME JAXSON CONTROLS.... then the BK_DESC_CODE field will have WEBAJAX with the BK_DESC_NOTES holding the www.ajax.com
Back to top
 
 

Dave Mengelkamp
Digital Consulting
760.832.2536
davemeng@earthlink.net
Email WWW   IP Logged
Pages: 1
Send Topic Print