We have a GP10 with a 3rd party integration and on one of the reports, the users would like to be prompted to select printer. Currenlty they have to change the system printer to an impact printer, print the report and remember to change it back. If user forgets to reset printer, then the next...
I'm working on modifying a packing list so shipping department can input quantity to pack/ship per orderline.
I have a dynamic parameter for them to select the orderline(s) to ship but how do I allow them to enter a qty to ship per line? I have a static parameter called qty but it puts the...
I'm needing to upgrade my Exchange server but its looking like I won't get to upgrade both Exchange and the hardware. I've been quote an HP Xeon Quad processor with 64-bit Computing.
Can windows 2000/exchange 2000 run on a system with 64 bit processing? Reseller says yes but I want to...
I have a Crystal Report based off a SQL2005 stored procedure. The report is a packing list in which an end user types in number of packages (static), weight(static), select line(s) to ship (dynamic) these works great.
Now I need to let the enduser select the full qty of the line to ship...
We use Office 2000 and I have been installing the compatibility pack as needed. However I'm having problems with Excel. I just installed it on a users system (XP with SP3, Office 2000). When I login to the system, I can open the xlsx file (domain admin) but when the user logs in they get the...
We have an application that will only use Crystal Reports created in 8.0. I have a report that when export to Excel data is getting truncated. The preview in Crystal shows all data and when exporting to Word all data is export. Any suggestions would be greatly appreciated.
Thanks
Dedra
I have a sql 2005 table containing a field for item description, when importing descriptions with quotation marks now have extra quotes. I have two questions:
1. how do I replace the quotes as in the following text:
"30"" Nova Keyboard Tray" should be
30" Nova Keyboard Tray
2...
I have an existing table with one column that needs updated approx 3000 rows. We have the correct data in an excel file and the first column is the primary id of the column.
How do I update the description field in SQL with what is in excel...
Switching database formats and all existing triggers are being rewritten in sql. The following uses only one table and needs to look for the first match based on the first nine digits of item and then update certain fields in the new item created....
CREATE TRIGGER boardsize ON item
FOR...
Switching database formats and all existing triggers are being rewritten in sql. The following uses only one table and needs to look for the first match based on the first nine digits of item and then update certain fields in the new item created....
CREATE TRIGGER boardsize ON item
FOR...
The table I'm working with is a customer table which the three fields I need to work with are cust# custseq# slsman#.
Exising Data looks like:
cust# custseq# slsman#
1 0 5
1 1 5
1 2...
In our ERP database, all lines of customer addresses are stored in one field, with 4 lines possible. Example of how data is stored in the field:
1234 West;;;
1234 west; P O Box 556;;
1234 west; P O Box 556; suite 1234;
1234 west; P O Box 556; suite 1234; floor 12
With the number of lines per...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.