Search results for query: *

Thanks for the suggestion Misscognos! I checked, and the system administrators role didn't have everyone in it. After that I finally heard back from Cognos support, who sent me a document with instructions on how to hide folders and packages in Cognos Connection. I'll post the "light" version of...

Hi Kvintus, No, we haven't found a solution to any of these issues. We are running Cognos 8 MR2 on windows server 2003 with MS SQL database. Oh well -- thanks for the feedback! -ksolutions

I am having a difficult time restricting access to folders/reports in Cognos Connection (I am using Cognos 8 MR2). I am trying to use our Active Directory to do so. Here is a list of the steps I took to attempt to restrict access: 1) In Cognos Configuration, I made sure in Security ->...

I just wanted to post some issues that I've come across in the upgrade from Cognos 8 MR1 to MR2 with Report Studio to see if any of you guys have run into the same thing or have feedback. #1) Known issue with Cognos (problem #528798, expected to be fixed in next release): when attempting to...

Does anyone know of a way to format data in Initial Caps (like United States of America instead of united states of america)? My server doesn't support the oracle function initcap. I was trying to think of a way to write an expression for this, but I can't figure out how to capitalize the first...

Thank you so much for helping out :)

I just wanted to say thank you for the help - it seems that I can only join 2 queries up into the new query, so if I have 8 separate queries, I'll need to bring them 2 and a time into a new query (ending up with 4 new queries), then bring those 2 at a time into a new query (ending up with 2 new...

I'm interested in knowing the answer to this as well - what I've been doing is packaging up the whole thing in an export, importing it into a new package in 8, and then copying the one or two reports I need into whatever folder I have set up in 8. Takes a long time and I'd rather just export a...

I built a report in Cognos 7 Report Studio. The report has a tabular model which has children in it. I migrated my environment to ReportNet 8 recently, and the report that I built doesn't work. Cognos support tells me that the way I built my report isn't supported anymore. If that's the case...

I wanted to let everyone know that I found the solution. Some of you may find this useful, so I thought I'd post it for you. This was done in Report Studio. The solution was: 1) Create a list report 2) Drag over an item representing Order Numbers from the model. In my particular circumstance...

Oops! Sorry - ReportNet. I use Report Studio to build all of my reports.

I would like to build a report that shows how many times customers have ordered. I'm looking for something like this: # Times Ordered Count of Customers Fitting This Criteria 1 100 3 75 4 74 etc... Customers are identified by...

It works! I ended up with the following: if ([Order Channel]='Online' ) then (total(count( distinct [Order Nr]))) else (0) Thank you so much for your help. You're right, report studio is very picky!

Unfortunately it doesn't work - I keep adding a bunch of parenthesis to fix the problem and finally ended up with this: if ([Order Channel]='Online') then (total(count(distinct[Order Nr]))) else 0 but I get an error saying "there was a parsing error before or near position: 77, text starting...

I need to provide data regarding orders by channel. Orders are in [Order Nr] and the channel that they come in on is defined in [Order Channel]. [Order Nr] is the customer's order number, and [Order Channel] can be Online, Phone, Mail, etc. I can calculate the overall total count of orders as...