COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kvchow on 21 Oct 2014 05:02:58 AM

Title: Regarding report page
Post by: kvchow on 21 Oct 2014 05:02:58 AM
Hi,
I have a prompt page in that i have a student roll Number prompt,in report  page in the header i have columns like Student Roll Number/Student Name/Student Percentage

Here my user question is if i am entered Student Roll Number In prompt page i wanted to see the corresponding student Name and Student Percentage in the Header(Here i am passing Student Roll Number Parameter to report page),thats fine ,but how can i show the Corresponding Student Name and his Percentage like this..0123/sdsds/78

Thanks,
Kvchow
Title: Re: Regarding report page
Post by: CognosAnalytics on 30 Oct 2014 03:02:28 PM
Create a separate query and pull the required data items, Name and Percentage in it. Add a filter to filter on roll number selected in the prompt. In the report header use signletons associated with this new query and add the data items that you want displayed.

-Cognos810