February 9, 2009 at 5:56 am
Can somebody help please ?
I've a dataset and display it with a matrix.
I've one row having this expression :
=FormatDateTime(Fields!CreationDateTime.Value, DateFormat.LongDate)
So one row will be displayed by creation date
And one column with this expression :
=Fields!PriorityLevel.Value
Priority can be Low, Medium or High
So, after rendering, the matrix will be displayed like this :
Low Medium High
lundi 2 février 2009 0 5 0
mardi 3 février 2009 0 7 0
mercredi 4 février 2009 0 8 1
jeudi 5 février 2009 7 8 3
vendredi 6 février 2009 0 36 0
lundi 9 février 2009 0 35 0
My problem : after hours, I still can't write my "Jump to URL" hyperlink.
Why the user will clic on 35 (Monday 9 Feb - Medium), I will only display these 35 records.
My URL is pretty long but see in bold : Visual Studio force me to use grouping function like FIRST but First() gives me the first date in my dataset. And not "Monday 9 Feb" as I will. I don't want the first date but the date displayed in my row label.
="void window.open('" + Globals!ReportServerUrl + "?%2fUniCenter%2fTicketsList&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=true&rc:parameters=true&Status=_Open&Priority=" + First(Fields!PriorityLevel.Value, "GetListIncidents") + "&TopValue=999999&AffectedUserOrganizationName=%&GroupName=" + Replace(Code.GroupName, " ", "+") + "&Assignee=%&IncidentArea=" + Replace(Code.IncidentArea, " ", "+") + "&CreationStartDate=" + First(Fields!OpenDateTime.Value, "GetListIncidents") + "&CreationEndDate=" + First(Fields!OpenDateTime.Value, "GetListIncidents") + "&FedComType=" + Parameters!FedComType.Value + "','_blank','location=1,resizable=yes,scrollbars=1,width=1024,height=854')"
Is there somebody can help ?
Thanks a lot !!!
Christophe
January 21, 2010 at 4:16 am
Use dummy parameters on url and pass this as default in main parameters on sub applications
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply