Hi,
I think you can only do this by working with the SDK. A former collegua of mine has done it in the past. Maybe Cognos has a solution to this on the shelf.
Good luck!
Hello CRNPLAYER,
You might try this:
In report studio go to 'tools' --> 'copy report to clipboard'.
Then paste it to a text editor and perform a 'find & replace'.
Copy all to the clipboard again and then from 'tools'
--> 'open report from clipboard'.
This is quite a fast way to edit reports...
2 items of class:
exciting classes: if ([class] in ('Gym Class'; 'Aerobics Class') then ([class]) else null
dull classes: if ([class] in ('History class'; 'Economics') then ([class]) else null
an item named NoS (number of Students). The formula (hang on, it's tough): 1
Good luck!
Thank you all for your reactions.
At this moment I got a reaction from the cognos support desk. They told me the thing I want isn't available in Crosstabs. The reason is dat crosstab-facts can't display text.
Thanks to that I have to create some calculations. For your interest, this is how I...
Hi all,
Despite your solutions... it doesn't solve the real problem.
When doing [20/01/2005 14:25]-[19/01/2005 12:00] in the tabular model, the result is 1 day 2 hours and 25 minutes. This is fine, but when I drag this calculation into the fact-area of the crosstab it shows 95.100.000.
When...
Hello,
Within a Report I'm substracting two datetime fields to calculate the interval. This works fine in the tabular model. But when I want to put this interval in a crosstab as a fact ReportNet displays it in milliseconds.
I've tried to adjust the dataformat to interval with showing the hours...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.