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. kaliak

    need to calculate datetime range for previous day

    this thread title answered my question: datetime - last 24 hours, 26 oct 06
  2. kaliak

    need to calculate datetime range for previous day

    crystal XI, windows XP the following is part of select criteria: {RSK_Occurrence.s_DateAssignedProvider} in DateTime (2008, 11, 20, 00, 00, 00) to DateTime (2008, 11, 20, 23, 59, 00) I am looking for data from the previous day, so instead of having to go into this report every day to change...
  3. kaliak

    ms sql server 7 track database changes

    Hi, windows 2000 server ms sql server 7 I am trying to track changes in the "options" tab in a particular database. Specifically, I want to see when the "truncate log on checkpoint" was checked. Are these changes logged anywhere? Thank you, Karrie
  4. kaliak

    Crystal 11 error

    We have tried this report on multiple workstations all with the same error in Crystal XI ("The Saved Data will be discarded as one or more of the formulas failed to compile.") We are using BOE, v11. Strange thing is when you preview it or export to pdf, the report produces the correct results...
  5. kaliak

    record style export problem

    I don't know if you can answer your own questions but we just installed this fix-> http://support.businessobjects.com/library/kbase/articles/c2014451.asp It fixed both the character separated value and record style (columns no spaces) problems.
  6. kaliak

    record style export problem

    Hi, Crystal 8.5, sql server 7.0, windows xp when exporting to record style format(column no spaces), one of our formula fields, a date, is being truncated in some records but not all. here is the formula below: mid({@CDateSVC},7,4)+mid({@CDateSVC},1,2)+mid({@CDateSVC},4,2) which should output...
  7. kaliak

    SQL Server 7 + database maintenance plan

    Hi, SQL Server 7.0 I have used the "Database Maintenance Plan" to create a backup transaction log on our production server, which logs changes every 30 minutes. Questions: 1)Is there anyway to write the changes into 1 file through the Database maintenance Plan instead of having multiple files...

Part and Inventory Search

Back
Top