Search results for query: *

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

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!!

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

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

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

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

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!

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

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

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!

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

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

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

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

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

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

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

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

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!

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