Report Parameters in Report Header

[Michael Hurse]

Hi

I have seem this thread from early 2009:

http://www.telerik.com/community/forums/reporting/telerik-reporting/print-parameters-on-report.aspx 

It indicates that it is not possible to trap the parameters and show them in a report at runtime. To relate this to my situation, I have a report which is being used as the basis of billing for services. Billing is conducted for different date ranges so I have start and end date parameters in my report. Finance have asked me to include these dates in the report so clients can see the billing period. Unless I have misinterpreted the response in the attached thread and if nothing has changed in the interim, am I right in saying there is no way I can capture these two parameters and include them in my report?

thx

Michael

[Steve]

Hi Michael,

As outlined in the Using Report Parameters in Expressions help article, Report Parameters can be used in expressions that you display in a report directly or can also be used with other elements in a more complex expression. So the answer to your question is yes, you can display the selected parameter values in your report by using the Report Parameters node in the Expression Editor that lists the available parameters i.e. the following expression in TextBox item: = Parameters.MyReportParam.Value.

Sincerely yours,
Steve
the Telerik team

[NPL IT]

I believe this is incorrect.  I can display report parameters within a field or table in the report body.  This does not work for me the page header.  

[Todor]

Hi Drew,

The Report Parameters may be used anywhere in the Report, including Page sections.

Can you specify the Expression that is not working in the Page Header?

You may send us a sample report demonstrating the problem for local investigation in a support ticket as well.

[Michael Hurse]

Thanks Steve - that is fantastic!

kind regards

Michael

[Satish]

HI,

            I want to display report header along with filtered date range.I tried but i didn't find any solution.

for example say report header is "skill" and filtered date range is "21-jul-2011 to 21-jul-2012",then the header should display like this
    "skill:21-jul2011 - 21-jul-2012" .


with regards,
sateesh

[Steve]

Hello sateesh,

Then you need a TextBox item in the report header with the following Expression:

= "skill:" + Parameters.StartDate.Value + "-" + Parameters.EndDate.Value 

All the best,
Steve
the Telerik team

[Satish]

HI Steve,
                Thanks for your reply now its working fine.

[Satish]

HI

         I want to display report header along with filtered date range.I tried but i didn't find any solution.

for example say report header is "skill" and filtered date range is "21-jul-2011 to 21-jul-2012",then the header should display like this
    "skill: 2011/20-2012/20" . That "20" indicates week of the year. Is this achiveable

[Steve]

Hello Satish,

You can create an User Function that returns the week of the year by using the GetWeekOfYear Method. You would use the DateTime report parameter value as first argument of this method.

Regards,
Steve
the Telerik team

[Andrew Angell]

Old thread but thought I'd post anyway since a search did not show this.

We use this on our reports.

=Format('{0}:', Parameters.purchaseOrderStatus.Text)+Format('{0}', Parameters.purchaseOrderStatus.Label)

Text is the property you enter when creating the parameter and appears at the top of the report viewer.
Label is the readable value (for instance a dropdown item), rather than the numeric representation of such.