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

  1. JRandallC

    First and last in a group?

    Cool. Thanks. I looked all through the functions, but forget about those summary functions sometimes. Randall
  2. JRandallC

    First and last in a group?

    In a report (Impromptu Series 7), I have a list of accounts with transactions on that account. I need to create a custom calculation that will return me the date of the first transaction for that account (earliest date) and another calculation that will return me the date of the last transaction...
  3. JRandallC

    Combining two reports

    Is there a way to combine the data in two reports into one? In this case, both reports have field names that are identical, but each report comes from a different source. I want to combine the two into a third report as if they had come from the same source. Thanks for any help. Randall
  4. JRandallC

    Filter Question

    In Impromptu 7, I have a report of portfolios with a number that respresents each account under that portfolio. Any given portfolio may have one, two or ten accounts under it. I need to remove any portfolios that have a 1 as any one of the account types, no matter how many other account types...
  5. JRandallC

    Totals for certain criteria only

    I have a report of portfolios, and the accounts under that portfolio. Each account has an account type code, which is a number representing the type of account. Some numbers represent loans, and other numbers represent deposit account. (i.e. 1, 2, and 3 are deposits; 4, 5, and 6 and loans). How...
  6. JRandallC

    Summary Only - No Detail

    I did the thing in the list properties, and that did the job. All of this was helpful and educational. Thanks alot!! Randy
  7. JRandallC

    Summary Only - No Detail

    All of that works great up to number 4. When I click to insert Column Titles, then only place I am allowed to insert titles is in my footer. Anywhere I get a "NO" icon on my mouse. When I get a "GO" icon and click in the footer, the screen flashes, or refreshes, but I see no...
  8. JRandallC

    Summary Only - No Detail

    I've also tried hiding the detail columns, but if I hide all of the detail columns, it removes everything from the report, including the summaries in the footer. Randy
  9. JRandallC

    Summary Only - No Detail

    What is the easiest way to hide the details in an Impromptu Series 7 report, and show only the summaries in the footer, and still show the column titles for the summaries that are listed in the footer? I have tried setting the height of the details rows to 0.00. Sometimes this works great, and...
  10. JRandallC

    String to Date?

    Hopefully this will be a simple question. I am working on a report in Impromptu 7. I have a field that I have pieced together with inserted text and text from another field. This field resembeles a date in mm/dd/yyyy format. How can I convert this field from a string to a date? I need to use...

Part and Inventory Search

Back
Top