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 Mike Lewis 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. ericb123

    best home VoIP solutions?

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

    RVL200 to ASA connectivity help

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

    RVL200 vpn to ASA firewall

    the thought was to have a "device" that a dept. can share and just take home and plug into, and it would be "always on". Also, some of the people would be using it just for phone support. We have Cisco IP phones, so I was hoping I could configure it so that someone can just take their IP phone...
  4. ericb123

    RVL200 vpn to ASA firewall

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

    telephone wiring

    Hmmm, I don't have a 66 block I can use afterall. Some of the products I see are a little pricy. The phone jacks all work, so I don't see spending alot on it, I was just looking for a way to neaten up the wiring from a big ball where everything is twisted together, into something a little...
  6. ericb123

    telephone wiring

    thanks for the replies! I may have a 66 block laying around, and I have a punch down tool. Can I do it with that? I just don't know howto wire it, so that the 1 incoming line with the dial tone gets distributed to the other patches. Thanks again!
  7. ericb123

    telephone wiring

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

    awk and SQL server?

    Thanks for the reply. Someone had recommended AWK, but admittedly, I'm a complete novice to it. I have a SQL database with a table that lists keywords I want to search for. Then I have a directory structure on my server that has HTML files: Folder/subfolder/HTML files So I'm trying to find...
  9. ericb123

    awk and SQL server?

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

    please help with hour calculations

    nevermind, I figured it out. Thanks again!
  11. ericb123

    please help with hour calculations

    thanks! That works great. Is there a way to get this out of the footer and in the header? All the other fields are in the header, and when I move it there, it changes to an incorrect number. Thanks!
  12. ericb123

    please help with hour calculations

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

    merce excel rows based on an ID column?

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

    help with best way to sync distinct data from 2 separate tables

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

    how to group sub report by week?

    thanks for the replies, I only used 9/1 instead of 8/31 as an example, the real data/dates were 8/31 There is a date selection in the subreport, but it's not the same date as the main report. The main report is called "productivity" and the date range is set for {productivity.date} The...
  16. ericb123

    how to group sub report by week?

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

    export to excel all on the same row

    Thanks again, this works great in Crystal, the report displays correctly. However, when exporting to excel, it puts an empty row between each record, I'm assuming this is for the section with the suppressed subreport. Is there a way to suppress this blank row? I have a lot of data and the...
  18. ericb123

    export to excel all on the same row

    Awesome! Thanks so much everyone!!
  19. ericb123

    export to excel all on the same row

    Hmm, thanks. I tried reading the variables from the sub report, and I've got it working correctly. However, the subreport is in the section above where I want my variables, which is giving me the correct values, but when I try to "Hide" the section with the subreport, it won't pass the...
  20. ericb123

    export to excel all on the same row

    thanks lbass, but how do I attach the report to guidelines? I've got the guidelines around the subreport, but I don't think they're attached to them. Thanks!

Part and Inventory Search

Back
Top