September 22, 2010 at 7:49 am
Hi,
We are using SQL reporting serivces 2000 in our system. This is deployed in WIndows Server 2003 R2 and works fine when we run the reports manually. i want to Automatrically scheduled the report to save our report in file sahre. i tried Subscriptions giving all the details required but the subscription is not initiating and not saving any file. No errors in event viewer exither in report serbver or SQL server Please help. Below shows the subscription page. Am i missing any settings whioch need to be included
Report Description Folder Trigger Last Run Status
Case Save in \\35.96.8.31\test as Cas /Message Hub Reports TimedSubscription New Subscription
September 23, 2010 at 10:55 am
Make certain that the user that you are connecting with has the appropriate rights on the share. That user needs modify or above on the share and write or above on the NTFS permissions for the folder.
-Luke.
September 24, 2010 at 2:27 am
Yes... Using the Doamin level account which has all the permissions required. Even Eventviewer doesn't show any errors. Any help?
September 24, 2010 at 6:10 am
September 29, 2010 at 6:11 am
Yes... Able to fix the issue. Job was failing due to server access. Need one more help. I have set the parameter but when i set the subscription on default parameters there is no output coming.
September 29, 2010 at 6:29 am
did the same parameter giving result in the manual report execution?
Thanks,
Veeren.
Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉
September 29, 2010 at 6:31 am
Yes....
September 29, 2010 at 6:36 am
oh...i belive that the subcription has issues with the report parameter if you are able to get the o/p with out any parameter!
No idea in 2000.we can go for linked reports.
thanks,
veeren.:)
Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply