Skip to Content
0
Former Member
Dec 23, 2011 at 06:58 PM

Using 2 Views within Report but it is clearing my report

27 Views

I have a report, with sub-reports. For the main report I have the data coming from a view in the database. The customer has now asked for more information to show in the main report that is not able to be shown through the first view, so I have created a second view.

When the report was run with just one view it worked fine. Now, once I like the second view I lose all of the data from the first view. Why would that be? I need information from each view to re-write the formulas for the fields on the main report. So each formula will have a data item from the first view and then another data item coming from the second view. Is this allowed?

My biggest concern is that no matter what I do with this second view, as soon as I do it the report is empty.

I am using Visual Studio 2008 with the built in Crystal Reports.

Edited by: LeahMarie on Dec 23, 2011 7:59 PM