Multiple Filters in an AD HOC report.

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 ?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
"Tk_Neo" wrote:
> 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 ?