October 11, 2009 at 6:45 pm
Hello,
how can I display the specific parameters I chose on the report? For example, If I use a date range, I would like it to be diplayed on the report.
October 12, 2009 at 3:28 am
If you are using Reporting Services, you can just add a textbox and write an expression like the following:
"Start Date:" + Parameters!StartDate.Value.ToString() + " " +
" End Date:" + Parameters!EndDate.Value.ToString()
If you what to format the data just use: FORMAT(Parameters!EndDate.Value, "dd-MMM-yyyy")
October 12, 2009 at 3:29 am
If you are using Reporting Services, you can just add a textbox and write an expression like the following:
"Start Date:" + Parameters!StartDate.Value.ToString() + " " +
" End Date:" + Parameters!EndDate.Value.ToString()
If you what to format the date just use: FORMAT(Parameters!EndDate.Value, "dd-MMM-yyyy")
October 12, 2009 at 6:14 am
If you have a multi-select parameter and
want the users to see what they picked (very
useful in troubleshooting) then check out the JOIN
syntax in the expression editor...it will parse the
selected values for you in a string, and you can separate
with commas or whatever.
October 12, 2009 at 6:39 pm
OK...if I just want the date to return as 10/9/2009, how do I do that? I used the start date in one text box and the end date in another, in hopes that I could format them seperately....is that the right approach?
October 13, 2009 at 12:06 am
Just change the format string in the FORMAT function to :
FORMAT(Parameters!EndDate.Value,"MM/dd/yyyy")
or whichever order you want the year, month, day displayed.
It doesn't not matter if you use two textboxes, you can still format each date separately in one textbox. But it is really whatever is easier, as the user will not know! Make sure the two textboxes don't overlap so the contents are displayed to the users correctly.
October 14, 2009 at 2:22 am
Go to report properties. Under Misc group set Language property
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply