New to Crystal.

[IrishJerry]

I have a table 'table1' of size 'N' which contains a primary key 'X'
I have another table 'table2' of size 'N2'.
Each row in 'table2' contains a reference to the primary key 'x' in 'Table1'. Each of theses rows also contains a balance.

So I want to create a crystal report which will Itterate and do the following.

select * from Table 1
For each Row in 'Table1'
select * from Table2 where table1.x = table2.x
For each of the selected rows sum the balance
print x2 details and summed balance.
end
end

Can this be done ? I am doing this via C# and Visual Studio 2008 ??? Any Help Please ?

 

[boblarson]

Build a subreport and then include it on the main report.