If we sell a company off to another party and we purchase our servers back from them. Who has the rights to the software licenses are they licensed to the server or to the company which in name no longer exists? They include several Microsoft products and Computer Associates, Crystal
I currently have a report written that prints out request for quotes for the same item to several specified vendors these vendors are specified within my Dbase. Each vendor has its own page within this report with our name address phone and fax numbers along with the vendors information. I am...
I am running Crystal Reports 8.5 with a SQL 2000 database. I am trying to return the date of the last order for each customer id number and then compare it to current date and show it only if it is older than 180 days.
order_no order_date customer_id
102005 12/24/2002 10002584...
I need a formula to look further to see if the same item exists in an invoice. I am extracting items which have been backordered or cancelled, if an item has been cancelled I need to look further on the order and see if it was reentered on another line if it was I do not want it to show on the...
We have PageMaker 6.5 and have printed duplex documents in the past out of this file and all that was done was we opened the file made a change to a certain page and now it will not print on the backside of the previous page. two sided printing is set in Document settings.
Help!!
Randy
I am trying to write a gross Profit Report with the following info on it Date, Order#, Customer Name, Gross Amt, Sales Tax, Freight, Discount, Cost of goods sold, and Net Amt.. My problem is that my cost of goods sold is spread across several lines as it is attached to each item. What I am...
I have an Item_id field that is a string field I would like to filter off all Item_id's with any characters other than numbers and then change this field to a numeric one so I can sort numerically by item_id.
Thank You,
Randy
I am trying to create a formula whereby I divide one field by another. In some cases the field used as the denominator must be a 0, because I get a "division by 0" error. I want to create a statement that would state (If standard_cost <> 0 then price_8/standard_cost else ??????). Can...
I Cannot expand the drawing/ Text toolbar, all I have is a little Icon I cannot drag it larger and when I click on it I get Adobe Photoshop online update. How can I expand this toolbar?
Thanks,
Randy
I have item id's with numeric values and item id' with alphanumeric values:
ie... inv_mast.item_id
10111
10138M
NIM2015
asst10
9185
99.01895
out of the previous records I would only want to show inv_mast.item_id records 10111...
I am running Crystal 8.5 linked to a SQL Database. I tried to supress by a UID but the rest of the items in that line double print even without a UID thus screwing up my totals. I need to suppress the rest of the detail line if a UID is not present.
Thanks
Randy
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.