Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: yildirim.arda on 20 Oct 2015 02:40:08 AM

Title: Using in_range in native sql
Post by: yildirim.arda on 20 Oct 2015 02:40:08 AM
Hello,

I need to use native sql syntax in my report and I have a date range prompt in the prompt page.
As I am using native sql, I can't use in_range function in the sql.
How can I solve this issue? How can I use these two dates in my native sql?

Thanks.
Title: Re: Using in_range in native sql
Post by: BigChris on 20 Oct 2015 03:02:22 AM
Assuming you really do need to use SQL and bypass all the security of the FM model, I think you'll need to create two date prompts, ?BeginDate? and ?EndDate?, and use those in your SQL
Title: Re: Using in_range in native sql
Post by: MFGF on 20 Oct 2015 04:09:42 AM
Why do you need to use native SQL? What problem do you have that can't be solved in your framework model?

MF.
Text only | Text with Images