Search results for query: *

Lets say I have Pline, Ptype, Pname I need to find total(measure1 for Pline), total(measure2 for Ptype) I created a similar calculation but the summary doesn't seem to happen at Pline level/Ptype level. What needs to be done? Prasad RPrasad1@Chn.Cognizant.com

Using a Macro, Is it possible to read the contents of the report header? Say all the text frames available on the header. Pls let me know if its doable Prasad RPrasad1@Chn.Cognizant.com

I have a table with few rows and cols. I have text frames inside each cell. Except for the first page, I want this table to be removed. I did that using a condition and made box type-none but doesn't work. any suggestions? Prasad RPrasad1@Chn.Cognizant.com

And ... does it generate a single sql? My friend was saying that Cognos generated multiple sqls for the above scenario. is it true? any work arounds? Prasad RPrasad1@Chn.Cognizant.com

Bajwa, Its very much possible. Since this seems to be a bit older post, Let me know if u still need it or if u haven't acheived it. Prasad.

Its possible. Just wanted to chk if u did it before typing a long reply ;) Prasad.

wat info r u looking for

Hi, If that doesn't work, then you can try replacing the TMOD with a TSET having the original TMOD and a new TMOD which gives summary info. Prasad

Simple. To integrate ur java env with CRN, Cognos has provided those jar files n all other stuff required to connect java and CRN. Those files are downloadable, I guess. Using that you can write ur java/jsp code to connect to CRN, get authenticated, view reports, pass prompts to reports...

a) Why use Cognos Reportnet SDK? If u wanna do something out of the box, say get inputs from users and depending on it redirect to any report or design customized prompt pages and pass the values to CRN from ur application .. etc.. b) Where to use Cognos Reportnet SDK? - c) When to use...

if u r using ASP, then try SERVER.URLENCODE(any string). This will do the trick. Prasad RPrasad1@Chn.Cognizant.com

ENERGY & UTILITIES = ENERGY+%26+UTILITIES where, + is for space and %26 is for & Prasad RPrasad1@Chn.Cognizant.com

u mean MR1? I guess it got released

Sorry for the delay in replying... I faced the same scenario... Try converting all the 1 - M joins to 1-1. Logically speaking, if we are going to write a SQL to pull data from 2 tables, we never bother about 1-1 or 1-M. The SQL is same for both the cases. Keeping 1-M relation leads to...

Do u have many to many joins defined ?? Or, does any of ur query subject has 1 to many joins with more than 1 query subject? Prasad RPrasad1@Chn.Cognizant.com

can u explain a bit more Prasad RPrasad1@Chn.Cognizant.com

Create a Calculation of the type 'Detail'. In the expression editor, type : #sq($dbCatalog{$account.personalInfo.userName})# Prasad RPrasad1@Chn.Cognizant.com

I dont think there is a straight forward approach. r they date or date/time?? Prasad RPrasad1@Chn.Cognizant.com

Try this : Create a Calculation of the type 'Detail'. In the expression editor, type : #sq($dbCatalog{$account.personalInfo.userName})# Have this calculation in header or anywhere. Now u shud be able to see the database name. Prasad RPrasad1@Chn.Cognizant.com

ReportNetGirl, You wanna see the DB user or ReportNET user? Prasad RPrasad1@Chn.Cognizant.com