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 John Tel 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: DannyBill
  • Content: Threads
  • Order by date
  1. DannyBill

    Remove " " marks from a text string

    I have a field that currently has data "123456", I'm trying to figure out how to remove the " " marks so that it's 123456. Any help would be greatly appreciated Thanks in advance.....
  2. DannyBill

    Cross Tab Column formula

    I'm using CR 9 with an SQL database. In one of the database fields we have multiple "codes" entered representing issues that need corrected ex... 001, 002, 003, 004 and so forth for various locations on each map of our network. I'm trying to set up the cross tab using the codes as rows and...
  3. DannyBill

    Excel Auto Import

    Does anyone know how to get excel to automatically import a text file. I've set the refresh option in the external data properties, but when it refreshes, I'm required to click on the import button. I want it to do this automatically. Thanks in advance for any help. Dan
  4. DannyBill

    Grouping by dates

    Using CR9 I'm using {EndDate} as a field to group by, and a parameter field to select the date range for record selection. Currently the report is displaying the first day in the week (Sunday), how do you get the report to display the date for that following friday thus being the last work day...
  5. DannyBill

    Count working days within date range parameter

    I'm using a date range parameter {?DateRange} on my report and trying to figure out how to count the number of working days within that parameter. If anyone could help, that would be great. Please include an example. Thanks in advance for any insight you may be able to provide. Dan
  6. DannyBill

    Worked hours within specified date range

    I'm working on a report where I need to find the numbers of hours worked within a specified date range. This report will be used year after year so I'm wanting to declare start and end dates, then create formulas based off those to specify date range. I've created a formula called Start date for...

Part and Inventory Search

Back
Top