Search results for query: *

Any help is greatly appreciated. I currently have my home phone service through my cable company for $44 a month, which seems like a lot, because we hardly ever use this phone. My wife and I use our cell phones mostly, but don't want to give up the home phone line completely. So I was...

Any help is greatly appreciated. I have a corporate Cisco ASA firewall, with the VPN access turned on. On my laptop, I have the Cisco VPN client, and I can log into my ASA with a username/password. I purchased a Cisco RVL200 vpn appliance, and I was looking to pre-configure it so that it...

Any help is greatly appreciated. I have a corporate Cisco ASA firewall, with the VPN access turned on. On my laptop, I have the Cisco VPN client, and I can log into my ASA with a username/password. I purchased a Cisco RVL200 vpn appliance, and I was looking to pre-configure it so that it...

I have a townhouse, with say 8-10 jacks throughout the house. In the basement, all the phone wires come together and are basically all twisted together and capped with an electrical cap. I was running a new jack and wanted to clean this up a bit, either punch down all the wires, or crimp on...

Please excuse the newbie question, I'm very new to AWK. I have a large directory of HTML files, and I would like to search through these files for keywords, and take the results of the search and put it into a sql server database. Is this possible, and if so, are there any samples out there...

Using CR11 and SQL Server, I have a table of claim numbers, userID's, date, and hours worked per day. So, for example, my data looks like this: DATE USER CLAIM# HOURS 11/11/2008 joe 12345 8.5 11/11/2008 joe 54321 8.5 11/11/2008 joe 09987 8.5 11/11/2008...

Any help is appreciated. I have 2 spread sheets, one is employee productivity, one is employee quality. They both have a userID field. I would like to combine these into 1 sheet so that I can create pivot tables, etc. Is there a way or a function to take sheet1 and sheet2 and merge them into...

Not sure how to do this, any help is greatly appreciated. I've got 2 separate db's. The first contains employee productivity: userID, claim_num, reviewed_date, etc. The 2nd db contains the employee quality: userID, audited_date, number of errors, etc. I'm having a hard time trying to get...

using CR11 and SQL2000, I have a report called "productivity" which lists people's productivity, grouped by username, then by date (week). This works great. Now I'm trying to add in a sub-report called "quality" where I take the shared values from the subreport, an put them on the main report...

I cannot seem to get this correct: Using CR11, I have a string which is military time, formatted as HHMMSS: 135819 How can I convert this to a time, then convert it from military time to 12hour time? I've tried the Ctime function, and the Istime func, but it doesn't work. The IsTime func...

Using CR11 & Sql2k5, I have a report with a sub-report, all on one row of my report. This looks great in Crystal, but when I export the report to excel-data only (which is mostly what the report is used for) the sub-report comes out on a separate row. Is there a way to keep the sub-report on...

Using CR11 and SQL2000, I have a table of employee productivity, grouped by username: claimID(number) Type(char) Completed(DateTime) Now we have another table called "checkin-checkout" which is big table of every time a claimID was "checked out" to someone or "checked in" by someone. So...

Any help is greatly appreciated. I have a table with some fields: IsExpedited(boolean), ErrorCode22(number) When I put them in the details section, they look like this: IsExpedited ErrorCode22 TRUE 1 TRUE 1 TRUE 0 Then in my footer, I have a...

Any help is appreciated, I'm using CR11 and SQLserver 2000. I have 2 different tables of simliar data: Table1 is a list of webtrends hits: date, visits And there's only 1 row for each day. Table2 has 2 fields, Date, and title, but there can be multiple rows for each day. What's the best...

CR11, SQL2000 I have a table of data with a date field and a user name, and claim numbers, etc. So I'm grouping first on username, then on date (weekly). Then I have a summary which is a count of claim numbers per week in the weekly grouping. Now I'm trying to figure out how to do a weekly...

I have some SQL data that lists users and their error rates. Using the PthPercentile function, I can get the 10th percentile. In the report header, I'm trying to just list the people who fall into this percentile, before the detail sections. Is there a way to do this with a formula? Create a...

Hello, I inherited a SQL query (SQL 2005, CR11) where the SQL is in a Crystal command object. There are 2 declared parameters in the SQL: @date1 & @date2 for the date parameter in the where clause. When I add the SQL to the command window, I can enter parameters, but it doesn't seem to store...

Using CR11 and sql, I have a table with a 1-many relationship, and I'm trying to do a calculation on 2 fields. My data looks like this: Claim Num Error ID Resolution ID Formula 6093960 22 ? 6093960 24 5 2.00 6093960 25...

using CR11 and sql server, I'm trying to set the date range of my report to be the current quarter to date, but the quarters of my company aren't the standard fiscal quarters (01-03). What's the best way to handle this? I can create a new table to store the quarters for the company, and then...

using CR11 & SQL2000: I have a formula that counts errors in the db in a particular way: whileprintingrecords; numbervar A; numbervar B; // Audit error count for multiple errors if {AuditTicketEntry.AuditErrorId} = [22] then A := Count...