1 to many relations in CR.NET ??? 1

[skarra]

I am writing an application to keep track of a persons change of address (which i am storing it in SQL server) with a unique identification number SSN.

What i want now is: I want to generate a report which can get me all addresses any person has changed all in one report (I mean, for each person/SSN i need 1 report)..

Ex: like this:

SSN: xxxxxxxxx
Name: xxxxxxxxxx


Address Apt CIty State Zip
xxxxxxx 222 tttt tt 22222
yyyyyyy 111 eee 22 22221
....
....
and soo on..

how can i do this in CR? I will pass the SSN NUmber from the textbox in a form. I am using C#, SQL 2000, CR.NET..

thx.

 

[synapsevampire]

Group by the SSN, and place the name and SNN in the group header.

Place the addresses themseleves in the details.

Obviously the output will be based upon the database design, but this should work.

-k