Hey,

It depends on how you're migrating the databases. If you are attaching them or restoring from backup they will still hold their collations. If you need to change them you...

Ah, yeah! Doh - I didn't even think of that as a possibility. Weird.

Glad you're sorted though 🙂

Thats handy Lowell, nice one. All options there for you OP

Hey,

This will do it BUT - You arent getting days in that.

DECLARE @hours decimal(15,4)

SELECT @hours = 28.75

SELECT RIGHT('00' + CONVERT(varchar(2),FLOOR(@hours)),2)

+':'

+ RIGHT('00' + CONVERT(varchar(2),FLOOR(((@hours-FLOOR(@hours))*60))),2)

+':'

+ RIGHT('00' + CONVERT(varchar(2),FLOOR(((@hours-FLOOR(@hours))*60)-FLOOR(((@hours-FLOOR(@hours))*60)))*60),2)

Here's...

Hey,

Without typing it out for you, have a look at this example. Same idea as what you need.

Thanks

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/36f70eed-68c7-4d0e-8967-aa366780c8b2

hey,

There is no built in way to achieve this. I suppose, if you could find the data location in the database you could switch it to required but god knows...

Did you just move the databases?

Does this admin account have access to the database engine?

Sounds like its only the BUILTIN\Administrators that have access. Try first adding your admin account to...

I'll have a wee search through that but check my post above - possible solution.

Cheers

Excellent. Glad to hear it 🙂

Check this out - see if that helps:

https://anindita9.wordpress.com/2011/12/15/troubleshooting-sql-server-2008-r2-reporting-services-report-manager-url-shows-500-internal-server-error-in-internet-explorer/

Hmm looks ok. Might actually be the RSReportServer.config file.

it should be one folder level up. Sorry

Ta

So its the Report Manager URl you are getting the error on?..

(IE. http://blahblah/Reports)

Have you tried the reportServer URL (looks like a basic FTP interface (text))

(IE. http://blahblah/ReportServer)

Any...

Could you post your web.config file? Did you have any existing datasource connections to Oracle databases in Report Manager, before upgrade?

ta

Hey,

Dont worry about it. Easy mistake to make. Try that out, or better yet, try the original method and let me know how you get on 🙂

Ah, just re-read your earlier post.

Are you changing the series data to add the ":1" or are you changing the data label expression? As the data label expression shouldnt affect...