current date parameter
I have created a report in SSRS based on my analysis Cube. At the moment the report's parameter is defaulted to december in each of the datasets. So wehen I run my report It shows me data up to the end of december. The value in the report parameter properties within the deault section is [Time].[Fiscal Dates].[Fiscal Month].&[2010-12-01T00:00:00] My question is... is there a way I can change the default for the parameter so that it shows the report from the current date? Many Thanks
April 28th, 2011 9:12pm

Please try setting the default value expression as given below =Format(System.DateTime.Today ,"yyyy-MM-dd") & "T00:00:00" Hope this helps Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
Free Windows Admin Tool Kit Click here and download it now
April 28th, 2011 11:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics