Hi,

in my windows form application Im using a microsoft report to generate receipts that show amounts, dates and userId's for those that have taken the payments.

What I need to do firstly is where the userId's are displayed currently (as a foreign key) i'd like to show instead the username of the user.

Also in the date column (ie date of transaction) which is taken from a datetime field, the time defaults to 12.00.00am in every case regardless of whats actually recorded in the table.

I'm completely new to reports in c# & visual studio so hopefully someone can point me in the right direction.

Cheers

>i'd like to show instead the username of the user.

Use Joins if "username" column is in different but related table.

>Also in the date column

Date format in ms report.