Showing posts with label section. Show all posts
Showing posts with label section. Show all posts

Thursday, March 29, 2012

filter detail section of matrix report

Hi,
is there a way to filter details section of the report created using Matrix report type?
I just want to see rows that contain positive numbers.

Thanks,
Igor

Have you tried using the filter tab in the matrix properties dialog box.

I'd be careful though as each matrix cell is an aggregation of 1 or more detail rows. Depending on the nature of the source data and whether any aggregation is actually occuring you'll want to watch out for filtering underlying negative values vs a negative result of an aggregate.

Can you not do this in the source query?

Friday, March 9, 2012

File Watcher task

In the file watcher task in the filter section does it look for exsiting file name which we have mentioned or is it possible to give first few letters of the file name like

pat*.txt

Please let me know

Did you just download the task and not read its documentation?

http://www.sqlis.com/23.aspx

You can use pat*.txt, if you wish.