Viewing 15 posts - 1 through 15 (of 33 total)
There could be a few things going on here, but one thing that I see in your image is that you do not have "User Windows Credentials" checked. Without...
March 1, 2016 at 12:51 pm
One thing to make sure is to not schedule multiple subscriptions for the same report to run all at the same time. This could cause a series of issues...
March 1, 2016 at 12:39 pm
No problem. The users table is just a list, it does not maintain permissions, and deleting users will have no effect.
Security is actually managed through SQL. If you...
February 5, 2016 at 2:04 pm
Late answer but this table stores any user who has interacted with any reports on the reportserver. Anytime a new user accesses the reporting services web app, that user...
February 5, 2016 at 12:59 pm
Can you provide more detail then?
By studio v2008, do you mean SQL Server Management Studio? How long does it take in SSMS? What kind of data is it...
June 22, 2015 at 11:50 am
There is a timeout option in the dataset properties itself. When creating or editing it set it to 0 and you should be good. It's located on the...
June 19, 2015 at 12:47 pm
It really doesn't look like this query will work when you get to the next year.
My suggestion (without really knowing what/why you are doing your dates that way) is it...
August 2, 2012 at 7:35 am
Not that I know of for that specific yellow exclamation mark. What version are you running? R2, 2012?
However you can query the ReportServer.dbo.Subscription table for the last run status...
July 19, 2012 at 1:12 pm
Handling 500 subscription should not be a problem, just try not to schedule them all for the same time. You'll get SQL blocking along with the sudden stress of...
July 9, 2012 at 12:28 pm
Not sure on what you mean by moving on report to another SQL server.
RS has a web front end which accesses a ReportServer database. Both can be on different...
June 28, 2012 at 12:12 pm
When you run subscriptions at the same time, all those queries (from every dataset in every report) will be sent to your SQL server.
SQL server then runs all these queries...
June 28, 2012 at 12:01 pm
This would have to depend on the SQL populating the parameter list. If the query behind your parameter picks them up then you should be good to go.
January 10, 2012 at 10:24 am
As long as the format is static:
SELECT LEFT(PhoneNumber, 3) + '-' + SUBSTRING(PhoneNumber, 3, 3) + '-' + RIGHT(PhoneNumber, 4)
December 22, 2011 at 1:34 pm
How large are the pictures combined compared to how much space is on your PC? I think your just running out of memory or hard disk space.
My suggestion is...
October 7, 2011 at 9:03 am
Viewing 15 posts - 1 through 15 (of 33 total)