If you are unable to create a new account, please email
bspsoftware@techdata.com
The largest independent IBM Cognos collaboration community - Brought to you by BSP Software!
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Login with username, password and session length
News:
MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now
Learn More
Home
Help
Search
Calendar
Login
Register
COGNOiSe.com - The IBM Cognos Community
»
IBM Cognos 10 Platform
»
Cognos 10 BI
»
Report Studio
»
Page totals
« previous
next »
Print
Pages: [
1
]
Author
Topic: Page totals (Read 914 times)
niahanth
Guest
Page totals
«
on:
03 Aug 2016 09:39:15 am »
Hi All,
I have a a list report of multiple pages. At the each end of each page i need to get the total which should only total the data present in that page. Similarly for next page i need to total for data only in that page. Can anyone help on how to achieve that.
Thanks
Logged
Vamsi@123
Associate
Join Date: Dec 2022
Posts: 4
Forum Citizenship: +0/-0
Re: Page totals
«
Reply #1 on:
20 Jan 2023 03:59:21 am »
Hi team
You need to use groupby which column you want separate page and givevpage set that column (which was group by column) then you will get page wise total .
Logged
dougp
Statesman
Join Date: Jul 2014
Posts: 814
Forum Citizenship: +30/-1
Re: Page totals
«
Reply #2 on:
23 Jan 2023 01:32:01 pm »
Vamsi is correct. Cognos won't give you a total based on a variable or random collection of data. You need to define what belongs on each page, then have Cognos total that.
Logged
MFGF
Never knowingly correct
Super Moderator
Statesman
Join Date: Jul 2005
Posts: 11,567
Forum Citizenship: +674/-10
Cognos Software Muppet
Re: Page totals
«
Reply #3 on:
23 Jan 2023 03:11:35 pm »
Great replies, but the original poster is no longer around, sadly. The admins of the site cleaned out unused accounts sometime last year, and the OP's account looks to be one of them.
Cheers!
MF.
Logged
Meep!
Print
Pages: [
1
]
« previous
next »
COGNOiSe.com - The IBM Cognos Community
»
IBM Cognos 10 Platform
»
Cognos 10 BI
»
Report Studio
»
Page totals
BSP Software Articles
Populating Framework Manager Descriptions from SQL Server Extended Properties
Performance Monitoring in MetaManagerâ„¢
BSP Software
Resources
About Us
MetaManager
BSP Software Training
BSP Software
Integrated Control Suite
YouTube Channel
TD SYNNEX
Security Migration
Twitter - TD SYNNEX
IBM Cognos
Integrated Management Suite
ExitCertified - Cognos Training