COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: JohnnyMac on 20 Mar 2017 08:31:39 AM

Title: Set sort in query and viewer is corret by sort is incorret in excel
Post by: JohnnyMac on 20 Mar 2017 08:31:39 AM
Set the sort in the query using the sort functions from Report Studio. When I output to excel the sort is incorrect. This will be a scheduled report so not sure if I can use the parameters functions.
Title: Re: Set sort in query and viewer is corret by sort is incorret in excel
Post by: New_Guy on 20 Mar 2017 09:59:11 AM
Hi,
Setting up the sort on a data item in a query should work in any format or with scheduled reports. Can you try this on a sample report or share a sample xml to look into?
Are you using the data item that was sorted on the layout.

Good luck
New Guy.
Title: Re: Set sort in query and viewer is corret by sort is incorret in excel
Post by: JohnnyMac on 20 Mar 2017 07:21:50 PM
It worked great. Thanks