web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) SSRS report VendBaseDa...

Microsoft Dynamics AX (Archived)

SSRS report VendBaseData does not show Bank account number and most other VIEW display methods. ???

(0) Share

Report

Report

Posted on by Mel Cabillada III

425

SSRS report VendBaseData does not show Bank account number and most other VIEW display methods. ???

Datasource for SSRS report VendBaseData is axapta view VendBaseDataView. Where bankAccountNum is a display method.

display BankAccount bankAccountNum()

{

VendTable vendTable;

return vendTable.bankAccountNum();

}

I have always created Report Data Provider classes to populate temporary tables to feed to my customized SSRS reports. And they work perfectly.

That's why i have never used a View as a datasource. am a bit confused.

Please anybody can help me? Why the standard report VendbaseData does not seem to work?

Thanks you community.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Brandon Ahmad 2,465 User Group Leader on at

Like (0)

Report

RE: SSRS report VendBaseData does not show Bank account number and most other VIEW display methods. ???

I'm actually troubleshooting this for a client right now. Has anyone else faced this issue? I can replicate it in my client's environment but not on my own individual environment. Did you ever find a solution MEL?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: SSRS report VendBaseData does not show Bank account number and most other VIEW display methods. ???

Please validate if there is any security group specified the user which is basically not showing the field.

please try to validate using administrator login.

Was this reply helpful? Yes No
Suggested answer

Brandon Ahmad 2,465 User Group Leader on at

Like (0)

Report

RE: SSRS report VendBaseData does not show Bank account number and most other VIEW display methods. ???

@Nitesh,

That was the first thing that I tried with my client, so your thinking was definitely in alignment with mine. But it turned out to be more complicated. There is no way I could have solved this issue from a forum.

@anyone else

In case anyone ever runs into this error on a client site, upon debugging, I found that the VendBaseDataView was missing a find operation that was pivotal for the display methods. Simply updating the line to:

VendTable vendTable = VendTable::find(this.AccountNum);

in each display method worked. I recommended that we look closely at rerunning the CU updates for my client as this should have been included with their Dynamics AX version. My guess is that an update on 2012 did not go process which caused this. The Help screen showed that the versions of AX were current but we all know better than to always trust that.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Community Member 4

#2

Nayyar Siddiqi 2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans