Crystal Report as an Embedded Resource that accesses DB directlyProblem

[Patrick Flahan]

I have a rather strange problem that I hope some one can help with.

Here is the situation. I have an c# (.Net 1.0) application that
consists of several components. Currently, everything is in the same
project within the solution. Now we want to split out some of
components to separate dlls to make reuse easier. So I set about
splitting up the components into individual projects within the
solution. Almost everything works just as before.

The part that I am having a problem with is certain Crystal Reports. If
the report accesses the database directly, it doesn't work. Other
reports that use datasets work fine. When the crystal report viewer is
called it comes up blank. I used SQL Profiler to watch what is
happening in the database (SQL Server2k) and I don't see the sql
statements being executed. I see some other calls that look related
(sp_procedures_rowset, sp_tables_rowset) but not the sql.

I would really like to be able to split out the components into
individual dlls as it would make it easier to manage the application.
Any help would be gratefully accepted.

Patrick Flahan