I'm learning how to use Microsoft SQL server report builder 3.0. I know there is a function in the report called autorefresh. It works when I simply run the report within the report builder. I'm thinking can it still be refreshed after the report is exported.
我正在学习如何使用Microsoft SQL Server报表生成器3.0。我知道报告中有一个名为autorefresh的函数。当我在报表生成器中运行报表时,它可以正常工作。我想在导出报告后仍然可以刷新它。
Another question may related to this autorefresh functionality. When I add dataset into report builder, does it actually load the data into report builder or set up a link between report builder and database? If it sets up a link does that mean when I change something in database, it will reflect on my report builder after I refresh it.
另一个问题可能与此自动刷新功能有关。当我将数据集添加到报表生成器时,它是否实际将数据加载到报表生成器或在报表生成器和数据库之间建立链接?如果它设置了一个链接,这意味着当我在数据库中更改某些内容时,它会在我刷新后反映在我的报表生成器上。
All I want to do is keep the report up to date even after I export it.
我想做的就是在导出报告后保持报告的最新状态。
Really keen to know the answer.
真的很想知道答案。
Thanks in advance.
提前致谢。
1 个解决方案
#1
Make properties visible(View Tab > Check Box View)
使属性可见(查看选项卡>复选框视图)
Then navigate to report properties(Click on blue space around page). It should say Report in bold at the top of properties.
然后导航到报告属性(单击页面周围的蓝色空间)。它应该在属性顶部以粗体显示。
Expand the Other list and AutoRefresh is the first one.
展开其他列表,AutoRefresh是第一个。
It's by default set to 0. It's measured in seconds so changing it to 30 will make your report refresh every 30 seconds.
它默认设置为0.它以秒为单位测量,因此将其更改为30将使报告每30秒刷新一次。
Just so you know, you'll find that even though reportBuilder is the new SSRS(BIDS), it's still very, very similar. So don't feel like you need to always only look at Report Builder only. SSRS tutorials and other facts will be either identical or similar enough to figure it out.
你知道,即使reportBuilder是新的SSRS(BIDS),它仍然非常非常相似。因此,您不需要始终只查看报表生成器。 SSRS教程和其他事实将相同或相似,足以弄明白。
#1
Make properties visible(View Tab > Check Box View)
使属性可见(查看选项卡>复选框视图)
Then navigate to report properties(Click on blue space around page). It should say Report in bold at the top of properties.
然后导航到报告属性(单击页面周围的蓝色空间)。它应该在属性顶部以粗体显示。
Expand the Other list and AutoRefresh is the first one.
展开其他列表,AutoRefresh是第一个。
It's by default set to 0. It's measured in seconds so changing it to 30 will make your report refresh every 30 seconds.
它默认设置为0.它以秒为单位测量,因此将其更改为30将使报告每30秒刷新一次。
Just so you know, you'll find that even though reportBuilder is the new SSRS(BIDS), it's still very, very similar. So don't feel like you need to always only look at Report Builder only. SSRS tutorials and other facts will be either identical or similar enough to figure it out.
你知道,即使reportBuilder是新的SSRS(BIDS),它仍然非常非常相似。因此,您不需要始终只查看报表生成器。 SSRS教程和其他事实将相同或相似,足以弄明白。