Search results for query: *

I can get the data frome one Company with the following script: SELECT RM20101.CUSTNMBR, RM00101.CUSTCLAS, RM20101.DOCNUMBR, RM20101.DOCDATE, RM20101.CURTRXAM, RM20101.ORTRXAMT, RM20101.CSPORNBR FROM DIBAI.dbo.RM00101 RM00101 LEFT OUTER JOIN DIBAI.dbo.RM20101 RM20101 ON...

I need to clarify that the version is CR XI. Thanks for your help,Jayne

I'm using Crystal Reports version II. I would like to know if I can link from different databases the same table to obtain my data. For ex. Company A and Company B each has a different ODBC name. however table IV00101.dat is included on both companies. I would like to take the information of...

I need to make date changes after finding the documents in smartlist. The macro changes the date fine, but we need the macro to move down each line to the next document in smartlist. Can someone look at the following macro and tell me what's missing for the macro to move through the list...

You got me on the right path. I changed your formula sightly, this is what I ended up with: (if {?Disc} = "DISC" then {IV00101.USCATVLS_2} > "$0" else {?Disc} = "All"). Thanks very much for your help. Jayne

Thanks for your help. This worked to eliminate items that are not dicounted and only print the items with a value in that field. I want to make it an option to print all items or only the discounted items. I was trying to do this as a parameter seletion using DISC as a parameter field. Jayne

Using Crystal XI WITH SQL 2005, I need to create an option to select items which have a value >0 in IV00101.USCATVLS_2. If value is blank I do not want the items in the report. The field is renamed 'DISC' and the values in the field represent discounted prices. Any help would be great...

The smartlist iitem includes fields from the item master and item qantity master linked by the item #. Each item # is printing two times when I run the smart list. When I linked the SOP transaction work table by item number each item printed many times. How do I stop the item # from printing...