基于参数Rpt视图选择的动态列 [英] Dynamic Columns based on Parameter Rpt View Selection

问题描述

我有一个带有报表视图参数的报表，这是一个基于表的存储过程，根据该参数的选择，我希望它只返回某些列。



例如，如果他们选择'91 -120查看'它将返回...



摘要总索赔0-30 31-60 61-90 91-120



如果他们选择'91 -210查看'它会返回



摘要总索赔0-30 31-60 61-90 91-210



如果他们选择'0-90查看'，它将返回



摘要索赔总额0-90 91-180 181-360 361+



最大的问题是有8个表报告20 +列，目前我必须进入每个报告的每一列，并列出一个有效但非常耗时的列可见性公式，更不用说在创建新视图时必须更改公式。



当前表格se我们是......

摘要总索赔0-30 31-60 61-90 91-120 91-210 0-90 91-180 181-360 360+

汇总金额％ct amt ct amt ct amt ct amt ct amt ct amt ct amt ct amt ct amt



有一个更容易的方式

I have a report that has a "Report View" Parameter, this is a stored procedure based off of a table, Based on the selection of that parameter I want it to only return certain columns.

Example if they select '91-120 View' it would return...

Summary Total Claims 0-30 31-60 61-90 91-120

if they select '91-210 View' it would return

Summary Total Claims 0-30 31-60 61-90 91-210

and if they select '0-90 View' it would return

Summary Total Claims 0-90 91-180 181-360 361+

the biggest issue is there are 8 tables on the report that 20 + columns, currently i have to go into each column on each report and put a column visibility formula which works but is very time consuming not to mention the formula would have to be changed when a new view is created.

Current table set us is...
Summary Total Claims 0-30 31-60 61-90 91-120 91-210 0-90 91-180 181-360 360+
Summary Count Amount % ct amt ct amt ct amt ct amt ct amt ct amt ct amt ct amt ct amt

THERE HAS TO BE AN EASIER WAY

推荐答案

这篇关于基于参数Rpt视图选择的动态列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！