what is your expression to work out the start time and end time based on the execution time field?

use the execution time builtin field which is in the report data toolbox of BIDS or report builder.

to get the time in hh:mm:ss you will need to do a variable...

look at the executionlog view in the reportserver database joined to the catalog table on the report guids to get the names of the reports.

Brandie Tarvin (5/11/2012)

---

I find it amusing that this is the only time that having multiple points of failure is a good thing.

Of course, I'm not really sure you should have...

should be a good starting point

http://msdn.microsoft.com/en-us/library/ms141724.aspx

the related tasks go into how to setup and configure the loop

what level of rights does the account have which is backing up the database?

restricted user only allows members of sysadmin/dbcreator/db_owner roles to connect to the database, so if the account...

no the only way to store a date in any other format than yyyy-mm-ddThh:mm:ss.ms is to store it as a string based data type, otherwise it is convert it...

there was an article posted this week in relation to RegEx for DBA's, it can be found here[/url]

The datetime datatype only stores values in yyyy-mm-ddThh:mm:ss.ms format. I would leave it as this and do the formatting into dd/mm/yyyy in the application or in the calling stored...

vinu512 (5/11/2012)

---

anthony.green (5/11/2012)

---

this will do the job with the sample data provided, but if you dont know the logic then we can only guess at what you want and how...

switch on remote errors then run the report again, this will give you a more detailed error

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...

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...

this will do the job with the sample data provided, but if you dont know the logic then we can only guess at what you want and how it should...

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...