Viewing 15 posts - 5,131 through 5,145 (of 6,395 total)
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
Yep it is. If you right click the database you wish to import into, then in the tasks menu you should see Import Data.
May 10, 2012 at 1:19 am
the only way to pause would be to add a WAITFOR DELAY into the stored proc. It would leave that SPID open so if its doing things inside a...
May 10, 2012 at 1:14 am
Yes, there are many different ways to do this. You have the Import/Export data wizard, bulk insert commands, bcp and SSIS.
If its going to be a 1 time thing...
May 10, 2012 at 1:10 am
durai nagarajan (5/9/2012)
The drives that you proposing can i know it deeply, we have a virtual server and base configuration i dont have if i ask them to add a...
May 9, 2012 at 8:24 am
Viewing 15 posts - 5,131 through 5,145 (of 6,395 total)