954,514 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Reports and Id fields

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

jlivvers
Light Poster
26 posts since Oct 2010
Reputation Points: 10
Solved Threads: 0
 

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

__avd
Posting Genius (adatapost)
Moderator
8,648 posts since Oct 2008
Reputation Points: 2,136
Solved Threads: 1,241
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: