sql server reporting services: Dataset filtering... how? -- sql server reporting services

RE: Dataset filtering... how?

magendo_man
9/6/2006 9:12:02 AM

sql server reporting services:

In the table properties you need to go to the Filter tab. You will then be
able to select the dataset field you want from the drop-down list and then
set what value(s) you want to include in the table.

HTH, Magendo_man

[quoted text, click to view]

Dataset filtering... how?

Tarun Mistry
9/6/2006 4:53:16 PM

Hi all,

I want to create a summary page for one of my report, depending on a
parameter, I would like to filter the dataset before creating the summary
fields.

I cannot figure out how to perform this filtering, my approach has been to
insert a Table control and map it to my dataset, then try and do some
filtering via the properties. When i then put something like

=sum(Fields!Sales.Value)

into the header (such that it is shown only once, not repeated), I get the
sum for the full dataset, not the filtered one.

Please help, is there any easier way todo this?

Lastly, I can't filter at the SQL level as the dataset is being used to
populate a chart below the summary.

Advice welcome.

Please help
Taz

Re: Dataset filtering... how?

Tarun Mistry
9/6/2006 5:57:48 PM

Thanks for ther reply.

I found that actually filtering directly on the dataset was my best option
(within the Data tab). My charts are working correctly on the condensed
data.

Taz

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.