Filter and Aggregat function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

leebm@sms.at - 28 Aug 2006 19:29 GMT

Hi all,
I am creating a report in BI Dev Studio and use the grouping
functionality to show the number of leads for different sales
representatives. I also use "drill down" to show the leads in detail.
The report also uses a filter to filter out certain time period.
On the sales persons level I use "Rowcount" to show the number of
leads. this works fine as long as I do not use any filter. If I use the
filter, the "Rowcount" function still shows the number of leads for the
whole table, although the sub-group shows the right number of entries.

Where is my mistake?

Reply to this Message

Ben Watts - 28 Aug 2006 20:44 GMT

You could place your filter in the WHERE statement under the data tab.

> Hi all,
> I am creating a report in BI Dev Studio and use the grouping
[quoted text clipped - 7 lines]
>
> Where is my mistake?

Reply to this Message

Markus - 29 Aug 2006 12:19 GMT

Ben Watts schrieb:

> You could place your filter in the WHERE statement under the data tab.
> > Hi all,
[quoted text clipped - 8 lines]
> >
> > Where is my mistake?

Thanks for the answer, but how do I place the filter in the sql
statment exactly? I tried something like: select * from
Adressenherkunft where insertdate = 'Parameters!von.Value' but this
does not work?

Reply to this Message

Jordi Rambla - 31 Aug 2006 08:44 GMT

Hi,

The syntax is like

insertdate = @von

where "von" is the name of the parameter exactly as it shows in the report
parameters dialogbox.

HTH,

Jordi Rambla
MVP SQL Server (Reporting Services)
Solid Quality Learning (http://www.solidqualitylearning.com)

> Ben Watts schrieb:
>
[quoted text clipped - 15 lines]
> Adressenherkunft where insertdate = 'Parameters!von.Value' but this
> does not work?

Reply to this Message