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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by L34621

  1. L34621

    Impromptu 7.3 Retrieve value from the previous row.

    Well, I guess never mind...I was able to fill in the missing data by creating a running count field and then create Minimum date field by the new running count. It works! But I think a lag function in Imporomptu would have been so much easier. Take Care! ...Donna
  2. L34621

    Impromptu 7.3 Retrieve value from the previous row.

    In Impromptu 7.3, Is there a function or technique which would fill in a blank field with data from a previous record? I have not been successful with if-then-else statements, the data must come from the previous record. Any help is much appreciated.... Thanks! Donna
  3. L34621

    How to modify the summary of a crosstab to produce the desired result?

    Hi Mick, I am using Cognos 7.3, but in crosstabs, I've always had issues getting the summary percentages to come out correctly. Usually I get an averages in the summary crosstab. These are the steps I took in 7.3 to get the right summary percentages: 1. total the whole numbers for Male and...
  4. L34621

    Looking for a macro that will send an encrypted excel spreadsheet

    Thanks so much! great info! and it's much appreciated! You are a rock star!!!
  5. L34621

    Looking for a macro that will send an encrypted excel spreadsheet

    I am looking for a way to automatically mail an Impromptu report saved as an excel spreadsheet that is password protected. I already have a macro that that will open Impromptu, attach to the catalog, create an excel spreadsheet and then e-mail it. But now I need to have the excel spreadsheet...

Part and Inventory Search

Back
Top