I have a dataset for monthly view for forecast and completed for whole month Jan to Dec

but cummulative graph for complete I need to show only till this month. so...

Thanks guys

Page Break is for items in same report , I am talking about multiple reports in a project into an excel spreadsheet in different ( with custom tab names...

Can some one explain how to do it in SSRS please ( any link of doc etc... )

Great Stuff works Perfectly fine. Many thanks!!

Hi Thanks

@[User::Variable] = "/pub/Cell_Availability/" + (DT_WSTR, 4) YEAR( GETDATE() ) + "-" + right("0" + (DT_WSTR,2) DATEPART("mm", GETDATE() ), 2) + "-" + right("0" + (DT_WSTR, 2) DAY( GETDATE()...

Sorry new to ssis

/pub/Cell_Availability/ + (DT_WSTR, 4) YEAR( GETDATE() ) + - + right("0" + (DT_WSTR,2) DATEPART("mm", GETDATE() ), 2) + - + right("0" + (DT_WSTR, 2) DAY( GETDATE()...

Thanks for prompt reply

/pub/Cell_Availability/2012-04-04

this is the path

so in remote path variable

/pub/Cell_Availability/ + (DT_WSTR, 4) YEAR( GETDATE() ) + right("0" + (DT_WSTR,2) DATEPART("mm", GETDATE() ), 2) + right("0" +...