Hi all, I hope someone can point me in the right direction here, and that I can explain what I need here, as I can not seem to get it to work how I need it to.

Using the basic Crystal Reports 2008 program, and any viewer (third-party, or Crystal Reports Viewer 2008).

I need to create the report so that if the person that is viewing the report, can view it remotely without an ODBC connection to the MSSQL server that the report is generated from, AND still have the ability to use filters on the data, as they may be viewing the report off site.

Currently, I can, apparently get all of the data to load by using an 'All' filter, but when I to to change the filter, the viewer programs complain that there is no ODBC connection.

I can also save the report from CR2008 with the filters set, and obviously this saves the data as set for those parameters, and again, when in the viewer, if the filter is changed, then it tries to connect back to the MSSQL server.

So basically what I need is to be pointed in the right direction for how to load all of the data into the report, with no filter applied,(size does not matter), and then how to filter said data in the report itself, in a viewer using the filters on the report.

Like I said, I have the filters working, and data loading, but it wants to connect to the server, so this does me no good.

Thanks in advance for any help anyone can give.