Hi, i am very new to SSRS report. currently having some doubts some one guide me on this.
1. how to deploy reports into production server which can be accessible by different users in same network domain.
i tried to configured using SQL Server configuration manager and able to deploy into report server in my local PC and it's working but don't know how to configure which can be accessible from other PC from same network domain.
what service account i have to use?
2. how do i create subscription in SSRS report to store report in a share folder for each month or daily based on current year and month.
my report having two parameter one is year textbox and other is month(January,February etc) dropdownlist(which having multiple selection)
this is working if i am running the report based on parameter but in subscription , how do i set month dynamically(current month) and current year , so that based on current month and year the report will delivered to share folder.
Thanks
Bhuvanesh MohankumarPosted May 5, 2016, 4:00 AM
I suggest you to have a account which has the High privilege for the folder access [Full rights], always Admin access will be fine but most of the organization its not possible to get approved.
Deployment, I would suggest to use anyCVS, where to use TFS which is another product of Microsoft, where all folders are created and assemblies and files are checked in [Saved] to TFS.