Cognos PDF report columns page breaking

PDF reports all columns not showing in 1st page its going to second page: please do pagesetup paper size : custom, define height and width more as per need.

Cognos Cross tab row header

Add cross tab header on row columns : add 1 table with two columns > create two crss tab pointing to your 1 query > in second cross tab select rows data items, cross tab corner then boxtype: none >> in 1st cross tab select columns, measures,cross tab corner then boxtype: none > 1st cross tab align to right top and second cross tab align to left top > run report its done.

Cross tab measure use text value as data iteam

Text item in crosstab measure are : Change the property *Define Contents* to '*YES*" for crosstab Fact cells.

Convert cognos drop down prompt to type in / text box prompt

Convert cognos drop down prompt to type in / text box prompt

If you wants add drop down to type in prompt use caption() : Caption([Query1].[SR_AREA])=?prompt?

Wildcard text prompt - use like in prmpt

You are not sure what user is going to enter values in prompt, so design like this way.

Wildcard text prompt: [Query1].[SR_SUB_AREA] like '%'+ ?Parameter1? + '%'

Sorting based on user selected column - Dynamic sorting by prompt selection

Dynamic sorting by prompt selection

=====================================

> drag two cols like country and revenue

> drag value prompt to prompt page

> Static choice country and revenue used value and display value

> Drag one query expression mean create new cols in list

> case

when paramdisplayvalue='country' then 'contry'

when paramdisplayvalue='revenue' then 'revenue'

else end

> select that particular col country / revenue then grouping/sorting keep that cols

> select another col grouping and soring keep that cols

> remove sort that cols from list

IBM Cognos Business Intelligence 10.2.2 NEW features

Cognos 10.2. Features number - 1

My data sets - User can create his own without any assistance of IT. 

a) Much high volume of data set can import into like excel, text files
b) imported data can process on server as long as user wants
c) stand alone package can be created

1. Go to welcome screen of cognos connection
2. Click on IBM cognos content
3. click on user icon
4. click on my data sets (this will show all data sets which i have and can see package i generated for data sets, it can show no of records, files size)
5. New data sets : by clicking icon employee button
6. import screen i can import like xls, exls, text file(comma separated, tab separated, pip separated) value i can port.
7. after import i can metadata left side and data preview right side pan
8. I can remove unwanted columns from my meta data screen (left side pan)
9. I can change default summery to none, which change icon of data items to attributes
10. Then I can publish package by just click on publish button.
11. I can select location like public / my folder to publish this package, i can give name of the package

My data  sets - administration.

1.  click on cognos administration
2.  Go to status tab in administration, there is a Data sets option
3.  Click on Data sets right side pan will show all details about the data sets like (name, owner, refreshed, file size, rows, tenant)
4.  Left pan we can apply filter to as you want to see.
5.  we can delete any of data set by selecting like data source
6.  User access to my data sets capabilities :
7.  capabilities : click on security and then click on capabilities  then my data sets
8.  click on set properties
9.  go to permission tab add user/group, can add execute and traverse
10. After giving capabilites persimission to user then user can see data sets when login into cognos connection.
11. Data from files user uploade is loading to one of more repositories, you can configure connection to these repository in data source configuration area in cognos administration.
12. Create new data source, in wizard data source type drop down select my data sets repository, its like any other JDBC data source.
13. From initial release of cognos 10.2.2 DB2 only repository for my data sets repository, going forword this will update to SQL server and Oracle

Cognos 10.2. Features number - 2

In Cognos 10.2.2, you now have the ability to create customized User Interface (UI) profiles to control the features and functionality that are available in the User Interface for Workspace Advanced Users. The default user interface profiles still exist, but now, once enabled by your administrator, you have the ability to create new profiles and customize them in the Library tab in the Cognos Administration console. You also have the ability to choose whether to automatically show next generation functionality in the UI when the software is upgraded.


Cognos 10.2. Features number - 3