How can i use hidden DAC INReceiptStatus in Report designer

Hi ​@fmrubi11 

What is the data field you are looking to bring into the report?

I want all the fields but DAC is hidden and unavailable for selection in Report designer 

​@fmrubi11 Which Filed you want to place? Can you share me a screenshot of which one is your looking ?

i need all fields in INReceiptStatus below

To make the INReceiptStatus DAC available for reporting:

1. Create a DAC extension as shown in the code :

   public class INReceiptStatusExt : PXCacheExtension<INReceiptStatus>
       {
           #region ReceiptNbr
           [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = ">CCCCCCCCCCCCCCC")]
           [PXUIField(DisplayName = "Receipt Nbr.", Visibility = PXUIVisibility.Visible)]
           public string ReceiptNbr { get; set; }
           public abstract class receiptNbr : PX.Data.BQL.BqlString.Field<receiptNbr> { }
           #endregion

           #region Status
           [PXDBString(1, IsFixed = true)]
           [PXUIField(DisplayName = "Status", Visibility = PXUIVisibility.Visible)]
           [INReceiptStatus.ListAttribute()]
           public string Status { get; set; }
           public abstract class status : PX.Data.BQL.BqlString.Field<status> { }
           #endregion

           #region Hold
           [PXDBBool()]
           [PXUIField(DisplayName = "Hold", Visibility = PXUIVisibility.Visible)]
           public bool? Hold { get; set; }
           public abstract class hold : PX.Data.BQL.BqlBool.Field<hold> { }
           #endregion
       }
    

2. Add it to your customization project
3. Publish the customization project

After publishing, you should be able to:

• Access INReceiptStatus fields in the Report Designer

Hi ​@fmrubi11,

Yes, the DAC is marked as Hidden, so it cannot be directly used in a Report or GI. Customization is required to include this data in a report.

1. As ​@arthia98  suggests, you can achieve this by creating a PXProjection.

2. ​@noorula77 suggests creating an extension of the INReceiptStatus DAC. You can add the required fields to this extension, allowing access to these fields since the extended DAC will not inherit the Hidden property.

3. Alternatively, you can create a custom view to fetch data from the INReceiptStatus DAC. From this view, you can create new DAC fields as needed to display in the report. The newly created DAC can then be referenced in the report.

Hope, it helps!

i need all fields in INReceiptStatus below

 

 

Hidden DAC Cannot be available to make the reports or GI.

Tried this method but still have no access to the DAC