How to deliver a report dynamically based on the dataset with standard edition?

alexuwang

Hi All,

I am working on a report which displays profit and loss discrepancy between two systems. So if there is discrepancy, in other words, the dataset returns value, then I want reporting serive to deliever the report to intended users. I am currently using standard edition with no data-driven subscription support.

I do not know what is the workaround for this implementation. Tks for advise in advance.

Alex

Teo Lachev


Sounds like you need a custom application to check the condition. You can use the RS FireEvent API to trigger the subscribed delivery.

alexuwang

Tks for your reply. Can we also render report inside SSIS, then send out to users Not sure if that is possible.

Alex

Teo Lachev

I don't see a reason why this shouldn't work. You can write a script task to call down to the SSRS web service and request the report by invoking the Render method.

alexuwang

Great, thanks for your answer.

Also, I have another issue with ReportingService2005.FireEvent API, whenever it gets called, the system threw an exception said "insufficient permission for performing this operation". No idea how to fix it. Thanks in advance.

Sample Code:

rs.FireEvent("TimedSubscription", SubID);

Alex

Teo Lachev

I don't know why it won't work if you are executing the call as a local admin on your local machine where SSRS is installed. If not, does it work if you add the the Windows identity the call is going under to the local Administrators group If so, you need grant that user System Admin rights in the Report Manager.

alexuwang

Hi,

I found the answer that by default "Generate event" permission is not granted to anyone. You have to go to report manager, security section to check this item. Tks.

Alex