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!

Register Log in
  • Congratulations Rhinorhino 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: metalteck
  • Content: Threads
  • Order by date
  1. metalteck

    Sum Question

    I currently have a report that shows account activity. In this report, the primary fields are being pulled from one table. There is one field called lpchgs, and this is the total charge for an account. Ex. Account Total Charges 444444 $152.00 I created a report to show an accounts...
  2. metalteck

    Time Format Question

    I am currently using Crystal 10 and added a field that represents time. Only problem is that its formatted as a number field instead of a time field. How can I convert this over. Now Want to have Ex. 608 6:38:00 AM 1334 1:34:00 PM 1218 2:34:00 PM 2241 10:41:00 PM Thank you
  3. metalteck

    Import Excel Spreadsheet Data

    I currently have a crystal report that returns account numbers and shipping information I need. I also have a spreadsheet that contains a list of account numbers. I need to take all of the account #s in the spreadsheet and put it into the crystal report, so that I can get all of the necessary...
  4. metalteck

    Formula Question

    I currently have a database that calculates the Beg and End Date for the time it took an order to be ordered. I'm using Crystal 8.5. I'm trying to find out how long it took for the order to be taken, but am having a hard time doing it. Can someone please help me. Thank you The formula for the...
  5. metalteck

    Duplicate Help

    I'm currently have a report that lists all patients from 2 different units, units #7 and #11. The patients can have appointments in one of these units or in both. Right now when I generate the report, I get all patients, whether they only have one appointment or 2. I want to be able to only get...
  6. metalteck

    Question?

    I am currently using crystal 8.5. I have no problem with the data that the field gives me. Ex. QTY 5 5 6 7 7 7 What I'm trying to figure out is how I can eliminate the values that only appear once. I was trying to create an if statment, but don't know how to word it...
  7. metalteck

    Time Division Question

    I currently have a spreadsheet that is supposed to do some projected time calculations. In cell a1 I have the number of calls, 8. In b1, the average length of a call, 0:3:25. I multiply both of these cells and get the answer in c1,0:27:20. I have formatted all the time fields to be in the...
  8. metalteck

    If Statement

    Crystal 8.5 I have 2 formulas that will tell me the difference of days between them. date({@Discharge Date}-{@ADM}) ADM DD Stay 7/25/06 7/26/06 02 1/13/06 30 I changed the format options to a custom, so that it would only show me the number of days.When I display...
  9. metalteck

    Date Comparison

    In my 8.5 version of crystal, I'm trying to compare 2 dates. In the database, the fields tran and svc date are stored as date1,date2,date3. Date1 = month, date2 = day, date3 = year. My formula is this: If transdate > svcdate then "after" else "before" My problem is that it requires me to put...
  10. metalteck

    Math Question

    I'm trying to create a calculated field, to get a percent and then query by the result of the percent. In Crystal 8.5, I wrote this for my formula: (lpadj/lpchgs)*100 I put this field in my report and then run it. I then use the select expert to query anything less than 5%, but it always...
  11. metalteck

    Automating Crystal Reports

    I have Crystal Reports 8.5 and I was wondering if there was a way that I can automatically set up Crystal to run a report at 12:00 am, every month. I can use microsoft task manager, but all that does is start the program, not actually run it. Thank you
  12. metalteck

    Subreport Question

    I am using crysal 8.5. I have my main report that breaks down the productivity of a class by groups, 0-30, 31-60, etc. Ex. Class 0-30 31-60 61-90 A 1.00 25.00 100.00 I have another report that breaks down the class based on budgets. Ex. Class Budget A...
  13. metalteck

    Multiple Reports

    I have 3 reports that I do, and I would like to be able to put all of the reports into one summary. The first report calculates all unbilled charges greater than 0. The second report calculates all of the current balances less than 0 and the last one calcuates all total charges greater than 0...
  14. metalteck

    Query Question

    I have a database and a spreadsheet. The spreadsheet contains a customer list. I need to make a report with other data. This data comes from the database. I have imported the spreadsheet into the database as a table. I link the first and last name to eachother and run the new query. I get...
  15. metalteck

    Process Question

    In MS Access, I know that one would be able to create a query, and if needed to, could run another query based on the first query. I was wondering, I have a report that pulls my data. Is there a way I could either make crystal run another query based on the first report and another table, etc...
  16. metalteck

    Query Question

    In MS Access, I know that one would be able to create a query, and if needed to, could run another query based on the first query. I was wondering, I have a report that pulls my data. Is there a way I could either make crystal run another query based on the first report and another table, etc?
  17. metalteck

    Date Conversion

    What I want to do is convert a number to a date value. Current examples of the numbers are: 11506,12906,20306,21006,122805. I select this field and put it in the report. I create a formula field using the datevalue function, and then attempt to format it. I'm trying to get this value to be...
  18. metalteck

    Help

    I'm trying to write a report in crystal, but I'm having the hardest time trying to figure out how to get the data sorted the way I want it. I have a customer list: Name Type Dollar Bob B 100 Chris C 1000 Gus F 2 Rudy U 5000 What I basically need to do is First...

Part and Inventory Search

Back
Top