SSRS Report Parameters

DineshMurali

Hi,

I have created two parameters as StartDateTime and EndtDateTime and i am displaying in the Page Header section in the Report as

"Report Duration from " & Parameters!DimActivityStartDatetime.Value & " to " & Parameters!DimActivityEndDatetime.Value"

It is displaying at the runtime in the report like

Report Duration from [DimAct].[StartDateTime].&[2007-03-10TO7:30:00] to [DimAct].[EndDateTime].&[2007-03-10TO7:30:00].

But i need to display only the dates. is is displaying with the dimension name also.

Is there any solution to solve this, can anybody help me on this

Thanks

Dinesh

sluggy

You will have to chop it up manually yourself. This will be very easy to do in a custom function in the code section of the report. The &[ characters are constant across all members of the heirarchy, as is the TO prefixing the time section. So you can either Split() the string based on those, or SubStr() it, whichever you prefer. Then perform a Format(CDate(yourDateString), "your format code"). Easy as pie

DineshMurali

Hi,

Is there any better way to do this insteead of Spliting.

Thanks

Dinesh

Adam Tappis - IMGroup

In my time dimensions I always add the actual date as an attibute of the day level. I then have it available in the MDX.

This really depends on how you use these parameters and how you present them to the user.

You could always use Parameter!StartDate.Label instead of .Value

DineshMurali

Hi,

Thanks.

I have used 'Lable' instead of 'Value'. I got the expected result

Thanks

Dinesh