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!

Recent content by sln007

  1. sln007

    Is it possible to pull the most recent record for an employee

    Steve, Create a calculated column, named MaxRec, as " MAXIMUM([date] for [employee]) ". Then create a filter: MaxRec = [date] This will ony show those row(s) where the [date] equals the hightest date for the [employee]. SLN
  2. sln007

    Yesterday

    I assume you have a "Transaction Date" of some kind on your database row. In the filter for the report add: [TRANSACTION_DATE] = _add_days(current_date,-1) SLN
  3. sln007

    parameters and cognos

    The prompt wizard allows for easy filtering when using a prompted parameter. It's a simple process when adding a "Value prompt" for example. SLN
  4. sln007

    Need help in syntax error in Report Studio

    The column referenced, '[Database View].[ResourceAssignment].[Remaining Start Date]' is not found in the defined data store. Double check the data object items. SLN
  5. sln007

    Filter Syntax in Report Studio

    uday..., Try using: _add_days(date-exp, integer) [Business View].[ProjectSpread].[End Date] <= _add_days([Business View].[Project].[Data Date],43) SLN
  6. sln007

    Date Format in the Report Studio

    uday.., Select the column of your date, In the Properties pane -select "Data Format" and open the "Data Format" panel, Set the "Format Type" to DATE, Set "Display Years" to "Hide Century" Set "Display Months" to "Short Name" Set "Display Days" to "None" Ought to do it. SLN
  7. sln007

    Trying to create an expression!

    Try: CASE WHEN ([JOB].[EMAIL_JOBS_E].[EMAIL_TYPE] IN (1,2,4,8,10,12,15) or [LIST_ID] IN (225,226,227,228,229,230,231)) THEN [JOB].[LIST].[DESCRIPTION] WHEN ([JOB].[EMAIL_JOBS_E].[EMAIL_TYPE] = 11) THEN 'E-Mail' ELSE 'N/A' END SLN
  8. sln007

    Moving unpacked numeric to packed numeric

    Simply MOVE UNPACKED-NUMBER to PACKED_NUMBER. Then work with PACKED-NUMBER. SLN
  9. sln007

    Cognos Report output to be saved to a table

    blom0344 has it right. An automated DB or ETL solution is far more desired than manual actions/tasks......but sometimes necessary. SLN
  10. sln007

    Prompt to show or hide a column in a report

    To do this a few things need to be created. 1. Create your Report with 2 columns: Part Number, Description 2. Add a 2 row table in the header area, make the first row, 1st column .25" in height and 1.5" width. 3. Put a Value Prompt in the 1st Column, 2nd Row. Make id a "Radio Button" type...
  11. sln007

    Cognos Report output to be saved to a table

    recog, We currently use the Report Studio o/p to .csv from one of our ERP data warehouses. (in ORACLE) Then open the file in EXCEL 2007, then save as a Tab Delimited .txt file. Then FTP that file to our mainframe, and a DB2 load utility reads the file, as a delimited file, and loads directly to...
  12. sln007

    Problem with the data or me?

    BLOM, The final query, while containing 3 rows each, will be reduced to 1, when the report studio report groups on all 4 columns. It will reduce the result to 1 row by NAME, TYPE1, TYPE2, TYPE3. Auto-Aggregation might do that anyway. It will essentially be: SELECT NAME, TYPE1...
  13. sln007

    Problem with the data or me?

    Jack, Create 3 queries: Name, Home_PH, Work_PH, Mobile_PH Where each populates the Name column, and one of the 3 Phone Number types. Union the 3 queries together. Group by Name, Home_PH, Work_PH, Mobile_PH Joe, XXX-XXXX, 'spaces', 'spaces' Joe, 'spaces', XXX-XXXX, 'spaces' Joe, 'spaces'...
  14. sln007

    Show/Hide Columns using Prompts in Cognos Reportnet

    I've performed this same operation of "Conditianally Formatting" the view/do-not-view columns based on radio buttons from a prompt page. It works. I used Report Studio from v8.2 I'm not sure if your v1.1 would work the same (I assume so). Would you like more info on this operation? Steve N...
  15. sln007

    data format not possible

    If all of the values contain only numerics, then casting the varchar field to a number, then using the data format property will work. If a cell has a alphabetic or non-numeric value, then the conversion will not be successful. Steve N. State of Ohio, MIS
See more

Part and Inventory Search

Back
Top