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... / Want to get different ...
Small and medium business | Business Central, N...
Suggested Answer

Want to get different column fields in single column in rdlc report layout.

(1) ShareShare
ReportReport
Posted on by Alina Fahim Ibrahim 194
I want to get two different columns fields in single column in rdlc report .
 
I want these entries in the report template but the issue is gl account number is different in eachline.
One gl acc number is get from the sales line and the another one will get from the custom page .And both gl account number have to be show in same column but in different lines.
Is there any solution of this query?
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at
    Hello Alina,
     
    If I understood you well, you need to list those 3 rows above on the report?

    You said that ''And both gl account number have to be show in same column but in different lines.''
    Should your report design needs to be something similar to this picture above? If it is right, then you can try to setrange on the columns on the General Ledger Entries table that is not the G/L Account No.
     
    We can see that you have filters on the Posting Date and the Document No. columns.
    Try to set that filters on your report. Based on those filters, you will get general ledger entries like it is shown on your picture. Same Posting dates and Document No. but different G/L acc nos.
     
    Greetings
  • CU15081628-2 Profile Picture
    CU15081628-2 2 on at

    I wasn’t sure how much it would cost to fix my semi’s A/C, but the heat was too much to handle. After some research, I came across shop.clevertransco.com/semi-ac-repair-and-cost. They gave me a clear idea of the repair costs upfront, and the work was done efficiently. The A/C now works perfectly, and the price was reasonable. I’d recommend them to anyone needing A/C repairs.

  • Suggested answer
    Mahesh Uppala Profile Picture
    Mahesh Uppala 7 on at
    Hi Alina,
     
    Take a global variable of text and add both fields to that global variable and show that variable in rdlc report layout.
     
    Let's say for example
     
    CombineAccountNo := GenLedgEntry."Account No." + '-' + CustomTable."Account No."; //Custom Table is where you have another account no. stored.
     
    Please check and let me know if it helps or not. Thanks!

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,143

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans