Can you share some codes or steps?

It will be very helpful for us...

It should not ask user name and password to view the reports.

Thanks its working fine.

I need to load the data from excel file assume that its contains two columns. Excel file name contains the period is like "M0209". So file name...

For Flat file connection its working file. If suppose my source is excel file, what are all changes i need to do.

Thanks

Dhamodharan P

Thanks Hari. Its working fine.

But things is initially we need to specify the file name then only we can go to the properties and change the connection string as...

Hi Hari..

I need some clarification in SSIS.

How to get the Source file name from table for Data flow Taks?

I want to load the data from one CSV file. But file...

I am using SQL 2005.

Thanks

Dhamodharan P

Thanks Hari.

I have one more doubt.

While I clicking the Department name, the subreport will open in different page. Instead of this, the Subreport should in the same page..

Like below

-----------------

List...

While running the reports, it ask the parameter value. but this should taken from department name which user click. how to do this?

Hi Niraj.

I understood what you are saying.

Could you please explain how to do this?

While Clicking the particular department how to pass that depart name to another report (Subreport)?

Thanks

Dhamodharan...

Thanks. Actually i am new into Reporting services.

While I am clicking the departname, then only the subreoprt will show in the same report page.

Is it possible correct?