blocks|key|609998|text|如果你这样做，那是可以实现的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|609999|步骤1。对于源，构建一个sql查询，其中按年份、AbsoluteMonth等对数据进行分组。|offset|length|style|BOLD|610000|因此，对于每年/+AbsoluteMonth对，报告只有一个值。|610001|步骤2。使用以下公式：|610002|=IIf(IsNothing(Sum(Fields!Amt.Value)),+Last(Fields!Amt.Value,+"Year"),+Sum(Fields!Amt.Value))|code-block|syntax|javascript|610003|这里的“年份”是组名，Amt+-您的字段名，可能是R_Pax。|610004|Step3.(可选)如果数据不是自然排序的，则对其排序以提供正确的最后值。|610005|第一步非常重要。否则，空值的单元格将不会显示最后一个总，它将显示一个月的最后一个值，因此如果月份(1)的值为30、50、60和月份(2)没有任何值，那么它将显示月份(2)、月份(3)等的60，而不是sum(30%2B50%2B60)。|610006|entityMap^0|0|0|3|0|S|2|0|0|3|0|0|0|0|5|0|Q|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@$D|13|E|14|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|15|8|@$D|16|E|17|F|G]]|9|@]|A|$]]|$1|L|3|M|5|N|7|18|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|19|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1A|8|@$D|1B|E|1C|F|G]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1D|8|@$D|1E|E|1F|F|G]]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|X|$]]

That's achievable if you do this:

Step 1. For your source, you build a sql query where you group the data by Year, AbsoluteMonth, etc.

So for each Year / AbsoluteMonth pair the report has only ONE value. 

Step 2. Use below formula:

<pre><code>=IIf(IsNothing(Sum(Fields!Amt.Value)), Last(Fields!Amt.Value, "Year"), Sum(Fields!Amt.Value))
</code></pre>

Here "Year" is group name, and Amt - your field name, which is probably R_Pax

Step3. (optional) Sort the data if it's not naturally sorted to provide the correct last value.

Step 1 is very important. Otherwise the cell with empty value will not show the last total, it will show the last value for a month, so if month (1) has values 30, 50, 60, and month (2) doesn't have any values, then it will show 60 for month(2), month(3), etc..., not sum(30+50+60).

blocks|key|607824|text|在传递要报告的数据之前，最好先将带有最后值的剩余空白记录插入数据集。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|607825|我猜你的桌子是矩阵的。|607826|DECLARE+@Today+DATETIME
SET+@Today+=+GETDATE()

DECLARE+@MatrixData+TABLE+(
++Month1+INT
,+Year1+INT
,+Value+INT
)

INSERT+INTO+@MatrixData+(Month1,+Year1,+Value)
SELECT+MONTH(DATEADD(MONTH,+Id+*+-1,+@Today))+AS+Date1Month,+YEAR(DATEADD(MONTH,+Id+*+-1,+@Today))+AS+Date1Year,+Id+*+10+AS+Value1
FROM+(
++++SELECT+TOP+60+ROW_NUMBER()+OVER+(ORDER+BY+Id)+AS+Id
++++FROM+SysObjects
)+A
ORDER+BY+Date1Year,+Date1Month

SELECT+*+FROM+@MatrixData

--+Insert+blank+month+of+last+year+with+last+value
INSERT+INTO+@MatrixData+(Month1,+Year1,+Value)
SELECT+A.RunningMonth,+A1.MaxYear,+A1.LastValue
FROM+(
++++SELECT+TOP+12+ROW_NUMBER()+OVER+(ORDER+BY+Id)+AS+RunningMonth
++++FROM+SysObjects
)+A
INNER+JOIN+(
++++--+Get+Last+Value+in+@MatrixData+
++++SELECT+A.MinMonth,+A.MaxMonth,+A.MaxYear,+A1.Value+AS+LastValue
++++FROM+(
++++++++--+Get+Max+Month+Last+Year+in+@MatrixData+
++++++++SELECT+MAX(A1.Month1)+AS+MinMonth,+A.MaxMonth,+A.MaxYear
++++++++FROM+(
++++++++++++--+Get+Max+Month+&+Max+Year
++++++++++++SELECT+MAX(Month1)+AS+MaxMonth,+MAX(Year1)+AS+MaxYear
++++++++++++FROM+@MatrixData
++++++++)+A
++++++++INNER+JOIN+@MatrixData+A1+ON+A.MaxYear+=+A1.Year1
++++++++GROUP+BY+A.MaxMonth,+A.MaxYear
++++)+A
++++INNER+JOIN+@MatrixData+A1+ON+A.MinMonth+=+A1.Month1+AND+A.MaxYear+=+A1.Year1
)+A1+ON+A.RunningMonth+>+A1.MinMonth+AND+A.RunningMonth+<=+A1.MaxMonth

SELECT+*+FROM+@MatrixData|code-block|syntax|javascript|607827|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You better insert the remaining blank records with last value into your dataset before pass the data to report. I assume your table is matrix.

<pre><code>DECLARE @Today DATETIME
SET @Today = GETDATE()

DECLARE @MatrixData TABLE (
 Month1 INT
, Year1 INT
, Value INT
)

INSERT INTO @MatrixData (Month1, Year1, Value)
SELECT MONTH(DATEADD(MONTH, Id * -1, @Today)) AS Date1Month, YEAR(DATEADD(MONTH, Id * -1, @Today)) AS Date1Year, Id * 10 AS Value1
FROM (
 SELECT TOP 60 ROW_NUMBER() OVER (ORDER BY Id) AS Id
 FROM SysObjects
) A
ORDER BY Date1Year, Date1Month

SELECT * FROM @MatrixData

-- Insert blank month of last year with last value
INSERT INTO @MatrixData (Month1, Year1, Value)
SELECT A.RunningMonth, A1.MaxYear, A1.LastValue
FROM (
 SELECT TOP 12 ROW_NUMBER() OVER (ORDER BY Id) AS RunningMonth
 FROM SysObjects
) A
INNER JOIN (
 -- Get Last Value in @MatrixData 
 SELECT A.MinMonth, A.MaxMonth, A.MaxYear, A1.Value AS LastValue
 FROM (
 -- Get Max Month Last Year in @MatrixData 
 SELECT MAX(A1.Month1) AS MinMonth, A.MaxMonth, A.MaxYear
 FROM (
 -- Get Max Month &amp; Max Year
 SELECT MAX(Month1) AS MaxMonth, MAX(Year1) AS MaxYear
 FROM @MatrixData
 ) A
 INNER JOIN @MatrixData A1 ON A.MaxYear = A1.Year1
 GROUP BY A.MaxMonth, A.MaxYear
 ) A
 INNER JOIN @MatrixData A1 ON A.MinMonth = A1.Month1 AND A.MaxYear = A1.Year1
) A1 ON A.RunningMonth &gt; A1.MinMonth AND A.RunningMonth &lt;= A1.MaxMonth

SELECT * FROM @MatrixData
</code></pre>

blocks|key|2175743|text|在Oracle中，它是这样完成的。Server具有合并函数和延迟函数。因此，这在Server中也是可能的。还有另一个类似于此的堆栈溢出问题。只是找不到它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2175744|create+table+mytab(n+number,+m+number);
insert+into+mytab+values(1,null);
insert+into+mytab+values(2,null);
insert+into+mytab+values(3,44949);
insert+into+mytab+values(4,null);
insert+into+mytab+values(5,null);
insert+into+mytab+values(6,null);
insert+into+mytab+values(7,null);
insert+into+mytab+values(8,null);
insert+into+mytab+values(9,null);
insert+into+mytab+values(10,null);
insert+into+mytab+values(11,74631);
insert+into+mytab+values(12,null);
insert+into+mytab+values(13,null);
select+t.*,+coalesce(m,+lag(m+ignore+nulls)+over+(order+by+n))
from+mytab+t;|code-block|syntax|javascript|2175745|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In Oracle it is done like this. SQL Server has both COALESCE and LAG functions. So this must be possible with SQL Server also. There is also another stackoverflow question similar to this. Just could not locate it.

<pre><code>create table mytab(n number, m number);
insert into mytab values(1,null);
insert into mytab values(2,null);
insert into mytab values(3,44949);
insert into mytab values(4,null);
insert into mytab values(5,null);
insert into mytab values(6,null);
insert into mytab values(7,null);
insert into mytab values(8,null);
insert into mytab values(9,null);
insert into mytab values(10,null);
insert into mytab values(11,74631);
insert into mytab values(12,null);
insert into mytab values(13,null);
select t.*, coalesce(m, lag(m ignore nulls) over (order by n))
from mytab t;
</code></pre>

blocks|key|607857|text|我们可以在SQL+end执行此操作，并将数据提取到SSRS。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|607858|步骤：|607859|如果需要的话，不要转动|ordered-list-item|607860|获取粒度列中的数据。这里是绝对月份|607861|然后，使用SQL方法复制Nulls/+last值，这些值为空，最后一个值为Ref：
select+a.AbsoluteMonth,Mon+,first\_value(a.S1\_pax)over(partition+by+a.v1\_p+order+by+num+)+as+S\_Pax+,first\_value(a.S2\_pax)over(partition+by+a.v2\_p+order+by+num+)+as+S2\_Pax+from+(select+*，sum(当S1_pax为null时，case为0+OTHER1End)从v1_p+(按num排序)，sum(+S2_pax为null，而S2_pax为0+OTHER1End)从X_Table+(order+)到v2_p+)a|offset|length|style|CODE|607862|然后分别填满所有的地方。请参阅下面的输出|607863|​|607864|📷|atomic|607865|607866|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/43b652c430372d9eb6529bbe09d19684.png|imageAlt^0|0|0|0|0|16|4X|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|16|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|17|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|18|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|19|8|@$K|1A|L|1B|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1C|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1D|8|@]|9|@]|A|$]]|$1|S|3|T|5|U|7|1E|8|@]|9|@$K|1F|L|1G|1|1H]]|A|$]]|$1|V|3|R|5|6|7|1I|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13|14|-4]]]]

We can do it at SQL end and fetch data to SSRS

Steps:

<ol>
<li>Do pivot if needed</li>
<li>Get the data at granularity column. Here it is Absolute Month</li>
<li>Then use the SQL method to replcae the Nulls/ last values which are empty with the last highest value
Ref:

<pre><code>`select a.AbsoluteMonth,Mon
,first_value(a.S1_pax)over(partition by a.v1_p order by num ) as S_Pax
,first_value(a.S2_pax)over(partition by a.v2_p order by num ) as S2_Pax`
from
(select *
,sum(case when S1_pax is null then 0 else 1 end) over (order by num) as v1_p 
,sum(case when S2_pax is null then 0 else 1 end) over (order by num) as v2_p
 from X_Table
)a
</code></pre></li>
</ol>

And fill all places respectively. Plz refer below output

<a href="https://i.stack.imgur.com/P8QCk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/P8QCk.png" alt="enter image description here"></a>

Can we repeat last value of a column in SSRS? As in attachment, all blank rows in 
the last column should be filled with the latest value 702

<a href="https://i.stack.imgur.com/Rsvbx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Rsvbx.png" alt="enter image description here"></a>

I used Previous, Last functions but nothing helped

Repeat last value of a column, when it is empty -SSRS

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我们能在SSRS中重复列的最后值吗？与附件一样，最后一列中的所有空行都应填充最新的值702。​​我使用了以前的，最后的函数，但没有任何帮助

问当列为空-SSRS时，重复列的最后一个值
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问当列为空-SSRS时，重复列的最后一个值EN