News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Address block problem

Microsoft Dynamics GP (Archived)

Address block problem

(0) Share

Report

Report

Posted on by painterisaac

3,015

I need the customers address block to show at the top of a report that I have created in report builder 2.0. The report has a parameter allows selection of a particular customer. The report part is working fine but the address block is not working for me.

I've tried inserting each part (i.e. Customer Name, Address1, etc.) into a text box but after I click "run" it keeps giving me an error.

5672.Capture.JPG

What other approach should I take to make this possible?

FYI, these are my datasets. I am pulling the address block info from dataset1 (the same data set that the report is using). Dataset2 is for the parameter.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

painterisaac 3,015 on at

Like (0)

Report

RE: Address block problem

I figured it out.

Here is the answer.

1. Put in a rectangle.

2. Put an expression within that rectangle as the following:

First(Fields!Customer_Name.Value,"DataSet1") & vbCrLf & First(Fields!Address_1.Value,"DataSet1") & vbCrLf & TRIM(First(Fields!City.Value,"DataSet1")) & " " & TRIM(First(Fields!State.Value,"DataSet1")) & " " & TRIM(First(Fields!Zip.Value,"DataSet1"))

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,407 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans