COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Enrique on 12 Oct 2015 05:45:30 AM

Title: re use a Report expresion/filter a value for a report expresion
Post by: Enrique on 12 Oct 2015 05:45:30 AM
Hi everybody!

I have a table with some values [field1][field2][field3]  in another part of my report i have a "Report Expresion", I would like to filter the [field1] for my "Report expresion"

Does it that posible ? another problem is that this Report Expresion is not in QueryExplore. its just in report


Thanks for any help!
Title: Re: re use a Report expresion/filter a value for a report expresion
Post by: Lynn on 13 Oct 2015 02:27:47 AM
Quote from: Enrique on 12 Oct 2015 05:45:30 AM
Hi everybody!

I have a table with some values [field1][field2][field3]  in another part of my report i have a "Report Expresion", I would like to filter the [field1] for my "Report expresion"

Does it that posible ? another problem is that this Report Expresion is not in QueryExplore. its just in report


Thanks for any help!

That is the inherent difference between a report expression and a query expression. You will need a query expression in order to use it in the query. If you explain what the report expression is all about and provide some details about your data source (see the etiquette sticky post) you may get some help translating it to a query expression.