Finance | Project Operations, Human Resources, ...

SSRS report not showing values despite having them in the tmp table

Like (4) Share

Report

Posted on 12 Mar 2025 14:07:48 by CU09091357-0

401

I'm developing an SSRS report that contains a tablix with dataset 'header'.

In the tablix, there's these 2 fields that are coming from another dataset which is linesdetails.

The problem is that despite the values of base rent and chilled water are showing in the tmp table when debugging, they're not showing int the report.

=First(Fields!BaseRentUnitPrice.Value, "QuotationLinesDetailsDS")
=First(Fields!Currency.Value, "QuotationHeaderDS") & " " & First(Fields!ChilledWaterUnitPrice.Value, "QuotationLinesDetailsDS")

I tried to restart the ssrs reporting service and everything possible to show the values, but I'm not able to see the values on the report for this specific dataset.

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

All responses (5)

Answers (0)

Waed Ayyad 7,968 Super User 2025 Season 1 on 26 Mar 2025 at 11:33:00

Like (0)

Report

SSRS report not showing values despite having them in the tmp table

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks,

Waed Ayyad
Waed Ayyad 7,968 Super User 2025 Season 1 on 23 Mar 2025 at 10:21:28

Like (0)

Report

SSRS report not showing values despite having them in the tmp table

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks,

Waed Ayyad
Suggested answer

Waed Ayyad 7,968 Super User 2025 Season 1 on 13 Mar 2025 at 07:44:42

Like (1)

Report

SSRS report not showing values despite having them in the tmp table

Hi,

The fields should be on the same Datasource of Tablix, in order to appear.

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue
CU09091357-0 401 on 12 Mar 2025 at 15:08:13

Like (0)

Report

SSRS report not showing values despite having them in the tmp table

Steven Renders thank you for your reply, no it's finance and operation
Steven Renders 5,451 Moderator on 12 Mar 2025 at 14:16:38

Like (0)

Report

SSRS report not showing values despite having them in the tmp table

Is this related to Business Central in some way?