Recent content by Mailpack

I would use rank([Gross Sale Amount]*-1) This would give you a reverse ranking, and then use rank<20 to filter the report.

I am trying to find a way to print a powerplay report to a specified printer (not the default) so that I can automate the process of printing off powerplay reports to printers that are local to my users. objImpRep.FileSetPrinter Destination will work for Impromptu reports, but not for...

Thank you very much. That hit the spot !! Regards Roger Pearson

In the AS/400 Database, I have several DateTime fields. I need to be able to Extract the time portion for Calculation Purposes. There is a Datetime to Date function, but not DateTime to Time? Regards Roger Pearson

I would reccomend that you upgrade the client access software to the newer I-series access software. This is IP only, but run much faster as there is no overbloated support for old technology. This was a complete re-write of the older client access that has been around since conception in...

Dear All, I am using V7.1.544.0. When I create a report using the Small Fonts, and perform a save as pdf. The resulting pdf file does not have the small font in it, it is substituted with ArialMT!! I have updated the following in Configuration Manager Services \ PDF Rendering: Font Embedding...

Vivek, Thanks for the TOP TIP!! It has now worked per your response Thenk you very Much. Regards Roger

I am creating a General Ledger Profit and loss report. Showing calcualted categories as rows and months year to date as columns, with Actual and budget nested under them. i.e. JANUARY FEBRUARY CUMULATIVE ACT BUD ACT BUD ACT BUD...

Thank you very Much Flex. This has worked great.

I have 20 users using the Cognos Upfront Web Portal and everything is working fine. We use Powerplay web and Impromptu Web Reports. When the users do not take any options for what seems like 15 minutes, they are being forced to log back onto the Upfront system. Does anyone know where the...

This is only possible using Series 7 Version 2 upwards. I got this working yesterday. Set ImpRepObject = ImpAppObject.ActiveDocument ImpRepObject.ExportExcelWithFormat (&quot;\\Gossips\cognos$\Cognos\Live\User Downloads\SD0002 Estimates Raised Yesterday &quot; & Date$ & &quot;.xls&quot;) I...

To get the data in the report to change, use a date selection field compared to the function today. This will then filter the data on the report to only show the current date. You can either include the date field as a column on the report, or include the today field in the report header