Search results for query: *

Hi, I have a simple grouped list report with four Columns grouped, the top one sectioned. I have a Count(incident) column not in the list that needs to be displayed in the Page header with the sectioned value i:e 'Region X = 100' When I page down, I need the data item (Region) in the Page...

I have looked everywhere but cannot find a method to use {CurrentDay -1}for example as the "Last Date" property on a Report Studio Date Prompt.It requires a hard coded date in date format. any pointers on this? Thanks

How do you hide ReportNet drill thru reports from the user so they dont try to open them without the filter?

Hi, I have data in a table that looks thus: Event_number Risk_Code 1 A 1 B 1 C 2 A 2 D 2 G I need it to look like this: Event_number Risk_code 1 A B C 2 A D G Can this be...

Hi, As a newbie I am trying to construct a batch file to find all instances of a a word "abc" in a bunch of log files and replace with "xyz". The Findstr command is great,but The replace command only seems to work at the file level, not the word/line level. Any ideas? cheers

Hi, As a newbie I am trying to construct a batch file to find all instances of a a word "abc" in a bunch of log files and replace with "xyz". The Findstr command is great,but The replace command only seems to work at the file level. Any ideas? cheers

I would like to use environmental variables in a Transformer macro to replace the username and password in the macro. What is the syntax to pick up an environmental variable? Is it possible e.g DIM username = {user_variable$}?

I have data as this:The Header is a parent of the Fixed. I need to filter out Headers whose ID = NULL, then take the number of the NULL header and filter out all other rows with that number (1041) in it. Is this possible without using a view or dataset filter? Datasets get corrupt on MR1 and we...

I have a Decisionstream build that produces a Ragged Dimension. Is there any way to pad out the heirarchy so missing values are copied down into each level to the bottom level?

Is it possible to automate the adding of new measures appearing in an existing datasource into a model? How would a macro pick up a new column and add it as a new measure? I have not seen any scripting yet that has done this and am wondering if it has been done before.

Hi, I have a cubegroup that is based on a Dimension,but I need to be able to automatically insert 'Reconciliation' into each of the cubes filenames.e.g Finesse.mdc -> Finesse_reconciliation.mdc. I have been doing it manually up to now, but it needs a DOS or macro to catch and rename all new...

I need a script that checks for the addition of a column in a data source query(iqd) and adds it into the Transformer model as a new measure.Has anyone tried this before? Cognos knowledgbase does not seem to have any references to this.

I am trying to create a DOs batch file that opens an email URL, enters the username and password,then deletes all the emails. Ive got this far..... Start http://webmail.xco.net/cgi-bin/MENU=TRUE This obviously brings up the entry page for the email site, but I need the commands/parameters to...

Is it possible to create a drop down list to select summary filters for an Impromptu report? For example, 'Gross Profit < 300000' 'Gross Profit > 300000' 'Gross Profit% < 10%' 'Gross Profit% > 10%' Thanks in advance

I have a macro that uses Getdatavalue from an Impromptu report and applies it as a parameter to another Impromptu report. Unfortunately there are 276 values in the filter IMR ,and an Impromptu report only retrieves the first 100 at a time.The macro cannot &quot;scroll&quot; to retrieve the next...

Hi, I am a newbie and have been given the task of building a small app that takes PDF files from one folder and copies them to another folder based on a unique file name.There are about 1500 files to be placed this way on a regular basis.Windows 2000 environment I have absolutley no idea if VB6...

I have a Powerplay(v7.0) Client Reporter report that contains two Custom exception Formats (Font light or Bold red or no decimal places)and a couple of Percentage formats that go to two decimal places. When I add layers to the report, all the formats go to two decimal places, yet when I add the...

I have an Impromptu report that has two levels,Level and Grouping. There are 5 levels in the business, and the prompt asks from 0 to 4 which level they want to choose.The Grouping is also chosen from this prompt,but works one back,so if I choose Level 4, then the Grouping would be level 3. I...

I need to be able to replace several hundred different calculations in an Impromptu 7 report with a set of different calculations in order to facilitate building another report.I intend keeping the calculation names the same, groupings the same etc -just the definition of the calcs change.Has...

we are contemplating upgrading from NT4 to Win2000 operating system with Cognos v7.0 Are there any migration or configuration issues moving from NT4 to Win2000?