Hello Community,
I have been trying to create a report where I would like to display the below highlighted fields in my report:
And have the following relations established:
How can i put up the condition to only display the type=Subcontract and the description from the Subcontracts screen?
Thanks in advance.
Hello
Did you look at the Commitments generic inquiry in your Sales Demo tenant? Please use the Commitments generic inquiry in your Sales Demo tenant as a model for how to build your report:
Laura
Hello
Did you look at the Commitments generic inquiry in your Sales Demo tenant? Please use the Commitments generic inquiry in your Sales Demo tenant as a model for how to build your report:
Laura
Hello
I checked this out already, seems it is a Form-Tab screen that has been created to display inquiries.
Hello
Did you look at the Commitments generic inquiry in your Sales Demo tenant? Please use the Commitments generic inquiry in your Sales Demo tenant as a model for how to build your report:
Laura
I tried to replicate the same in a GI, where I established the joins as follows:
Hello,
Yes, you don’t want a cross join. I think Cross joins connect every record on the left table/DAC with every record on the right table/DAC. If you want to include All Projects in your report, whether they have Commitments or not, use Left join. If the report should include only projects with commitments, use an Inner join. I think the fields of your join are correct.
Your original question was:
You have answered the first part of your question with your Order Type condition:
The next step is: open a Subcontract in Subcontracts screen, and click Customization → Inspect Element. Then Click on the Subcontract Description:
Add POOrder.OrderDesc field to your report, for subcontract description.
Laura
Hello,
Yes, you don’t want a cross join. I think Cross joins connect every record on the left table/DAC with every record on the right table/DAC. If you want to include All Projects in your report, whether they have Commitments or not, use Left join. If the report should include only projects with commitments, use an Inner join. I think the fields of your join are correct.
Your original question was:
You have answered the first part of your question with your Order Type condition:
The next step is: open a Subcontract in Subcontracts screen, and click Customization → Inspect Element. Then Click on the Subcontract Description:
Add POOrder.OrderDesc field to your report, for subcontract description.
Laura
Hello
Thank you for your prompt response. i already tried the above scenario in the report and also GI, but it doesn’t display any of the data after establishing the joins:
The primary table in both the Gi & report that’s being used is PMBudget.
GI:
The same empty result is getting displayed in the report 
Attaching the GI for your reference, if required
Hello,
Yes, you don’t want a cross join. I think Cross joins connect every record on the left table/DAC with every record on the right table/DAC. If you want to include All Projects in your report, whether they have Commitments or not, use Left join. If the report should include only projects with commitments, use an Inner join. I think the fields of your join are correct.
Your original question was:
You have answered the first part of your question with your Order Type condition:
The next step is: open a Subcontract in Subcontracts screen, and click Customization → Inspect Element. Then Click on the Subcontract Description:
Add POOrder.OrderDesc field to your report, for subcontract description.
Laura
Hello
whenever i am adding OrderType = RS in the report, it doesn’t display any of the records as it does in GI.
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.