Print Page - Filter the crosstab data

Title: Filter the crosstab data
Post by: g.congnos on 07 Oct 2013 10:40:11 AM

Hi all,

Can i set a filter directly in the crosstab?

I think I can't use 2 different queries. My report is structured as follow:

-Set Page (I need to show the same report in different pages depending on the value set in the prompt page)
-Page report
-two crosstabs. They are the same with an exception: i need to filter the data of one crosstab.

any suggestions?

Thanks

Title: Re: Filter the crosstab data
Post by: Lynn on 07 Oct 2013 11:59:32 AM

Ok, now I suggest you don't double post ;)

You can try using a query reference. Drag a new query into your query explorer and then drag the original query to the right of this new query. Drag the desired elements from the base query into the new query and apply a filter as desired. Associate one crosstab to the base and the second crosstab to the query reference.

Title: Re: Filter the crosstab data
Post by: g.congnos on 08 Oct 2013 02:07:20 AM

I don't know how move the post ;)

Thanks, I'll try!!

Title: Re: Filter the crosstab data
Post by: MFGF on 08 Oct 2013 11:32:38 AM

Quote from: g.congnos on 08 Oct 2013 02:07:20 AM
I don't know how move the post ;)

All sorted for you! :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: g.congnos on 07 Oct 2013 10:40:11 AM