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

    about:blank and out of control spyware

    I have been using many of the previous threads to work on my problem over the last week. I have run spybot S&D, cwshredder, microtrends, and ad aware se. Each program finds and removes tons of spyware, but when I re-boot, still can't get rid of about:blank and sexygirls plugins. I'm using...
  2. sgd3476

    PC Crashes after 20minues of use

    When kids use any program or game, Dora, sesame st, I Spy, etc. after 20 minues using game, pc crashes. This happens every time, same time. Could this be virus? Using Windows XP home, Pc has norton antivirus-personal firewall. Thanks, Katie
  3. sgd3476

    Date Formula

    I have created a report that shows orders submitted by traders. I would like it to show only previous day's orders. I have many dates in the table to select from, I just don't know how to select previousday. Thanks for any help. Katie
  4. sgd3476

    Word documents to pdf

    How can I convert a word document into a PDF? Thanks, Julia
  5. sgd3476

    Percent of TOPN

    I am so close to finishing my report but I'm totally stuck. Here's what I've got. ASSETClass Security MV % of Port Equity Exxon 400,000 .40 Equity EMC 100,000 .10 Equity NOK 125,000 .12 Equity...
  6. sgd3476

    TOPN Report

    I have created a report called top 5 equity market values Class Security market value %0f Portfolio Bond ustbond 100,000 40%--This should not appear Equity ibm 31,000 10% Equity Staples 125,000 25% Equity Cysco 10,000...
  7. sgd3476

    Delimiting file through DTS

    I've created a DTS package to export a query from SQL. I need to have the file comma or pipe delimited. The file is too large to manually delimit. Thanks for any help. Steve
  8. sgd3476

    Delimiting a sql query

    I need to send data to client in Pipe or comma delimited format. File is too large to open in Excel or wordpad. How can I insert pipes or commas into my query? Thanks, Steve
  9. sgd3476

    OFAC List

    I need to match our company's client list against the U.S. Government's suspected terrorist list. I'm having trouble with the "Search" and "Find" functions. Any help would be appreciated.
  10. sgd3476

    show all previous dates

    Hello, I'm new to crystal 8.5 and I'm trying to write a report that would show previous month end market values. I have a start and end date parameter in my report, but I'm not sure how to get all of the dates to show. I have figured out how to put in the start and end date market values, but...
  11. sgd3476

    Printing multiple historical dates

    I would like to show previous monthly market value balances. My report calls for an "As of" date. I would like to show all month end market values for a year prior to my "As Of" date. Is there a date formula that can do this? My database only keeps data for business days...
  12. sgd3476

    Replace field number with literal value

    In my report I have a client account number, but am unable to pull in the name from the db. How can I replace the client number with name?
  13. sgd3476

    Top 5

    These seems obvious, but I can't get it to work. I have a simple report. A client has a list of stocks, I'm showing the issue name, market value and tax cost, subtotalled at the end. I just want to display the top 5 assets by market value. Thanks, Kelly
  14. sgd3476

    Percent of Summary Field

    I would like to show a percent field for the percent of equity portion of an account divided by the the sum of an accounts total market value. The equity field is a formula and the total market value is a sum of the tmv. I am unable to get this to work. Any help would be appreciated. Thanks...
  15. sgd3476

    Creating new field not in database

    I have a report that contains a group. Asset Class, so we've got, common stock, bonds, cash. I need to create a column that shows subtotal of all(I've done), new fields would be subtotal of the asset class common stock, subtotal of bonds and subtotal of cash for a list of accounts. Any help...

Part and Inventory Search

Back
Top