Cognos动态过滤 [英] Cognos Dynamic Filtering

问题描述

我在互联网上进行了搜索，但找不到答案.我想创造1.具有两个选项A，B(应该是数据库中具有日期"数据类型的两列)的单选按钮，并且2.日期提示现在，如果用户选择带有日期范围的选项A(在日期提示中)，则应在A上过滤数据如果用户选择带有日期范围的选项B(在日期提示中)，则数据应在B上进行过滤

I searched all over the internet but couldnt find an answer. I want to create 1. a radio button with two options A, B (which are supposedly two columns in the database with "date" datatype) and 2. a date prompt Now if the user selects option A with a date range(in the date prompt) the data should be filtered on A if the user selects option B with a date range(in the date prompt) the data should be filtered on B

推荐答案

您的问题尚不清楚，但是如果我理解您想使用单选按钮来确定要在过滤器中使用哪个日期列?如果是这样，那么类似的事情应该起作用:

Your question is far from clear, but if I understand you want to use the radio button to determine which date column to use in a filter? If so, then something like this should work:

if (?RadioButtonPrompt? = 'A') then ([DateColumnA] = ?DatePrompt?)
else ([DateColumnB] = ?DatePrompt?)

这篇关于Cognos动态过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！