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 Mike Lewis 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. jamguy

    SP used to calculate two lines from same table

    Will the left join work if the missing line is from Table B, i.e. the 1st line passed is missing? Thanks!
  2. jamguy

    SP used to calculate two lines from same table

    I have a SP used to calculate a new record (LINE) based on the parameters passed for @PLN and @LN and @OPER(+ or -). The values are in the same table so I join the table to itself. The problem I have is when one of the lines passed does not exists it (obviously :-)) doesn't do the calculation...
  3. jamguy

    Remote Connection missing PP 6.6

    Try to open Configuration Manager and see there. These same settings are saved in the cerX.ini file in the Cognos\cerX\bin folder. It may be as simple as "Adding the connection" if that option is available.
  4. jamguy

    Macro in Excel and Cognos

    zimo975, Not sure how within Excel, but I have passed parameters to an Impromptu Report via a Cognos Script then saved that IMR report as an IQD file....the syntax may be similar in VBA, but I haven't tried. Sub open_report (s_openReport as string, s_OpenPath as string) 'REPORT PATH AND...
  5. jamguy

    Line charts

    ymonge, What are you creating the chart in? Reportnet or PowerPlay, or something else? Thanks. TN
  6. jamguy

    Macro in Excel and Cognos

    tommyfoggy, I have an example of a macro that open a PowerPlay report, it does some extra stuff like copying the results to a csv file, etc.....i think you can use this for Impromptu as well: Option Explicit Dim CognosID, ddeChannel As Long Dim PowerplayReport, PowerPlay, objrep As Object Dim...

Part and Inventory Search

Back
Top