Viewing 15 posts - 5,131 through 5,145 (of 6,400 total)
the data source may not nessesarily be in the data source folder. when you set the target url for the report solution deployment you can also set the folder...
May 11, 2012 at 1:26 am
Personally I would backup to a local drive and mirror the backup to the network, that way you have multiple points of failure to the bak/trn files incase you have...
May 11, 2012 at 1:20 am
yes it is the rdl.data file.
I have just done a google as I thought best see if it can be turned off and it can.
32bit computer
C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\rsreportdesigner.config
64bit...
May 10, 2012 at 8:41 am
It cache's the data in a data file within the solution so it doesnt have to hit the DB every time the report is run in BIDS.
Usually I just delete...
May 10, 2012 at 8:32 am
are you looking at the correct reportserver DB to where the reports are stored, need to check via the ssrs configuration manager, as the only way an entry would remove...
May 10, 2012 at 5:54 am
have you done about:config in firefox and searched for network.automatic-ntlm-auth.trusted-uris and edited it to include the URL of your reporting server?
May 10, 2012 at 5:21 am
Does this do what you want?
SELECT
MAX(EL.TimeEnd)
,C.Name
FROM
ReportServer.dbo.ExecutionLog EL
INNER JOIN
ReportServer.dbo.Catalog C
ON
EL.ReportID = C.ItemID
GROUP BY
C.Name
May 10, 2012 at 4:50 am
this will get you what you want and a bit extra
its the data set for the ReportStatistics rdl which is ued in that diagnostic SSRS package I provided the link...
May 10, 2012 at 4:25 am
also this may help as well http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/
May 10, 2012 at 4:13 am
if its a date time column could you not just do
select CONVERT(varchar,getdate(),10)
May 10, 2012 at 2:18 am
Doh, thanks John, I have my 2008 head on and totally forgot I was in the 2005 forum, my bad.
May 10, 2012 at 1:49 am
An exact translations would be something like this, just need to replace ..... in the variables with the data types of the fields. Also your not using BARCODE in...
May 10, 2012 at 1:48 am
If you can look at filestream for storing blob data outside of the DB.
May 10, 2012 at 1:36 am
Not to worry, it is quite a hidden option in all fairness. If you ever need to do anything a bit more complex or frequent I would look at...
May 10, 2012 at 1:34 am
Viewing 15 posts - 5,131 through 5,145 (of 6,400 total)