Search results for query: *

I have a field called Private_Label_Barcode that I need to read each digit and decided if odd or even. all the odd digits are to be added together, and all the even digits added together. I know that I will need to use a loop. I can't figure how to use the value of the digit found in each...

Below is a simplified version of the command I wrote. If I enter numbers for the sting parameters it works fine, when I enter letters it fails and gives an "invalid column name" showing the sting (ie. 'ABC') I have created other reports with date, number, and sting parameters, they work fine...

I have a cross-tab with date columns and store rows. The dates are dates of message transmission. The cells in the cross-tab is the number of messages sent from store to home office. This report deals with new stores for a range of days (variable). I need to show the number of messages when...

I am going through a linked server from my desktop to a AS400 using an ODBC connection To properly connect to a AS400 table with a single member I must use the following SELECT * FROM AS400_A.S1018328.NMLIB.NMPTSPL I need to access a table with multiple members. Several sources suggested the...

I am using crystal command to write my own SQL. I need to add a parameter (in the command window, not in the report) that is the users see as a date but I need to convert that to a number format YYYYMMDD to match the records in the database (they will not change the database). They insist on...

Writting reports using "command" accessing an AS/400 database using IBM iSeries ODBC Driver DB2 UDB. Most of the standard SQL commands don't work. ie. currentdate needs to be curdate () and it will not accept any back dating (-1). convert can not be used only cast Does anyone know of a...