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

    Internal Error. Please Contact Your System Administrator [CRCAF00000020]

    Using BOXI 4.0. Users are getting the following error: Internal Error. Please Contact Your System Administrator [CRCAF00000020] when attempting to enter prompts using either edit values or entering an individual prompt. Rebooting the CMS server seemed to have corrected the problem for one day...
  2. jtd353

    Unusual Problem Trying to Link Tables

    Thanks. I'll have them reinstall and check the ODBC.
  3. jtd353

    Unusual Problem Trying to Link Tables

    Using Crystal 9 and a SQL database. There's no problem using one table and returning data from that table. However, when you add another table in the Database Expert and click the Link tab Crystal Reports closes. I've never seen this happen before and am puzzled as to why it's happening. Thanks
  4. jtd353

    Change Tme Format to Text

    Thank you all for your suggestions. It now works! The file I'm using is exported from an application and was created by the vendor who formatted the cells as time rather than a number. By inserting a new column and using =TEXT(A1,"[hh]:mm:ss") I was able to get the results I need. I'm using...
  5. jtd353

    Change Tme Format to Text

    The values in the cell are formatted as time and using a custom format doesn't produce the desired result. For example, the value of 43:36:38 in reality is 43 hours 36 minutes and 38 seconds but is formatted to display as 7:36:38 PM. Using =Text(L2,"hh:mm:ss") displays 43:36:38 but that still...
  6. jtd353

    Not Implemented Error Logging onto the APS

    Using CR & CE version 9. We installed the patch to allow users with more than 100 Active Directory groups to login to ePortfolio using Windows NT Authentication. It corrected that problem, however when attempting to logon to the APS through Crystal Reports using NT Authentication to publish or...
  7. jtd353

    ODBC Connection - Mixed Mode Authentication

    We are using Business Objects XI would like to set up an ODBC connection on the Enterprise Server with the following scenario: We have a mixed environment where we have SQL servers operating in mixed-mode authentication and native-mode authentication. Ideally we would like to take advantage of...
  8. jtd353

    Add "continued" to a repeated group header on a report

    Remou: Thanks! This is exactly what I was looking for.
  9. jtd353

    Add "continued" to a repeated group header on a report

    Is there anyway to add the word "continued" to a group header label when it breaks across multiple pages? For example the header on page one would be "Group 12345" and on page two I'd like it to be "Group 12345 - continued". Setting the header to keep together won't work on this report because...
  10. jtd353

    Calculate Start and End Time if outside of business hours.

    I'm using Ken Hanady's formula to calculate business hours and it gives me the correct results if a ticket has been opened and closed during business hours of 8:00 - 16:00. I've got tickets that are opened and closed outside of these hours and get a negative number. His business hours formula...
  11. jtd353

    Reset Running Total on a New Group

    I'm using Access 2000 and have a report that has three groups, Program Type, Location, Program Name. I've got it doing a running total of the number of programs by location, but need it to reset the running total on each location group in order to get an accurate count of how many programs were...
  12. jtd353

    clean export to excel

    Check this out, it may offer some more help for you. http://support.businessobjects.com/communityCS/TechnicalPapers/scr_exportexcel.pdf.asp
  13. jtd353

    clean export to excel

    You can try this: Select: File, Print, Export. Export as Excel 8.0 Extended. On the Format Options Popup, check the Tabular Format radio button. It worked for me. Good Luck

Part and Inventory Search

Back
Top