web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Fixed Asset Projected ...
Small and medium business | Business Central, N...
Suggested Answer

Fixed Asset Projected Value Report (RDLC Layout) Question

(0) ShareShare
ReportReport
Posted on by zemorex19

Hello BC Community,

I have a requirement to create an RDLC layout that prints FA depreciation and book value side by side (grouped on the FA posting date). I figured I could use FA Projected Value report. I started customizing the report in order to get what I need and I'm halfway there, but I can't seem to get the report to do exactly what I need and hopefully you can help.

Below is how I've customized the report - this is not the final report, just my customization so far:

pastedimage1628777329909v1.png

This is the excel output:

pastedimage1628777655018v2.png

What I need is to have one FA Posting date column, and then have all of the details show up side by side, but the report keeps creating a new posting group for every FA. Essentially push up all of the details for which I've drawn arrows for...Perhaps I'm not grouping correctly? 

Any help would be appreciated.

Thanks,

Igor

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Igor,

    I am not a programmer but have you tried Jet Reports? This would be a simpler approach and can be accomplish in Excel without the problems y0ou are having.

    insightsoftware.com/.../

    Thanks,

    Steve

  • zemorex19 Profile Picture
    zemorex19 on at

    Hi Steven,

    Thanks for the recommendation, but we've already tried Jet Reports and we found that it has some of the same constraints that are in the base package of BC. Hence, why we're making some customizations. Anyone else worked with the FA - Projected Value report? Our goal is to have the report print our assets grouped in columns rather than row by row. Any help would be appreciated.

    Thanks,

    Igor

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans