If a project has no transactions, the Project Transactions Report is completely blank, even the header information is blank. Is there a way to display the project and description in groupHeaderSection1 even if the project has no transactions? Thanks.
Answer
Project Transactions Report completely blank if there are no transactions
Best answer by lauraj46
Hi
You should be able to accomplish this by making some changes to the report Schema as follows:
Reverse the join from PMProject to PMTran, promote this join to the top, and make all joins Left instead of inner. Also, change the condition on the filters tab from PMTran.ProjectID to PMProject.ContractID.
With these changes in place, you should get at least one record, even if there are no transactions.
Hope this helps!
+8Hi
You should be able to accomplish this by making some changes to the report Schema as follows:
Reverse the join from PMProject to PMTran, promote this join to the top, and make all joins Left instead of inner. Also, change the condition on the filters tab from PMTran.ProjectID to PMProject.ContractID.
With these changes in place, you should get at least one record, even if there are no transactions.
Hope this helps!
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.