Member Avatar for jlivvers

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

  • 2 Contributors
  • 1 Reply
  • 161 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

>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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.