Finance | Project Operations, Human Resources, ...

How to show the cost center id and name in ssrs report

(1) Share

Report

Posted on by D365FO DEV

406

Hello,

i want to get the cost center id and name on my ssrs report ( purchase requisition)

anyone can provide with the code to make this happen?

thanks

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Martin Dráb 238,143 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can utilize DefaultDimensionView (DefaultDimension will match PurchReqLine.DefaultDimension and you also need to filter by DimensionAttributeId).

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report
Copy link

Link copied!

hi @martin drab.

can you provide me the code?

Was this reply helpful? Yes No
Martin Dráb 238,143 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Let me repeat my answer to the identical question in your other thread:

I can't, because what code you should write (if any at at all) depends on how you've implemented (or are going to implement) your report or how it's implemented the report you're extending. You may be modifying an AOT query, use the query framework, write a select statement in X++, use electronic report and so on. There is no universal code.

If you have no idea how to design the code, you'll need to tell us more about your report.

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report
Copy link

Link copied!

hi martin,

i still didnt write the code for this one as im facing challenges, so can you provide code that gets me cost center value and name?

im using an extension on standard dp class in inserting event handler

Was this reply helpful? Yes No
Layan Jwei 8,133 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Maybe those threads can give u a hint

https://community.dynamics.com/forums/thread/details/?threadid=b8234214-ef36-4aab-8af6-ee1d3c157ea5

https://community.dynamics.com/forums/thread/details/?threadid=1f60540e-f575-491a-a103-df47bbac4c92

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report
Copy link

Link copied!

hi layan,

they didnt help

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,047 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Check the following code:

DimensionAttributeValueSetStorage dimStorage; str _dimName;// Dimension name dimStorage = DimensionAttributeValueSetStorage::find(_rec); //default dimension RecId return dimStorage.getDisplayValueByDimensionAttribute(DimensionAttribute::findByName(_dimName).RecId);

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (1)

Report
Copy link

Link copied!

Hi Waed,

Pls provide me the exact code based on my case if possible

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,047 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Just set the str _dimName; to be str _dimName = ''CostCenter" and _rec = Default dimension field from Purch requisition lines table.

DimensionAttributeValueSetStorage dimStorage; str _dimName = "CostCenter";// Dimension name dimStorage = DimensionAttributeValueSetStorage::find(_rec); //default dimension RecId return dimStorage.getDisplayValueByDimensionAttribute(DimensionAttribute::findByName(_dimName).RecId);

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (1)

Report
Copy link

Link copied!

Hi wael,

i have tried it but its not working. values are blank.

Was this reply helpful? Yes No