Search results for query: *

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

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...

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

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...

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...

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

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...

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

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...

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...