COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: JuliaM on 14 Mar 2012 01:37:01 PM

Title: Drill through to different pages
Post by: JuliaM on 14 Mar 2012 01:37:01 PM
Hello!
I have a report with 3 variables to pass in drill through. One of this variables I use as Render Page for specific page display in the Target report. I don't use this variable in query nor in the crosstab, and I added a prompt for it.
When I drill through I get an error "CRX-API-0016 The expression input string is empty: ""."
Help please!
Title: Re: Drill through to different pages
Post by: bi4u2 on 30 Mar 2012 07:38:26 PM
Julia,

I think that you can create a dummy query item with the name of the parameter for the render variable with an expression like this ?Detail_Page? , then use the value to send to the drill thru target.

Cindy
Title: Re: Drill through to different pages
Post by: JuliaM on 11 Apr 2012 03:52:39 PM
Thanks Cindy!
It's been done by adding the same field to the crosstab and conditioning.  8)