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

    Address Book Troubles

    Hello guys/gals, I been having a difficult time trying to get my MS Word, specifically the Envelopes and Labels section, to obtain contacts from my address list. There doesnt seem to be an import Contacts function, nor can I find a way to get to any of my contacts through Word (let alone insert...
  2. TheMagikWand

    Refreshing for Mon-Fri

    hey guys/gals, i am currently working on a report(ver.8.5) for my company and am having some problems getting the right data to show up. my problem is this: the report i have,is supposed togenerate data for all of the "charges" our company has made over the previous week. however i dont know how...
  3. TheMagikWand

    Form Report Null Values

    Hey Guys/Gals, I have created a crystal reports v8.5 form letter that displays a patients name, insurance info and a small blub about the procedure theyre having. it looks like this: [MediCare] [100 W. 30th Street] [New York], [NY] [10001] [Ms.] [Susan James], [Info of the procedure, blah blah...
  4. TheMagikWand

    Converting Data to Excel

    hey guys/gals im was wondering if there was a way to get my report/data and convert it into a MS excel file. I know that its quite easy to create a spreadsheet and import it INTO crystal, but i was the opposite, i want it from crystal, to excel. Id like it to be an excel file because my boss...
  5. TheMagikWand

    deleting individual entrys

    yes, yes, i know this sounds ridiculous, especially since ive been using crsytal for over a year now, but.. i have no idea how to remove and individual entry from the report screen, can anyone help me out???? exe. we have a list of clients and their spendings for a given day, however one...
  6. TheMagikWand

    Spy Ware

    hey guys/gals, i just found out i had the RoyalSearch.com Trjoan, and tried using norton to remove it, but that just didnt work, i d/led hijackthis, and have a saved log of files, but im not sure which ones to fix or not, can anyone help me out?? Heres the log:Logfile of HijackThis v1.97.7...
  7. TheMagikWand

    Report Design Q

    hey guys/gals, im trying to create a large report that will hold assorted info on various clients we have(approx.15,000). i have 35 separate fields, some of which need to be included, some of which would just look nicer if they were included. i want to somehow make a file that has a main...
  8. TheMagikWand

    More Date Problems

    hey guys/gals, im working on CR v8.5 and came across this "date" problem. In my database dates are stored as a # field such that... 60,203.00 corresponds w/ 6/02/03. i have a report to do today and i need to get my dates to look like the latter, but i cannot use the numbertodate(x)...
  9. TheMagikWand

    hey guys/gals, im not sure if th

    hey guys/gals, im not sure if this is at all possible, but ill ask anyways. i have a report that recieves data from a database that is updated every morning at 7:30am, is there any way i can: a. have my data automatically refresh w/o having to hit the refresh button, and b.the most important...
  10. TheMagikWand

    Printing problems, yes, printing problems

    hey guys/gals, ok, im kinda new and even i think this question should have an insanely easy answer but i cant seem to figure it out. i have a large report with about 25-30 different sections in my primary group. how can i choose to print each section on its own separate page w/o having to drill...
  11. TheMagikWand

    Extracting MM from CCYYMMDD format

    hey guys/gals, i have a number field that contains entry dates for specific procedures, it is listed in CCYYMMDD format (so i can use the numbertodate(x) function). what is need to know is how do i isolate just the month part of the field, so that i can group the entrys by month they were...
  12. TheMagikWand

    Adding Font Color w/ Formulas

    hey guys/gals i have a report that needs to be a little more visually appealing so ive decided to add some colors here and there, but i ran into one problem that i cant solve. i have an "if-then-else" formula that takes account balances and sorts them into 3 categories, paid...
  13. TheMagikWand

    Grouping by Month/Week

    This may seem like the easiest question around, but i have no way of solving it myself to here it goes: I have a report that i wish to sort by week, but in my database, i only have specific days for specific events (exe. 50 orders for sept 2, '03 and 25 for sept 5, '03) my date is listed in the...
  14. TheMagikWand

    How to make CR recognize "0" in dates

    hey guys, im still new so this may seem easy but... i have a database that lists dates in 6-digit YYMMDD format (031214 = Dec. 14th 03 etc.) but everytime i use a year from later that 1999 i get a single digit year instead of a 2 digit year exe: 031214 = 12/14/3 can anyone help me add a zero...
  15. TheMagikWand

    Problems w/ Utldate.dll

    hey guys/gals, i installed the "numbertodate dll" from the crystal website and when i went to create a formula to turn my 8-digit date (exe. 19990105 to Jan 5, 1999) it told me a needed to insert a number. heres my formula (it really doesnt get any easier): numbertodate({xxx.date})...
  16. TheMagikWand

    Numeric Date to Actual Date

    hey guys/gals, im kinda new at this so this may seem like an easy Q but ive got no where else to turn. i have a field of dates listed in 6 digit number codes: May 1st 2003 is listed as 050103 i would like them to show up on the report as the written form (May 1st 2003) any ideas?????? thanx

Part and Inventory Search

Back
Top