Search results for query: *

Hey again, think I got it figured out... I tried using another part number with less sales and a shorter time frame and I noticed that every line item was getting duplicated for every location we had due to my join statement. I changed it to select * from V__salesWsmsa left join V__inv_cats...

Thanks again for the response, I've tried using Crystal Reports, Crystal will bring up the preview for the first page fast once the databases are linked, but it will still take a while for it to get through all of the data and it takes around 10+ minutes to run the report once the report is...

Hey Mirtheil, Thanks for the reply. I'm using Pervasive 11.3, I tried bypassing the view and linking to the table directly but that didn't have any effect either. Other joins that I have done have worked but just not this one so I was thinking that maybe I was using the wrong join at first...

Hey all, Not sure what I am doing wrong with this join for some reason I am unable to link 2 different tables that have a matching linked field. I used the following queries to make sure that there were matching fields.. select * from table1 where cust = 27070 (returns 2738 rows - showing...

Thanks a ton for the help, I'll try it out!

Hi all, Recently started up in a new role that is using Pervasive DB to go along with their ERP system. They have a cpl servers running Pervasive fictitiously named ABC and ABCWEB. All of the main data from the ERP program is entered into server ABC Database GLOBAL but reports off of an...

Hello, I am trying to use the following VB macro that works in Excel to encode Barcodes using barcode 128 in Crystal Reports. (Cant use 3 of 9 because I need a space and a comma) Can anybody help me get this to work in Crystal or have a different method of getting Barcode 128 to work in Crystal...

Hello, A friend of mine was using Sage Accpac v6 and now wants to switch to Sage Accounts 50. He is using a SQL 2008 database on a Windows 2008 server. Is there any way to import everything? I tried exporting customer records from Accpac 6 to import into Accounts 50 but I am worried that there...

Heya, Everything taking note of any type of remote IP address, either IIS logs, webpages with Request.ServerVariables("REMOTE_ADDR") or programs like our chat program that show remote users IP addresses are all coming up with our WAN IP address instead of the remote users IP. Everything...

Heya, Our company has an optional field created under AR for "BusinessType". We would like this optional field in CRM so we can create groups based on this field for mass maling, but unfortunately I don't know enough about database administration to make it happen. I guess I am looking to get...

Thanks ettienne for as valuable post as always, and a more genuine thanks to tuba, ill try and convince him to give it up.

Thanks for the reply, but if I'm going to tell the owners that I can't convert their data, they are going to want to know how much work it is to convert. Can you give me an outline of the process? Thanks

Hey all, At the end of every fiscal year, my company creates a new "Year End" database so if they need to see anything with the way things were at that time, they have a static, different company with that information in it. We have just upgraded to Sage Accpac ERP v5.6 and our Live data, 2008...

I spoke too soon.. I put the subreport in Details A and the formula with the shared variable in Details B and it works as long as there is there is new data in the subreport to passover, but if there isnt anything new, it carries over the total from the previous row until there is new data. Is...

That worked! Thanks!

Heya all, I have made a subreport with the formula... whileprintingrecords; shared numbervar contractitemprice:= {ICPRICP.UNITPRICE}-({ICPRICP.UNITPRICE}*({@Contract Price Level})/100) it gives me the results im looking for in the subreport, but then when I try and pass the data on to the...

Thanks to everybody! I was able to get the system up and running, with all the renovations being done to our warehouse, I guess the cable from the star talk got damaged, because after i replaced it, it stopped giving me the "not initialized" message and let me get in to change the info from the...

@Curlycord As I had stated in my original message, it does not ask for a password. it says it is an inactive feature. @bob thanks, i will read up on it and find my own answer.

My company has recently purchased a blg that had a Star Talk flash system in it with sw: version 1.7. Right now, if we have it plugged in to a phone box that has "voice mail" written on it, anybody who phones will go straight to an old ccr system setup by the previous tennant. After searching...

Thank you so much. Exactly the information I needed and it was nice and quickly given as well. All without making me feel like a dumbass. I was able to remove the epos line from my csapp table, install acdev and now all is hunky-dory again. Thanks!