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

    Excel - Nested If work around

    Hi, I was trying to do this with nested if's but realize that there has to be a better way. I have a worksheet set up like this: Jan-04 Feb-04 Mar-04 Apr-04 etc. Charges: 10,000 9,500 9,800 11,000 Payments: Jan 04 2,000 0 0 0 Feb 04 5,000 3,000 0...
  2. toddl

    SubQuery Question - two variables

    Hi, I'm wondering if this is possible. I have three Tables. tblTransactions Patient Procedure Procedure Date Provider XYZ 99 5/1/2003 1 XYZ 99 5/1/2004 1 XYZ 99 5/1/2005 1 tblProcedures Procedure Code Amount Start Date End Date 99 75 1/1/2003 12/31/2003 99...
  3. toddl

    Impromptu Format A*

    My data is coming through as all capital letters. I'm trying to use the format Aa* so that it comes through without all caps. However, when I try using the format, it blanks out the data so there is nothing there. I am using Impromptu 7.1 User edition. I originally had this report in...
  4. toddl

    Form - Multiple Records Questions

    I am trying to create a database that will allow a user to select a person, and from there be able to enter in there bills for the month. For example, a person comes in and submits there gas, food, and utility bill. The user will then select the persons name and then enter in the description...
  5. toddl

    MAS 90 Invoice Report

    Hi, I am looking for a way to see productivity of our A/P department to compare the count of invoices by fiscal years. However, they want to make sure that I include where the invoice is spread across different accounts/departments/locations, so one invoice could count as 5 and so on. Has...
  6. toddl

    Powerplay Alternate Drilldown

    Hi, I'm trying to figure out how to use powerplays alternate drill-down path to include a fiscal year and calendar year in the same cube. Has anyone done this before? Also, what other ways have people dealt with a fiscal and calendar year in the same cube? Thanks for your help, Todd
  7. toddl

    Excel Time Line

    Hi, I am trying to create a time line in excel with hire dates of people. On the Chart, I would also like the persons name to show up next to where there hire date is. Is this possible in excel? I want it to look similar to this SMITH 7/1/04 ROGERS 8/15/04...
  8. toddl

    Impromptu Sub-Reports

    Hi, I have a question on impromptu sub-reports. I have a total in a sub-report that I would like to add to a total in another sub-report and a few values on the main report to come up with a grand total. Is cognos capable of doing this, or is there a way to work around it? Todd

Part and Inventory Search

Back
Top