How to Generate SubReport in crystal report with SQL Query?

Question

I am Having a Report Which has to generate from Two different where Clauses.

**Condidtion 1**
Select * from Table1 where Name="ABC"

**Condition2**
Select * from Table1 where city="LA"

In above mentioned case, the condition two should appear in sub report part Please remember the Data is populatinf from same table and in same crystal report

Condition 2 Will be in subreport

Answer 1

Create a Datasoruce and name the subreport as sub1 or anything paste the following code

rptdoc.Subreports("sub1").SetDataSource(dv1)