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: ddrake
  • Content: Threads
  • Order by date
  1. ddrake

    .NET Date Picker Code question

    Can anyone help me figure this out. I have date picker code that works famously inside a regular Web Form, but when I place it inside the FormView Tags inside the EditItemTemplate, when clicking the calendar by the textbox it will not pop up. Any Idea why the code below works great in a...
  2. ddrake

    Date conversion

    Hi all, Working in SQL 2K and I've got a column that stores values in a datetime format and look like this: 2006-05-11 11:11:11. I need to convert them or something so that only the date is shown and the time part is just 0s (00:00:00). Is there anyway to do that in SQL? Thanks!!
  3. ddrake

    Converting hexadecimal dates and times

    Hi all, I've got two fields in a database that I'm trying to report off of that have their data formatted as a numeric representation of a hexadecimal number. We'll call field 1 'DATE' and field 2 'TIME'. The date format is set to a varchar datatype that contains a numeric expression like this...
  4. ddrake

    Can't connect to a SQL 2K instance

    I just recently created an instance on my SQL 2K db box to accomodate our webmaster who needs his data to be separate from the default instance. Now he cannot connect to that instance. We're using dreamweaver btw. In the connection documents, for the server name, used to have it as remedydev...
  5. ddrake

    Dual-Layer DVD issues

    Hi there, My company just recently bought a bunch of the Dell GX280 desktops and they come installed with the HL-DT-ST DVD-ROM GDR8082N DVD drives. These are apparently having issues with reading DVDs burned on dual-layer media. I remember reading something on Dell's website about having to...
  6. ddrake

    Formatting time calculations

    Hi all! I've got a couple of date/time fields in my report that I subtract one from the other. What I get is in seconds. I then convert the seconds to hours and report that value. Of course, it is shown like 204.5 hours. However, we'd like to convert/format that data to show in HH:MM:SS like...
  7. ddrake

    Active Directory connection with Crystal 9.0

    Good morning all, I'm pretty sure this has been discussed thoroughly many times, just need a pointer if you would be so kind. I have Crystal 9 and I'm trying to connect to our Active Directory (Win2K network). Can anybody please point me in a good direction? Thanks!
  8. ddrake

    Chart Tabs error

    Hello all! Got an odd one that I'm hoping someone else may've seen before. I've got a CR 9 user that is having difficulty selecting the different tabs when she tries to update chart parameters. She clicks on the different tabs but they won't come up. We're running CR9, connecting to SQL2K...
  9. ddrake

    Yesterday data selection - only if business day

    Hi all, I know I've seen this topic in here before, just can't locate the post. I've got a report that chooses a variety of data with a 'Create Date' of yesterday. Of course, this works great Tuesday through Friday! What I need though is something that will select on if yesterday was a...
  10. ddrake

    Renaming a Windows 2000 machine remotely

    Need to see if anyone knows of a way I might be able to rename Windows 2000 machines remotely. They are all in a single domain. Thanks!
  11. ddrake

    Question on embedded reports

    Greetings fellow listers: I have some Crystal Reports saved to the Report form. I can run one of them, but the others all generate an ARERR 1658 error and tell me that the report cannot be opened. We are using ARS 5.1.2, SQL2K, Win2K Server, Crystal 9.0, User Tool is 5.01.02 (Patch 1303) Any...
  12. ddrake

    Pulling specific text out of a long text field

    Hi there, Running CR9, SQL2K, ARS 5.1.2 and I've got a puzzler. I have a field that I need to pull lines of text from. This is a sample of part of this field's value: 8/14/2003 5:12:27 PM ddrake Asset categorization information has changed from 'Monitor, Compaq Computer and S920' to...
  13. ddrake

    Time formatting

    Hi all, I've got a report that calculates a bunch of time entries in just a standard numerical format (ex. 200 hours). What I need to do is format this number in a format like Excel (00:00:00 (so for the above example, it would look like this (200:00:00) (hh:mm:ss)). Is there a way to do this...
  14. ddrake

    Top N summary

    Hi, I've got a report that displays the Top 10 of a particular grouping. For example, of a dataset of 100 entries all with different categories, I've grouped by that category field and I'm displaying only the top 10 results based on summaries of each category: 1. Category 1 - 10 records 2...
  15. ddrake

    Creating groups for a Crystal Report

    Hi all, Got a question on creating a particular group. Looking at two fields (IncidentID and CaseID) I need to create groupings of records where Incident ID = "Original" and include all the other records where their Case ID matches the original's Incident ID. I'll have several Original with...
  16. ddrake

    Creating a group

    Hi all, Got a question on creating a particular group. Looking at two fields (IncidentID and CaseID) I need to create groupings of records where Incident ID = "Original" and include all the other records where their Case ID matches the original's Incident ID. I'll have several Original with...
  17. ddrake

    Excluding weekend time

    Hello, I've got two Date/Time fields that I need to subtract one from the other to return a difference between them. Since they're both DT I can do that readily enough, but I'd like to exclude any weekend time in that calculation. Any hints at all would be appreciated. Thank you! Crystal...
  18. ddrake

    INETCPL.cpl error

    Hello all, I have a user who, when attempting to access Internet Explorer option, gets the following error: An error occurred while Windows was working with the Control Panel file C:\WINNT\system32\INETCPL.CPL. I've replaced the file itself from another system and re-installed IE without any...
  19. ddrake

    File Size Determination Reports

    Anybody out there hear of or have done up a report that will return the size of the data on another machine's harddrive if given a computername? Or maybe something similar? Using Crystal 9 and hitting a SQL2K db. Thanks!
  20. ddrake

    Convert nsf to something else

    Hello, Working on an R5 platform and I have a particular database that I need to convert to something else (Excel, csv, access, etc). I'm trying to pull this data into another application and just need the "go-between" tool. Has anyone seen an application or process which might help? Thanks...

Part and Inventory Search

Back
Top