Thanks for the reply.

Finally solved the issue, The problem is with final destination table to which we are doing the inserts and updates.

There is a trigger on this destination...

I got the solution

here is what i did,

I have added the two images under project reports tab.

and the place where i want the images, I dragged the text box and...

I found the solution using the Switch function

For the desired columns which requires avg of the Column records.

Here is the Function Used:

=Switch(Fields!RevenueType.Value="Column11", Round(Avg(Fields!Amount.Value),2)

,Fields!RevenueType.Value="Column10" ,Round(Avg(Fields!Amount.Value),0)

,sum(Fields!Amount.Value))

Thank you

Thanks for the reply.

I didn't get you properly.

The problem i am having is, all the columns are populating dynamically in the Matrix report. So to find the Avg for a...

i created a table

CREATE TABLE [dbo].[a_temp](

[date] [date] NULL,

[batchid] [int] NULL,

[batchid1] [int] NULL

) ON [PRIMARY]

i inserted rows into the table using get date unction as

declare @i int;

set @i=0;

while(@i<=1000)

begin

insert into...

i created a table

CREATE TABLE [dbo].[a_temp](

[date] [date] NULL,

[batchid] [int] NULL,

[batchid1] [int] NULL

) ON [PRIMARY]

i inserted rows into the table using get date unction as

declare @i int;

set @i=0;

while(@i<=1000)

begin

insert into...

Thanks for the reply.

Could you tell me way hiw to register the dll files.

i tried to add the dll files in cmd prompt, but it showing some error like dll filecannot be added.

The same report solution is able to give proper preview in another system in which my colleague can able to preview the report.

When i access the same solution through Team...

Thanks for the reply Brandie,

In my local computer SSRS 2008 is installed properly.

I copied the references properly and added the references to the report layout.

in the RSPreviewPolicy.dll file code i...