This XML does the running of the report off of my interface. The 3 SQL statements at the end, CategorySQL, deptsql, and customersql, would you say this is used to filter the results in the report? I can't see where the filter is actually happening. The idea is that the user selects from a dropdown list, which categories and departments they wish to see.
<?xml version="1.0" encoding="utf-8" ?>
<report_viewer>
<databases>
<database id="1" server="testserver\sql2005" database="SU" uid="aa" pwd="ak"/>
<database id="2" server="testserver\sql2005" database="PB" uid="aa" pwd="ak"/>
<!-- Logic is needed to decide which reports to display for each d ...
Go to the complete details ...