Time card and expense line

[snehalkhare]

Expense line is created when time card is approved and the amount on the expense line is calculated   for the total hours in that time card.

I'm creating a report on expense line to show the amount(expense) for the hours mentioned in the time card. So please suggest me how this field can be brought on the report, so that it will show the total hours of the time card .

Thanks,

Snehal Khare

[Raju Koyagura]

Basically you should create database view which will help you to combine two or more tables together to get the expected result.

I just experimented something like below (Total gives the hours submitted)....

http://wiki.servicenow.com/index.php?title=Database_Views#gsc.tab=0

[snehalkhare]

For database view we will require some reference between these two tables , which I couldn't find . Can you please help with it . Is there any other way possible for the same.

Thanks,

Snehal Khare

[Raju Koyagura]

In Time Card table we have a field called task and in Expense Lines source id which is same as task field.

This is how I created

[Phil32]

I've been looking for the linkage between the Time Card and an Expense Line that was created upon the approval.  Based upon the comments above, that doesn't seem to exist on either table.

Am I reading that correctly?