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

    Impromptu reports created via Direct SQL don't work in 7.1

    We have created some Impromptu reports based on direct SQL rather than through catalogues. These reports worked fine with Impromptu version 7.0 We converted to version 7.1 last week and now some of the reports give 'DMS-E-SS_SYNTAX error number 239' error and will not run (I have not reviewed...
  2. turnerjs

    Impromptu / IWR Catalog Prompts

    SLN007, I had a similar problem trying to insert the results from a selection prompt into the header of a report I had created. CognosHelp suggested, within Impromptu, I click the 'Insert' tab, 'more Objects' tab, 'prompt variables' tab. I know this worked, but I don't remember for sure what...
  3. turnerjs

    Basic Programming - How to count types of records in Impromptu 7.0

    Dave, Thanks for the quick response. Sorry, I took so long getting back, I was trying another solution that was suggested prior to yours. We are using oracle and the Decode function was what I needed. The report works fine. Thanks again Steve
  4. turnerjs

    Catalog Analysis

    Gset, I never looked at User classes, but the tables, joins and folder differences between catalogues (old/new) are highlighted in red - both sides. also the alias names showed up properly.
  5. turnerjs

    Catalog Analysis

    It has been a few months, but I said I would get back. I have finally tested I-Assistant for comparing new/old catalogues. The results are excellant. I find this is an very good tool for documenting Cognos catalogues, tables, joins and reports (I have not looked at security) for both Impromptu...
  6. turnerjs

    Basic Programming - How to count types of records in Impromptu 7.0

    I have numerous records in 1 table. I have many different record types and each record may be 1 of two different status values - 'A' or 'B'. I want to print 1 line for each record type. I want that line to show the type and the total # of records for each type and the total # of status values...
  7. turnerjs

    Catalog Analysis

    We purchased the I-Assistant last week. I have not had time to review the help documentation. I have only used it for documenting folders, tables and joins and that part works fine. The process to load my catalogues (generally under 1MB and around 150 tables) is < 1 minute. I have briefly looked...
  8. turnerjs

    Catalog Analysis

    I have been assigned as administrator for our recently purchased Cognos reporting tool (Impromtptu and PowerPlay). I was not impressed with the catalogue documentation available (Content overview) and asked our Cognos consultant if there was something better. He was going to try and create...
  9. turnerjs

    RecordSet Not Updatable - Why?

    I also have a subform that at one-time worked, but then after some revisions I got &quot;THIS RECORDSET IS NOT UPDATABLE&quot; message at the bottom of the screen. My main form query links 2 tables, the subforms has many combo boxes that pull data from many different tables/queries and I update...
  10. turnerjs

    Counting MANY different things is SLOW

    I have found a answer for my problem. I hope it helps you with yours. Use the 'SUM' function in the 'total' line. In the field area convert the tested field value to a zero or one. The SUM will then tell you how many of the tested values were found e.g. TestForValue05:iif([fieldA]=05,1,0 - the...
  11. turnerjs

    Counting MANY different things is SLOW

    I am also trying to count the number of times a field contains a specific value. e.g I have 100 records, For field1 there are 15 records containing the value 01, 20 records containing the value 02, 28 records containing the value 03, 32 records containing the value 00, etc. Can I produce...
  12. turnerjs

    Documentation - report all 'Record Source' , Code and 'Events'

    I am trying to clean up an Access 97 dB. I know I can get the information I need by looking at each individual Form and Report, but there must be a simpiler way. Is there a process that will show me the 'Record source' name for Forms and reports. Is there a process that will show me all...
  13. turnerjs

    &quot;Month&quot; test on a TEXT returns different results on different machines

    MichaelRed - I received your response as I was entering my response - thank you for responding and it appears to be the reason for the differences.
  14. turnerjs

    &quot;Month&quot; test on a TEXT returns different results on different machines

    One of our tech guys found the probable answer My Control panel, Regional Setting, Date tab default setting for my short date format was dd/mm/yy my long date format was mmmm d, yyyy We changed them to short date = m/d/yy and long date format to dddd, mmmm dd, yyyy Everything appears to work...
  15. turnerjs

    &quot;Month&quot; test on a TEXT returns different results on different machines

    We are a small utility company and everyone is connected to the same databases through servers. My query 'groups' data by various fields. One of these is the 'text' date field named 'ILCRDJ'. The field in the query is Month:Month([ILCRDJ]) The first two records have values of...
  16. turnerjs

    rounding and reporting values

    Maquis and everyone else The following function seems to work Total: CDbl(Format([Subtotal],&quot;0.00&quot;))+CDbl(Format([PST],&quot;0.00&quot;))+CDbl(Format([GST],&quot;0.00&quot;)) Total is a numeric field. The Format function seems to return only to a String, therefore we used the CDBL...
  17. turnerjs

    rounding and reporting values

    Thanks Maquis, The subtracting of .005, in this case worked fine (I added a 'iif' zero test). My use of subtotal with > 2 decimals was a poor example. It should always have 2 decimals. I have other instances were I need to accumulate more than 2 tax fields - a tax may or may not be calculated...
  18. turnerjs

    rounding and reporting values

    Thanks for the tip, however I set the Tables fields to currancy, Fixed and 2 decimals same results. The query shows 2 decimals, but when you open the field there are more decimals present. I even tried setting the field properties in query to currancy, same problems. The Form's total of the 3...
  19. turnerjs

    rounding and reporting values

    MS Access 97 - I have to calculate 2 tax amounts based on a subtotal amout. In Query (Total = subtotal + tax 1 + tax 2) subtotal = 25.3333 tax 1 = 50.333 tax 2 = 25.3333 Total = 100.9996 When I print the individual fields on an invoice or display in a form as 2 decimals, I get subtotal =...

Part and Inventory Search

Back
Top