Thank you all for responding...

and thanks a lot for the suggestions provided

I solved using the following query

select s.date, s.salesno, sum(d.salesno)as sum11 from SALES s

INNER JOIN

SALES d ON s.date>=d.date group...

It's OK

I'm using Visual Studio (ssrs 2005)

Can I change anything in my browser or Reporting services configure manager or somewhere else in my project so that it may not ask...

Thanks a lot for responding

I got it in an easy way with the feature of IIS, and having everything set at default.

But, I'd like to know more about the credentials...

HI,

Thankyou for responding

I tried doing as you said. But, still it's asking me for Report Services Login.

First time, I didn't change anyhing, it had the default values for Targetdatasourcefolder as...

Hi,

Thank you for responding. Could you please provide some more details of how I can change the settings in my IE so that it mayn't ask for the credentials. Also,...

Hi,

Thanks a lot, I learnt a new concept here which I wasn't aware of

It's really helpful

Soma

Hi, thanks for the response

I'm new to the SSIS so,this solution seems pretty much brief and straight forward to me. I'm unaware of how to use script task. I understand...