How to show data from All entity from ProjEmplTrans Table

(0) Share

Report

Posted on by Ann2015

1,128

Hello,

Can someone help me with getting all the data from ProjEmplTrans table regardless of the entity.

I need total hours by employee.

Thanks

Ann

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi Ann2015,
You can do crossCompany select to select data across all legal entities.

Was this reply helpful? Yes No
Ann2015 1,128 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much!

You mean to write a method on the ProjEmplTrans table using the crossCompany?

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

You can write method anywhere you want. You did not tell us what you want to do, report, new form or something else.

Was this reply helpful? Yes No
Ann2015 1,128 on at

Like (0)

Report
Copy link

Link copied!

Sorry...

I am using the form, ProjectMgmt-> Inquiries-> Transactions-> Hour. I want to show data from all entities here.

Thanks!

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Form you are referring to shows all kind of transactions not only hour but cost, etc, so modifying it you will probably break other functionality. You can create new form to show only hour transaction and set CrossCompanyAutoQuery true on it's datasources to show cross-company info.

Was this reply helpful? Yes No
Ann2015 1,128 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much but I tried the above solution and I still don't see the cross company hours.

What am I doing wrong.

Thank you!

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

You need to add some details about your solution, so we can help you.

Was this reply helpful? Yes No