Nope. I now get an error:

Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.

Ok here the whole thing.

EXEC sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

EXEC...

They are reports not subreports. I would navigate to them through server interface

Hi I seem to be getting it all wrong. Please see attached images of the report I'm getting with inscope

Hi Thanks for the feedback

I tried your sugestion but I'm still not winning.

---HC_CAT1 --Column Consolidate --- Row

=iif(InScope("Matrix1_HC_CAT1"), Fields!HC_CAT1.Value, Nothing)

=iif(InScope("Matrix1_Consolidate"), Fields!HC_CAT1.Value, Nothing)

This is the query I'm using...

Actually the reason I was getting no results was because of the data. Data for priod 200812 was not encrypted properly and as a result could not be decrypted for...

Thanks Bruce but this one has yielded the desired results except for the Grand total which gives me a...

Hi Carolyn

Thanks for the help I will try it out. as I had already managed to drumm up something like this

=IiF((ABS(Fields!Terminations.Value) + ABS(Fields!TransferOut.Value) + ABS(Fields!HeadcountEnd.Value))=0,0,Round((ABS(Fields!Terminations.Value) + ABS(Fields!TransferOut.Value))/(ABS(Fields!Terminations.Value) + ABS(Fields!TransferOut.Value)+ ABS(Fields!HeadcountEnd.Value))*100,2))

and...

Hi! Gail

Thanks a million. That's exactly what I needed.

Yes I used a symmetric key.

This is the allstaff table which is not encrypted.

CREATE TABLE ALLSTAFF(

Co float NULL,

CoName varchar(255) ,

Department varchar(255),

Dept varchar(255),

EmplID float NULL,

PayGroup varchar(255),

Grade varchar(255),

TotalPack Float NULL,

Age float NULL,

Initials...

On a monthly basis I import data from another department and bring it to the data mart. So it is then required of me to make sure that certain fields...

I still get an error:

Msg 8116, Level 16, State 1, Line 4

Argument data type float is invalid for argument 1 of DecryptByKey function.

Yes the symmetric key is open. The error I'm getting is:

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near '('.

and when I remove the decryption code and run...

Thanks Jack

You can recreate the table with a select statement.

SELECT AreaID, RegionID, '' as NewField,Area, AreaCode

Into Areas_Modified

FROM Areas

But then...

OK.

User tables are those tables you create on the database.

Now if you type the following query then you will get a list of all user tables on the database:

Select *

From...