Report from Olap cube

hi friends,

 i need create 2 datasets 1 r12 , ytd.

these both depend on 1 parameter currentperiod.

but parameter value in calculated member of measure. 

so question how make value default parameter value r12 , ytd after user can change currentperiod value.

iam thinking should pass calculated member value 1 variable , pass variable time filter.

can u guys plzz give basic idea on how that..

 

thank you.

sandeep.

 

hi sandeep,

of course make use of variable in report, if currentperiod return 1 record, you could give currentperiod datafield as parameter's default value directly, please make sure value date type, utilize cdate function in report convert type date.

for more information please see:

using report , group variables collections references (report builder 3.0 , ssrs), please see: http://msdn.microsoft.com/en-us/library/dd255208.aspx 

creating report parameters , setting report parameter properties http://msdn.microsoft.com/en-us/library/aa337234.aspx 

thanks,
challen fu

---

please remember mark replies answers if , unmark them if provide no help.

SQL Server  >  SQL Server Reporting Services, Power View