By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Report Designer
2
Posts
2
Users
1
Reactions
2,199
Views
August 20, 2020 2:15 am
Created a view and added to DAC and can view correctly in Generic Enquiry. However when added in Report Designer it returns correct number of rows but the data is just repeated form the first row. Any ideas?
The DAC is missing CompanyID, when i try to add it with the below it says CompanyID is already added but its not:
#region CompanyID
[PXDBInt()]
[PXUIField(DisplayName = "Company ID")]
public virtual int? CompanyID { get; set; }
public abstract class CompanyID : PX.Data.BQL.BqlInt.Field<CompanyID> { }
#endregion 1 Reply
August 20, 2020 12:54 pm
You will need the CompanyID in the SQL view, but you do not need it in the DAC.
Have you designated a key field in your DAC? There is a blog article here that provides some instruction on creating the SQL view and DAC that you could also review. https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/
Thanks,
Kurt
Online Members
