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: *

  • Users: BigC72
  • Content: Threads
  • Order by date
  1. BigC72

    Check all files using For each but trigger action only once

    I have a script that is looking at a directory and if files are present it's looking at the file extension and then age (in minutes) of the file(s) and if the file or files are beyond that age it triggers another set of actions... What I'm not certain of is how to get the script to trigger the...
  2. BigC72

    Script works on XP machine but not on Win7 Pro

    I have the following script that has been in place and working for sometime now on literally hundreds of our XP Pro machines: CONST SHOW_ACTIVE_APP = 1 Set shell = createobject("Wscript.Shell") Dim X Dim Y Dim strArgValue Dim tabValue strComputer = "." Set objWMIService =...
  3. BigC72

    Polling list of AD computers for pc info

    I've got a fairly simple script that utilizes a list of pc's exported directly out of AD. The list will contain pc's that are either not turned on or may be gone all together. I've got the script doing what we need IF I provide it with a list of pc's that I know are all "there" and powered...
  4. BigC72

    MSSQL script issue...

    I'm working on a script that will allow members of our help desk to clear "hung" user sessions in one of our systems. This is normally something I do directly in the systems database and is relatively straightforward. However I'd prefer not to have all the help desk staff digging around in the...
  5. BigC72

    Append log file when exists otherwise create one

    I have a script that performs a number of different functions for me including creating a simple log file that indicates what has been done...I would like to adapt this script so that rather than running a slightly modified version that creates a different log file the original will identify...
  6. BigC72

    Trouble with passing command line argument

    I'm having issues passing a command line argument into a VB script that I'm working on. The Echo shows me that the syntax is correct but where I'm trying to utilize it in the script doesn't appear to like it...Here is the code: Set imagenowAPI = GetObject( , "imagenow6.CtrlPanel") Set objArgs...
  7. BigC72

    mySQL Export specific table(s) to import elsewhere

    More than relatively new to mySQL....Trying to facilitate a table export on a number of tables in one DB so that they can be imported into another DB. The command line command I've been using looks like this: mysqldump -u root -pbigcountry dbname table_name > table_name.sql It doesn't seem to...
  8. BigC72

    Grouping order question

    I am using CR XI to query a DB2 database and have a rather extensive report that is utilized by different personnel within the company who's needs vary depending on what they do....I have built reports that allow the end user to specify the primary or first level grouping on a report but is...
  9. BigC72

    TopN as a parameter

    I am using CR XI sp1 querying a DB2 database. I have reports in which I group by procedure code and total for each occurence/use of the procedure code and then apply a TopN for lets say the top 50 or 100 codes used by a physician. Is there a way that I can create a parameter by which an end user...
  10. BigC72

    Display multiple parameters inputs

    I am working with CR XI and a DB2 database. I have created a parameter based on a field called batch number. The field is a number field and these batch numbers can any combination of numbers. I would like to display the inputed values in the report header field but a join formula only works...
  11. BigC72

    How to find only duplicated values

    I am using CR 11 to access data from a DB2 database. I have only one table in my report which displays various patient information. Each patient the see's a physician at our facility should have a unique chart number but in some cases that doesn't happen so we have different patients that end up...
  12. BigC72

    I think I need to use variables?

    I am using CR XI to query a DB2 database. Currently I have two tables pulled into the report. 1) DR_PROD_HISTORY 2) SERVICE_CODE These tables are linked via inner join between these three fields 1) ORG_CODE 2)PROCEDURE_CODE and 3)PROCEDURE_MOD. I have three groups set up currently in the...
  13. BigC72

    Crosstab question

    I am using CR 11 to query a DB2 database. I have inserted a crosstab that is grouping all charges posted for our physicians and displaying them as a total for that particular date and also totalling down the column (date) to give me a daily total and accross the row (physician) to give me a...
  14. BigC72

    Question on running total of subreport data in main report

    Hello, I am using CR 8.5 and querying a DB2 database via ODBC connection. I work for a medical clinic and the manner in which we bill for our services sometimes involves several components known as Global, Technical and Professional. My supervisor has asked to see a particular physicians...
  15. BigC72

    Suppress Page Header

    I am utilizing CR 8.5 and hooking a DB2 database via ODBC connection. I have several reports that I hide the details and only display group information so that the report does not get to unwieldy. In such cases I would like to additionally hide anything in the page header so that it only...
  16. BigC72

    Creating custom AR groups with formula

    Hello, I am using CR 8.5 and hooking a DB2 database via ODBC connection. I am trying to create some custom groups by using a formula to create them. The groups I am trying to create are patients that fall into the different categories of accounts receivable such as < 30 days, 30-60 days, 60-90...
  17. BigC72

    Head to Head V10 vs V11

    I finally have convince the powers that be here at my company to upgrade our CR software from 8.5 and I am interested in hearing thoughts from everyone on which is the better direction to go Version 10 or Version 11? I know most would say go with the newest but like a new car that's on the...
  18. BigC72

    Sort Custom group names

    I am working with CR 8.5 and hooking a DB2 database. I have created custom group names that encompass various medical procedure codes. The formula to create the groups works great but I'd like to be able to sort these custom groups alphabetically. Would I do it within the same formula or in...
  19. BigC72

    Display number field as other dollar amount or percentage.

    I am using CR 8.5. Data comes from a DB2 database. Data is a number field that contains our patients Insurance Co-Pay amount which can be one of three things either 0.00 for patients with no co-pay amount, $25.00 for patients with a particular co-pay amount or .20 for patients whose co-pay is a...
  20. BigC72

    Using Wildcard to query large string

    We are currently exporting the Windows event logs from several of our Win2K servers to a SQL table and I would like to be able to query the description field (which has been converted to a string field in SQL) to look for certain elements here is an example: Document 95 Microsoft Word -...

Part and Inventory Search

Back
Top