thank you.. It worked.

Okay...like if the file has varchar data in a column which is supposed to be integer. Throws error while loading.

Right now, my only option is to create two tablix and display visibility based on rendering format.

My bad luck. I don't know whether the problem is with the attachment or with my machine...I am not able to download it. It says access denied. :ermm:

Hi Andrew,

Thank you so much for sharing your ideas. Unfortunately, I am not able to download the RDL. Could you please attach in here? I have visual studio 2008 version....

But don't have a row number field coming from the dataset. That's the problem..even if I create a custom row number in tablix, I can't use that in the aggregate...

I am not able to get the sample output

but here is the actual data

/* ACTUAL TABLE */

DECLARE @Actual TABLE (ReportDate date , DatabaseName varchar(10), ReportID int , TotalSum bigint )...

I am getting different values for DatabaseName, ReportID on same date.

I want to show both values. But pivot choose max value.

Possible to handle this?

It worked. Thank you so much.

Like Sean said, May be the guy was expecting the word 'SCHEMABINDING' from me.

Yes Lynn, I agree with you. But unfortunately I did not ask him what's the error...

I told him in the first place that we don't have permission to drop.

The guy had told me clearly that we have permission to drop too.

Then the answer I gave...

I don't understand. On what basis we should make it hidden? Based on Row Number() to find the duplicates?

Yes Luis. I tried Grouping the columns and it shows same values for each RequestID but I want to show one time. Not three times for each RequestID.

That's where...

The column starting from "ReqestID" to the end should display 3 rows (1,2,3)...

The column starting from "Sender" to "FailedCardGroups" should display one row ...since this row will occur 3 times...

Hi Igor,

I want to do this in RDL. I can't use this SQL query. And SP is used in the Dataset.