There is no change in the visibility setting, i can see the report data in report builder, also email shows data when I manually push the subscription, instead of subscription.

Thanks

I am passing parameters from the data drive subscription to the report.

Yes, Report has default parameters which I am getting from from a query. Please check the image.

https://drive.google.com/a/pscnow.com/file/d/0B1Q0SOyhD8EZMXNqNlN1dkg3REU/view?usp=sharing

Thanks for your reply.

I don't know how to put the actual data according to my scenario , but i can say how in general data is repeating for one columns...

But when run with my actual data i get two columns for 13 month and again 13 months is repeated for third column .

What do you think the reason can...

DROP TABLE #Test

CREATE Table #test

(

[Date] datetime,Name VARCHAR(50),[Percent] decimal(8,4)

)

INSERT INTO #TEST

SELECT 7/1/2010, 'Medicaid', 2.1672

INSERT INTO #TEST

SELECT 7/1/2010 ,'Medicare' ,78.3515

INSERT INTO #TEST

SELECT 7/1/2010, 'Commercial', 19.4813

INSERT INTO #TEST

SELECT 8/1/2010, 'Medicaid'...

This following is the data which i am trying to pivot .

I have 39 rows upon pivoting it should return 13 rows but its returning 26 rows.

I am pivoting on...

Anybody please help !