Thanks for your response, Is there anything that I could have done in the restore command to have the Database available faster, I mean not to move forward with undo...

Below is the statement...

RESTORE DATABASE DBNAME

FROM DISK = 'L:\SQL_Restore\dbbak.BAK'

WITH

STATS = 10,-- Show progress (every 10%)

MOVE 'DBNAME' TO 'P:\Data01\db_data_file.mdf',

MOVE 'DBNAME_log' TO 'P:\Logs01\db_data_file.ldf'

I just made it simple by removing extra Str converstions and made the report parameter as string and it worked

SET [FISCAL WK NBR] AS

{

[DIM TIME].[FISC YR WK NBR].[FISC YR...

I would suggest to have the Reporting services installed seperatley, because RS needs IIS Enabled and for security reasons its not a good idea to have SQL and IIS running...

Yes i did but it does not seem to work....

Thanks for your reply Steve, I tried your change but still no luck, Getting the same error, I also changed the parameter type to String (from integer) and just have...