Skip to main content
Solved

Need help with a subreport - Report Designer

D
Freshman II

I have a client that would like to view all of their fixed assets and their calculated depreciation for the next 12 months in a single report. I have edited a copy of the Fixed Asset Balance report (FA630000) and I made a custom report (FA63001D) to use as a subreport that will list the financial period, calculated depreciation, and YTD calculated deprecation. 

 

The subreport takes 2 parameters: [FixedAsset.AssetCD] and [FABookBalance.BookID]. Passing the BookID works fine but for some reason it doesn’t like how the AssetCD is passed to the subreport. If I hardcode a value for it like 1000-001, it works but I want it to run the subreport for each asset in the main report. I’ve also tried basing the subreport on [FixedAsset.AssetID] but this gives the same result. The stack trace only gives this for a SQL message: 

 @@DBTS, IDENT_CURRENT('WatchDog') OPTION (OPTIMIZE FOR UNKNOWN)/*  */

 

 

Best answer by dgranger70

​@Nilkanth Dipak ​@BenjaminCrisman I figured this out. There was an issue with variable definitions in the subreport. I was trying to assign a variable to CInt(Substring([FABookHistory.FinPeriod]), 0, 2) for visibility logic and kept getting an “Input string was not in the correct format” exception. Removing CInt() fixed the issue. 

View original
D
1 person likes this
  • D
    dgranger70
Did this topic help you find an answer to your question?

9 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

​@dgranger70 In your subreport do you have a parameter for AssetID or AssetCD defined? I did a quick mockup and all I did was add the AssetID to the subreport and the associated filter conditions and it worked:

Then in the main report:

Printed:

 

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
D
Freshman II
  • dgranger70
  • Author
  • Freshman II
  • 5 replies
  • April 9, 2025

​@BenjaminCrisman yes, I do. I’m able to run my subreport by itself, it just won’t run in the main report. 

 

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

​@dgranger70 I don’t think that FixedAsset.AssetCD has a schema, so I think you need to remove the function on the View Name in the subreport. Typically, views will not be necessary for subreports since it’s just inserting specific data and since the subreport is not typically ran independently there is no need to use actual selectors. Otherwise I may need to check the reports locally to see if I could get them to work

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
Nilkanth Dipak
Semi-Pro II
Forum|alt.badge.img+10

Hi ​@dgranger70,

You are using AssetCD instead of AssetID. Please replace AssetCD with AssetID.
 

Hope, it helps!

Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
D
Freshman II
  • dgranger70
  • Author
  • Freshman II
  • 5 replies
  • April 9, 2025

​@Nilkanth Dipak Thanks for the suggestion! I’ve tried it both ways and I’m getting the same error. 

Chris Hackett
Nilkanth Dipak
2 people like this
  • Chris Hackett
    Chris Hackett
  • Nilkanth Dipak
    Nilkanth Dipak
D
Freshman II
  • dgranger70
  • Author
  • Freshman II
  • 5 replies
  • April 9, 2025
BenjaminCrisman wrote:

​@dgranger70 I don’t think that FixedAsset.AssetCD has a schema, so I think you need to remove the function on the View Name in the subreport. Typically, views will not be necessary for subreports since it’s just inserting specific data and since the subreport is not typically ran independently there is no need to use actual selectors. Otherwise I may need to check the reports locally to see if I could get them to work

I removed the functions from the view name and I’m still getting the same error. 

D
Freshman II
  • dgranger70
  • Author
  • Freshman II
  • 5 replies
  • April 9, 2025

Also, I’ve noticed that it works just fine in the preview window in report designer. 

D
Freshman II
  • dgranger70
  • Author
  • Freshman II
  • 5 replies
  • Answer
  • April 14, 2025

​@Nilkanth Dipak ​@BenjaminCrisman I figured this out. There was an issue with variable definitions in the subreport. I was trying to assign a variable to CInt(Substring([FABookHistory.FinPeriod]), 0, 2) for visibility logic and kept getting an “Input string was not in the correct format” exception. Removing CInt() fixed the issue. 

Chris Hackett
Nilkanth Dipak
2 people like this
  • Chris Hackett
    Chris Hackett
  • Nilkanth Dipak
    Nilkanth Dipak
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2809 replies
  • April 14, 2025

Thank you for sharing your solution with the community ​@dgranger70!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved