Skip to main content
Question

User defined fields in Reports


Forum|alt.badge.img

Hi All,

I am planning to create a report using user-defined fields in the report parameters. My idea is that the user can select the desired fields from the report parameters and then click on "Run Report." The report will then be generated with only those selected fields and values, without including any other tables.

Is this possible, or do we need to have predefined fields on the screens?

Thank you.

6 replies

aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1178 replies
  • July 22, 2024

You can have any built-in or UDF in the report or parameter. When you added new fields to your DACs, you will need to open the report requiring modification and Rebuild the Schema so UDFs become available.


Forum|alt.badge.img
  • Author
  • Varsity I
  • 114 replies
  • July 22, 2024

Thanks. Can you guide me in this please . I am trying to get or print customer information on report that is selected in parameter but it’s showing me attach error. I am attaching screen shots of my report.

 


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1178 replies
  • July 23, 2024

It is not the parameter causing the issue. I see you have Bracket before =IIF. Remove it. Also you are missing the false part of the IIF function. 


Forum|alt.badge.img
  • Author
  • Varsity I
  • 114 replies
  • July 23, 2024

thanks this is my query 
“”=IIf( [BranchBAccount.AcctName]<>null.[BranchBAccount.AcctName]+'{br}', ' ')+IIf([BranchBAccount.DefAddressID_Address_displayName]<>null.[BranchBAccount.DefAddressID_description]+'{br}', ' ')+IIf( [BranchBAccount.DefAddressID_description]<>null.[BranchBAccount.DefAddressID_description]+'{br}', ' ')””

 

I am trying to print that branch which is passed in parameter by user before running report. Can you guide me how can I make that?


aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1178 replies
  • July 23, 2024

Sorry, but I don’t see any parameter in your formula. They all are fields from BranchBAccount DAC

You may want to read through the Report Designer user guide.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • August 20, 2024

Hi @tahayabali were you able to find a solution? Thank you!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings