Cognos 8.3：我可以在条件样式表达式中使用参数吗？
我有开始日期和结束日期参数，可以很好地作为查询的过滤器，如下所示：
[EMR Reporting].[Appointments].[Appointment Date] between ?Start Date? and ?End Date?
但是，当我尝试将条件样式应用于基于“开始日期”的字段时，报告会崩溃。
我是否应该能够在条件样式表达式中使用参数值，或者由于某种原因不支持此功能？
谢谢！
I have Start Date and End date parameters that work fine as filters on a query, as follows:
[EMR Reporting].[Appointments].[Appointment Date] between ?Start Date? and ?End Date?
But when I attempt to apply conditional styles to a field based on ?Start Date?, the report blows up.
Should I be able to use parameter values in conditional style expressions, or is this not supported for some reason?
Thanks!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
你看起来所做的事情似乎很合理。
创建一个布尔变量...，条件为
[EMR Reporting].[Appointments].[Appointment Date] 介于“开始日期”之间和“结束日期”然后将其用作样式变量或当 true 时的其他变量...这一切都应该有效。可能需要更多细节。
what you look like you are doing seems sound.
create a boolean variable... with the condition of
[EMR Reporting].[Appointments].[Appointment Date] between ?Start Date? and ?End Date?then use it as as style variable or something when true... this all should work. more details may be needed.
请尝试以下操作：创建一个新查询并使用参数值提供查询项。
然后，将报告页面与您刚刚创建的查询相关联并尝试进行条件格式化。我还没有尝试过这个，但它应该有效。
Try the following: Create a new query and feed a query item with the parameter value.
Then, associate the report page to the query you just created and try formatting conditionally. I haven't tried this but it should work.
我知道已经太晚了
将具有参数值的数据项添加到当前查询中。将其添加到您的报告项目中。隐藏该列。在条件格式表达式中使用它
I know it's too late
Add a dataitem with the parameter value to your current query. Add it to your report item. Hide the column. Use it in your conditional formatting expression