Skip to main content
Question

User defined fields in Reports

  • Jul 22, 2024 6:07 PM UTC
  • 6 replies
  • 223 views
  • Translate All

Forum|alt.badge.img+3

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+11
  • Captain II
  • Jul 22, 2024 7:37 PM UTC

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.

Translate

Forum|alt.badge.img+3
  • Author
  • Captain I
  • Jul 22, 2024 9:29 PM UTC

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.

 

Translate

aaghaei
Captain II
Forum|alt.badge.img+11
  • Captain II
  • Jul 23, 2024 2:31 AM UTC

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. 

Translate

Forum|alt.badge.img+3
  • Author
  • Captain I
  • Jul 23, 2024 3:28 PM UTC

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?

Translate

aaghaei
Captain II
Forum|alt.badge.img+11
  • Captain II
  • Jul 23, 2024 5:07 PM UTC

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.

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Aug 20, 2024 10:59 PM UTC

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

Translate