I have a Specific Merchant report in SSRS and it sent out to different merchants everyday at 8am. But the Problem is they want to receive the report only if they have Transactions on it(Contains Data) They don't want to receive it if the report is empty.
我在SSRS中有一份特定商家报告,并且每天早上8点发送给不同的商家。但问题是他们只有在有报告的情况下才会收到报告(包含数据)如果报告为空,他们不想收到报告。
Is there a way to restrict that in SSSRS? Please let me know.
有没有办法在SSSRS中限制它?请告诉我。
2 个解决方案
#1
4
Take a look at data driven subscriptions. They've been around since SQL Server 2005 and are pretty useful for this kind of thing. Without knowing more about your scenario, I can't explain exactly how it'll work, but I'm certain it can. Check out here for more details: http://msdn.microsoft.com/en-us/library/ms169673.aspx
看看数据驱动的订阅。它们自SQL Server 2005以来一直存在,并且对于这种事情非常有用。如果不了解您的场景,我无法准确解释它的工作原理,但我确信它可以。有关更多详细信息,请访问此处:http://msdn.microsoft.com/en-us/library/ms169673.aspx
#2
0
SSRS subscriptions are pretty basic - either you are subscribed to receive a report or you are not. If you want/need to add logic to that you'll need to roll your own using a console application that you can run as a scheduled task and the reporting services API.
SSRS订阅非常基本 - 要么您订阅了报告,要么您没有。如果您希望/需要添加逻辑,则需要使用可以作为计划任务和报告服务API运行的控制台应用程序来自行创建逻辑。
#1
4
Take a look at data driven subscriptions. They've been around since SQL Server 2005 and are pretty useful for this kind of thing. Without knowing more about your scenario, I can't explain exactly how it'll work, but I'm certain it can. Check out here for more details: http://msdn.microsoft.com/en-us/library/ms169673.aspx
看看数据驱动的订阅。它们自SQL Server 2005以来一直存在,并且对于这种事情非常有用。如果不了解您的场景,我无法准确解释它的工作原理,但我确信它可以。有关更多详细信息,请访问此处:http://msdn.microsoft.com/en-us/library/ms169673.aspx
#2
0
SSRS subscriptions are pretty basic - either you are subscribed to receive a report or you are not. If you want/need to add logic to that you'll need to roll your own using a console application that you can run as a scheduled task and the reporting services API.
SSRS订阅非常基本 - 要么您订阅了报告,要么您没有。如果您希望/需要添加逻辑,则需要使用可以作为计划任务和报告服务API运行的控制台应用程序来自行创建逻辑。