· Hi,Hi Sorry, I've posted this issue in SQL Server Analysis Services forum unknowingly though this issue is more related to SSRS Reports. The analysis services thread is http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/a4608fdc-3f2f-421f-9a79-556a31df124a It would be really helpful if someone could help me out with this. Thanks. Shankar

Hi SankarBS, According to your description, you would like to pass FromDate as a parameter to drill through report, the drill through report calculate count for the whole month, and the parameter used in drill through report was not the same as main report, right? If in this case, I think you pass FromDate as parameter to the drill through report is right. After we pass the parameter to the drill through report, we can calculate for the whole month through the dataset which is provided data for the drill through report using the year and month get from parameter that was came from main report. For more information about how to pass parameter to another report, please refer to the following article, Using Parameters to Connect to Other Reports: http://msdn.microsoft.com/en-us/library/aa337167(v=SQL.100).aspx Hope that helps you. Thanks, Eileen