I think this is just BIDS trying to wind me up, and succeding. :angry:

Deployed the report the server, run it, all its all fine, no padding, the row isn't expanding....

Doh, of course, I knew it would of been something simple I was missing.

the columns where converted into NUMERIC and DECIMAL using CONVERT, please see my first post

converting them to FLOAT has solved the issue

Thanks Edward, totally appreciate that, I would of still expected SQL to come back with 4 and not 4.34

this is a CTE declaration

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

we get this from time to time, its usually down to locking, this has now gone away 99% of the time due to better indexes speeding up the queries so...

http://www.microsoft.com/learning/en/us/certification/exam-policies.aspx#revoke

Tab2 - NDA

Using unauthorized materials in an attempt to satisfy Exam requirements (this includes using brain-dump[/u] material and/or unauthorized publication of Exam questions with or without answers)

you could of installed a new instance of SSRS without uninstalling, but then you would have to do the following

http://hostname/reports_instancename

unless you created a host header record in DNS and...

Yeah, I cant help you on Progress, never touched it.

Have you tried here

http://www.datadirect.com/product-downloads/connect64-odbcwin.html or even just the root, they seem to have a host of drivers

yeah, you should see that option, its on the very first screen before you have clicked anything.

if you dont mind me asking, what DB provider are you linking to and...

what is your Sybase database running on ASE or ASA(SQLAnywhere), as you cant cross the two drivers over on to different platforms as we have been told by Sybase support...

did you select the x86 processor type from the options section of the initial splash screen for the install of SSRS

can you not create the system DSN via c:\windows\syswow64\odbcad32.exe and...

well I have to say I did not know that, only experience I have with express is the install of VS2010 when it creates a SQLEXPRESS instance, other than that...

If you dont specifiy an instance on the installation the default instance for express will be SQLEXPRESS, so unless...

SQL express installs an instance (HOSTNAME\SQLEXPRESS), or if you set it up will create instances based on users.

You will need to find the port which the instance is using and...