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!

  • Congratulations strongm 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: *

  1. shelby101

    SP2013 Calculation columns in a library

    Update This formula works perfectly =IF(Years=”7”,[End Date]+2555 This one does not work =IF(Years=”7”,[End Date]+2555,IF(Years=”10",[End Date]+3650,IF(Year=”5",[End Date]+1825.""))))
  2. shelby101

    SP2013 Calculation columns in a library

    Hi, I am struggling with how to do the following calculation. I cant get a clear answer on if nested calculations on numbers only on colors. Column1 Column2 Column3 [End Date] Years Purge Date 1/31/2015 7 12/30/2021 1/31/2015...
  3. shelby101

    workflow email options using Nintex on a Document Library SP2013

    I am working with SharePoint 2013, with Nintex and KnowledgeLake add ons and I am new to ALL three. I have a basic Document Library for records retention. One of my columns is "Purge Date" I want to create a workflow that pulls all the documents with a purge date greater than current date and...
  4. shelby101

    SQL combine two convert functions into one field

    fredericofonseca Hi, I tried to suggestion..... thank you very much by the way. When I tried the code I got an Syntax error in SQL statement at or about "varbinary(100)
  5. shelby101

    SQL combine two convert functions into one field

    Hi Andy, The two expressions in this issue do return data individually. They are "WorkMobile" and "OptOutMobile" listed above in the statement. I attached a sample of what is returning and the desired outcome...
  6. shelby101

    SQL combine two convert functions into one field

    Hi, I am using Crystal 2011 sql command to pull data from a progress environment. see command below. Problem is the highlighted line is only returning the second convert function. Can someone please tell me what I am doing wrong?ponder. I would really appreciate help. SELECT...
  7. shelby101

    Crystal 2011 sql command (combine two convert functions)

    Hi Dell, Thank you for your response. Combining the fields in crystal will not be useful with particular report. The access query I have to connect to could potentially have both workmobile and optoutmobile data. The field that I am trying to create is the field that I want to use for my link...
  8. shelby101

    Crystal 2011 sql command (combine two convert functions)

    Hi, I am using Crystal 2011 sql command to pull data from a progress environment. see command below. Problem is the highlighted line is only returning the second convert function. Can someone please tell me what I am doing wrong?[ponder]. I would really appreciate help. SELECT...
  9. shelby101

    syntax error on or about "union all" in crystal reports 2011

    Ok, I have checked the queries, and added columns where there needed to be a filler, still not working, any thoughts? SELECT "ap_invoice1"."kco", "ap_invoice1"."gan_code", "ap_invoice1"."ain_posted", "ap_invoice1"."avm_num", "ap_invoice1"."ain_amount", "ap_invoice1"."ain_retain"...
  10. shelby101

    syntax error on or about "union all" in crystal reports 2011

    Hi, I have the following union query that I am using to access data from a Progress Open Edge using Crystal Reports 2011 and I am getting the error: No of expressions projected on either side of set-op dont match (7582). Both queries work fine independently and I can't see what is wrong with...
  11. shelby101

    the text, ntext and image data can not be compared error

    Hi Gordon, thanks for the suggestion. Still not getting!the WHERE clause for TaskId = 2. This is making me crazy i tell ya!
  12. shelby101

    the text, ntext and image data can not be compared error

    Yea I tried subquery as well. The goal is to get every workorder that only has 1 note record. (dont ask why this was requested b/c idk :-)) Anyway this is the subquery command that i tried and it's still not returning the correct data. SELECT "TaskNote"."WOID", "TaskNote"."TaskNoteTypeId" AS...
  13. shelby101

    the text, ntext and image data can not be compared error

    Hey Kray4660, SQL, but I found a workaround for that part. SELECT "TaskNote"."WOID",Count( "TaskNote"."TaskNoteId") AS 'CountNotes', "TaskNote"."TaskNoteTypeId" AS 'TypeId',"TaskNote"."TaskNoteCategoryId" AS 'CatId',"TaskNote"."CreateDate" AS 'Date',"TaskNote"."CreatedBy" AS 'Tech', CAST...
  14. shelby101

    the text, ntext and image data can not be compared error

    Hi all, can anyone tell me what I am missing here. Using CR2011 and needed to create the following command. Tested piece by piece and command works until I get to the final "TaskNote"."NoteText" I get the error "the text, ntext and image data types cannot be compared or sorted, except when...
  15. shelby101

    exclude data using a running total

    still not getting the correct results. trying a 3 part variable to see if that helps. Thanks for the info tho, I appreciate it.
  16. shelby101

    exclude data using a running total

    Hi, I tried that, the problem is the 1. My desired result is to only get the orders that had only 1 note.
  17. shelby101

    exclude data using a running total

    Hi,I'm need to exclude specific data from a very basic crystal 2011 report. I have identified the data that I need to exclude and I can surpress the data, I need to also only get the actual total count. Goal is to only select the Orders with only 1 TaskNoteID and exclude that OrderID all...

Part and Inventory Search

Back
Top