Saturday, February 25, 2012

Parameters & reporting model

Hi,

I have created a reporting model.

When i use this model to create a report, all goes well.

But now i want to add date parameters (from ... to) to this report.

When i add my parameters in my reporting parameters (i use visual studio to create my reports)

i get the calender to select a from and to date.

but when i generate my report, i get the whole date range available in my database (so the parameters

are not used).

I tried to create a filter in my dataset, but there i cannot specify the parameters i created (error : from is not a date. i also tried @.From but that doesn't work either)

anybody have an idea how i can add parameters ? but it must be based on reporting model.

Vincent

Follow the following steps to achive this:

1. open the report.

2. click on data tab, edit selected dataset

3. click on parameter tab.

4. give the propername of parameter. and select the declared report parameter in value column.

5. then click on filter tab, select the desire field name in Exp. column and then value column will be

=Parameters!Parametername.Value

Now run the report.

No comments:

Post a Comment