SSRS:快照运行时?
我有一个 SSRS 报告,它是快照或其他报告。它每天早上 6 点运行。我想在报告(快照)顶部添加一个标题,指示快照的拍摄时间,以便用户知道快照的拍摄时间。
有谁知道我该怎么做?
I have a SSRS report which is the snapshot or another report. It runs every day @ 6 am. I want to add a header at the top of the report(snapshot), which indicates when the snapshot was taken so that the user knows when the snapshot was taken.
Does anyone know how can i do that?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
如果我真正理解您的问题:
您可以通过在标题上添加文本框来添加报告处理的日期或时间,并将此表达式写入其值:
或
if I truly understand your question :
you can add date or time of report processing by adding a textbox on header and write this expression as its value :
or
通常,您会使用 Globals!ExecutionTime 来显示它,但根据我的研究,页眉和页脚是在呈现报表时计算的。解决此问题的方法是将带有 Globals!ExecutionTime 的文本框(使其隐藏)放置在报表正文上,然后在页眉或页脚中放置另一个引用该文本框的文本框,如下所示:ReportItems!ReportBodyTextBoxName.价值。
在以下站点找到答案:
http://www.manning-sandbox.com /message.jspa?messageID=52186
Ususally you would use Globals!ExecutionTime to display this, but from my research, headers and footers are calculated when the report is rendered. A work around for this is to place the textbox (make it hidden) with Globals!ExecutionTime in it on the report body and then place another textbox in the header or footer which references that textbox like this: ReportItems!ReportBodyTextBoxName.Value.
Answer found on the following site:
http://www.manning-sandbox.com/message.jspa?messageID=52186
对我来说最好的方法是在我的数据集中添加一个额外的列。例如:
如果表达式位于标头中,则可以使用
First(Fields!EXEC_DAT.Value, "DATASET_NAME")
。PS:SYSDATE 适用于 Oracle,您必须确定适合您的 RDBMS 的正确函数
The best way for me was to add an extra column to my dataset. e.g.:
You can then use
First(Fields!EXEC_DAT.Value, "DATASET_NAME")
if the expression is in the header.PS: SYSDATE works for Oracle, you'll have to determine the correct function for your RDBMS