Multiple Filters in an AD HOC report.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tk_Neo - 30 Jan 2007 16:29 GMT

There are many business users in my office who would like an AD HOC reporting
system. I am not in a position to install the reporting server right now
suite and check it out myself. I have seen some presentations and i like the
tool for the most part ...I have some questions if anyone can help....

1. Can the users select two tables for a report and manually specify the
join column between the two.

2. Can the user specify more than one condition in the filter. Like Name =
X AND Address = Y AND Job = Z where Name, Address, Job can be columns from
more than 1 table

3. Can the users sort on more than one column ?

4. Can the users group by on more than one column. Nested grouping ?

Reply to this Message

Amarnath - 31 Jan 2007 11:59 GMT

Your users can create their own reports using "Report Builder" provided you
create some report model. Nothing complicated Report Model is basically
imangine as a view with all the tables joined together.

Now all the 4 questions the answer is "YES" and it is possible.

Amarnath

> There are many business users in my office who would like an AD HOC reporting
> system. I am not in a position to install the reporting server right now
[quoted text clipped - 11 lines]
>
> 4. Can the users group by on more than one column. Nested grouping ?

Reply to this Message