Viewing 15 posts - 16 through 30 (of 33 total)
Just noticed both your posts on this. Please see here for a resolution:
http://www.sqlservercentral.com/Forums/Topic1181842-1063-1.aspx
September 28, 2011 at 6:50 am
I had this problem a while back and the answer was to remove the header from the report. I was going to link the source I got the information...
September 28, 2011 at 6:48 am
The ReportServer.dbo.ConfigurationInfo has a value called "SystemReportTimeout" that by default is set to 30 minutes I believe. This should be what your looking for.
September 8, 2011 at 8:28 am
I suggest using a summary report first that contains a list off all the employees general information, then make the employee name a drill through to a detailed report that...
September 8, 2011 at 8:19 am
Not sure if this will work, but it's worth a shot:
Go to your properties box and click the drop down with all your report items in it.
Select "Report"
Go to the...
August 2, 2011 at 6:08 am
Daniel Bowlin (7/13/2011)
Oops....differences between TSQL & SSRS expressions.Here try this
--DateStart
=DATEADD("ww",-3,DATEADD("d",-(WeekDay(Today())) + 1, Today()))
--DateEnd
=DATEADD("ww",-3,DATEADD("d",-(WeekDay(Today())) + 1, Today()))
That did it Daniel! Expression logic seems quirky to me.
Just FYI, date end should...
July 13, 2011 at 11:04 am
Daniel Bowlin (7/13/2011)
Using your SQL, in SSRS:
--DateStart
SELECT DATEADD("ww", DATEDIFF("ww", 6, DATEADD("ww", -3, GETDATE())), 6)
--DateEnd
SELECT DATEADD("ww", DATEDIFF("ww", 6, DATEADD("ww", -2, GETDATE())), 6)
Thanks for your response Daniel.
"ww" is the same thing as...
July 13, 2011 at 7:26 am
Everything you need is in the Subscriptions table:
SELECT
C.Name
,C.Path
,S.LastRunTime
,U.UserName AS UserCreated
,CONVERT(NVARCHAR(MAX), CONVERT(XML, S.[Parameters]).query('data(/ParameterValues)'))AS [Parameters]
FROM ReportServer.dbo.Catalog C
INNER JOIN ReportServer.dbo.Subscriptions S
ON C.ItemID = S.Report_OID
INNER JOIN ReportServer.dbo.Users U
ON S.OwnerID = U.UserID
June 14, 2011 at 8:19 am
Click on "Show Details" in 2008 or "Details View" in R2.
Place a check mark in whatever folders you would like to remove and click delete.
The folders are not stored physically,...
June 9, 2011 at 10:53 am
I don't know of any, but I just run this on the report server:
SELECT
C.Name
,C.Path
,U.UserName
,S.InactiveFlags
,S.LastRunTime
FROM ReportServer.dbo.Subscriptions S
INNER JOIN ReportServer.dbo.Catalog C
ON S.Report_OID = C.ItemID
INNER JOIN ReportServer.dbo.Users U
ON S.OwnerID = U.UserID
WHERE InactiveFlags...
June 2, 2011 at 2:02 pm
Thanks sdvoranchik, with your help and a little SQL manipulation I was able to get this to work.
Your response was much appreciated.
May 31, 2011 at 11:00 am
For multi-value drop downs I insist on using ID's as my data value. If I don't have an ID to work with in my data I create my own...
May 26, 2011 at 1:45 pm
Sorry its taken me so long to get back to you.
In the top right of visual studio you'll have your solution explorer with your project in it. In your...
May 24, 2011 at 6:31 am
This should help you out:
http://stackoverflow.com/questions/751762/slow-startup-of-sql-reporting-services-2008-in-native-mode
I'm not sure of the purpose or technology behind it, but it goes into a sort of sleep mode if not accessed withing 20...
May 20, 2011 at 8:36 am
Viewing 15 posts - 16 through 30 (of 33 total)