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
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...
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
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.