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 Chris Miller 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. troop49

    SQL Server login authenticity ID???

    When i try to connect thru the ODBC Data Source Administrator is it asking me to enter a : SQL Server authenticity of the login id? where on the SQL server do i set the user name and password to that instance or database?
  2. troop49

    SQL SERVER 2005 - INSTANCES

    YES!!!!! YOU ARE ALWAYS RIGHT!!! THANK YOU!!! WOOOHOOO!!
  3. troop49

    SQL SERVER 2005 - INSTANCES

    IT DID NOT PROMPT FOR AN INSTANCE NAME. ahhhhha!!!
  4. troop49

    SQL Express 2005 new instance creation issues

    Ok i just did it but my new instance had the name of SQLExpress how can i name it what i want???
  5. troop49

    SQL SERVER 2005 - INSTANCES

    I need to find out how to create multiple instances. HELP!!!
  6. troop49

    Display today date day with the suffix after the day.

    // If day(CurrentDate) in [ 3, 23] then 'rd' else If day(CurrentDate) in [ 1, 21, 31] then 'st' else If day(CurrentDate) in [ 2, 22] then 'nd' else'th' THis work beautifully. THANK YOU!!!!!!!
  7. troop49

    Display today date day with the suffix after the day.

    Example: 17th day of September 2010 How can i display the 'th' after the 17 or the 'rd' for the 3rd etc...
  8. troop49

    StringVar to convert to numberic value??

    StringVaribable need to convert to numberic value.
  9. troop49

    Using Formula to read from a table??

    is it possible to create a key in the formula and then use that to read the table. ?
  10. troop49

    Data Field Minus 1 formulua

    WOW!!!! this did it. I didn't understand how to convert a string to a numeric so the math calc could take place. Thank You! Thank You!
  11. troop49

    Data Field Minus 1 formulua

    This is my formula: ({ESYAPPTR.STEP}) - 1 ____________ I received this email. Error Message: "A number, currency amount, date, time, or date-time is required here.
  12. troop49

    Data Field Minus 1 formulua

    This is my Field values 01 1 2 3 4 5 6 7 8 9 CL But I need to just minus 1 from the data string for display.if the field is 5 should display a 4.Thanks.
  13. troop49

    a NOT Equal on several types

    I have several funds i need to display on the report but i have certain one i DO NOT want to include on the report. expression: @fund <> "520""610""648""691" how can i exclude them with out doing @fund <> "520" and @fund <> "610" and etc..... I know there has to be a way. Thanks,
  14. troop49

    Shared Variable from Subreport1 to Subreport2

    Just to let you know that after I create GF#3_b. IT WORKED BEAUTIFULLY. Thank you!!! Thank you. Now i can move on.
  15. troop49

    Shared Variable from Subreport1 to Subreport2

    STILL nothing ahhhh!! Help. My Subreport1 (has my variable i need) in GF#3 then i moved Subreport2 (that needs to read variable from SubR1) in GF#2. and nothing!!!
  16. troop49

    Shared Variable from Subreport1 to Subreport2

    I can't seem to pass the variable from subreport to another subreport??? In the group footer i have the subreport that does the calc that i need in another subreport with in the same group footer. In the main report i created a formula call ShrAccumLvlike this: shared NumberVar Leave Then In...
  17. troop49

    Passing formula field to subreport fails on Crystal XI/BOE XI

    I can't seem to pass the variable from subreport to another subreport??? In the group footer i have the subreport that does the calc that i need in another subreport with in the same group footer. In the main report i created a formula call ShrAccumLv like this: shared NumberVar Leave Then in...

Part and Inventory Search

Back
Top