If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Multiple Lists Sort Order

Started by Deborah, 12 Mar 2010 08:40:23 AM

Previous topic - Next topic

Deborah

I have a report that has 3 lists with data about a Company - and I want to see this report for multiple companies. I have 2 section headings on List 1 and 1 section heading on List 2 and List 3.


If I just create 3 lists, when the page is rendered I get the lists in this order:

Company Name A  List 1
Company Name B  List 1
Company Name C  List 1

Company Name A  List 2
Company Name B  List 2
Company Name C  List 2

Company Name A  List 3
Company Name B  List 3
Company Name C  List 3

What I want is the report to be sorted like this:

Company Name A  List 1
Company Name A  List 2
Company Name A  List 3

Company Name B  List 1
Company Name B  List 2
Company Name B  List 3

Company Name C  List 1
Company Name C  List 2
Company Name C  List 3


I tried placing List 2 and List 3 in the footer of List A, but on the last Company Name (Company Name C in this example)   List 3 didn't appear. Any idea on how I can get my desired results?

Thanks in advance for any help.

CognosAdmn

Hi Deborah,

Could you please confirm if I understood you correctly:

Quote from: Deborah on 12 Mar 2010 08:40:23 AM
I have a report that has 3 lists with data

Three different lists in the same report? Does it mean that you have three different queries as well? If you do, are you filtering each list/query for a specific company?



Deborah

Hi CognosAdm,

Thanks for replying.

Yes, the three lists are on the same page of the same report. I am using one query for all three lists since the data is similar and the three lists are just summarized differently. For example, list 1 contains all the data, list 2 contains all the data but summarized by business group, list 3 contains all the data but summarized by age group.

I'm allowing the user to choose how many companies to display from the prompt page and passing the parameter(s) to the report page as a filter.

As an aside that I forgot to mention earlier, the report worked as a PDF but not in HTML view when I used the footer of list 1 to hold list 2 and list 3.

ajaju

Hi,

As per my understanding regarding your problem I have one solution.You can try this out.

Take a repeater.Insert one table with 3 rows and one column and in each row add the list which you want. This will result in showing up all the three list say for company A on one page.When you will click on Page up it will show up all three list for Company B and so on.

Hope this is what you expect.

Regards,
Aarti