Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gilsonr
  • Order by date
  1. gilsonr

    Enterprise Miner

    I have SAS 8.2 running under Windows XP home edition. But when I open up Enterprise miner it does not display correctly, therfore is there a compatability issue.
  2. gilsonr

    Using a formula in a if then else statement

    Thanks for the response, amended the code as follows if {status} = 86 then "Live" else if {status} = 87 then "Live" else if {status} = 88 then "Live" else if {status} = 89 then "Live" else if {status} = 90 then "Live" else if {status} = 91 then "Archive" else if {status} = 97 then "Archive" else...
  3. gilsonr

    Using a formula in a if then else statement

    I have created the folloing if then else statement in a formula field if status = "86" then "Live" else if status = "87" then "Live" else if status = "88" then "Live" else if status = "89" then "Live" else if status = "90" then "Live" else if status = "91" then "Archive" else if status = "97"...
  4. gilsonr

    Extracting Month from current date

    How do I extract the Month name (i.e. March) form the current date.
  5. gilsonr

    Cross- Tab Total field

    Ibass Thanks for the, it seems that Im going in the right direction. I have created a Running Total Formula as you suggested for a couple of the columns in the xtab. The columns are populated with values but unfortunatley they are not the correct counts. Essentailly what I am trying to create...
  6. gilsonr

    Cross- Tab Total field

    ShortyA Thanks for the help, I see what you mean about creating a manual x-tab , its a bit more involved. I have created the rows with no problembut Iam having trouble with the conditional formula that creates the column values. Tried the following if-then-else, but its not quite right if...
  7. gilsonr

    Cross- Tab Total field

    ShortyA Thanks for the response, you have summarised my problem exactly. The Column & Row Grand Totals are distinct counts, how do I amend the x-tab so that the totals add up.
  8. gilsonr

    Cross- Tab Total field

    ShortyA Thanks for the response. Iam using Crytal version 9.2.0.448, and I am connecting to an Oracle Database via Microsoft ODBC for Oracle. In the cross tab the summarised field values are correct, but the Grand Totals for the Rows & Columns dont add up to the correct values.
  9. gilsonr

    Cross- Tab Total field

    I have created a report which just contains a Cross-tab. The problem is that the values are OK, and the column totals are OK, its just the row total that are not correct. Any suggestions would be appreciated.
  10. gilsonr

    Business Objects Grand Total

    This is probably a really basic question, but how do I add a Grand Total to a Report
  11. gilsonr

    Access 2000 Electronic Signature

    I am trying to add an authorisation field to the bottom of an Access Form. As the database is to be used for authorising Purchase Orders within the Finance department, I need to add some sort of 'Electronic Signature' to the authorisation field. This will used to track and audit who has signed...
  12. gilsonr

    Date Problem

    Chrisw75 & dje thanks for the help I initially tried this code data valex.BG; set cmn.Camt_promo_history; keep contact_urn source_account response_code campaign_ID date_extracted ; where substr(response_code,1,5, in ('XP87P','XP88P','XP89P','XP90P','XP92P','XP93P'...
  13. gilsonr

    Date Problem

    I am running a query against an Oracle database that stores dates in the following format 23SEP2004:00:00:00. When I try to select records for an specific day, in a where clause I dont get the correct results. I am using the Datepart function to get rid of the Hr:mm:ss. Any ideas
  14. gilsonr

    Record selection

    Formula as requested isnull({CAMP_MGT.Date Completed}) and isnull({CAMP_MGT.Dialler File 1 Loaded}) and isnull({CAMP_MGT.Dialler File 2 Loaded}) and isnull({CAMP_MGT.Dialler File 3 Loaded}) and {CAMP_MGT.Job type} <> 9 and ({CAMP_MGT.Mailing File Due Date} in DateTime (2003, 10, 01, 00, 00...
  15. gilsonr

    Record selection

    Thanks for all you help its very much appreciated. I have amended the code above to fix the problem that I was having with the bracket and it works OK. But the records I now get are lower than expected, as I have run the same selection in Access. My guess at the formula that I need to produce...
  16. gilsonr

    Record selection

    Thanks for the help, I was on the right lines but I could not get the syntax to work. I have created the following code in the Record Selection formula section isnull({CAMP_MGT.Date Completed})) and ({CAMP_MGT.Job type} <> 9 and ({CAMP_MGT.Mailing File Due Date} in DateTime (2003, 09, 01...
  17. gilsonr

    Record selection

    I need to select records based on the follwoing criteria Job type not equal to cancelled and Mailing date between X and Y and Completion date is null or Job type not equal to cancelled and Calldate1 between X and Y and Completion date is null or Job type not equal to cancelled and...
  18. gilsonr

    Using Parameters in Crosstabs

    Is it possible to use a date range parameter to controll a cross-tab report, if the cross-tab is in the report header.
  19. gilsonr

    Number Date Conversion

    I have a Date field which is displayed as a series of numbers i.e. 200203051200310, and I want to convert this to a date field. Attached is the formula that I have been using to convert the number to a date. CDate(Mid([dbo_options]![LAST_UPDATE_MINI],7,2) & &quot;/&quot; &...

Part and Inventory Search

Back
Top