Finance | Project Operations, Human Resources, ...

No Data Showing in SSRS Report Using Temp Table in D365 F&O

(2) Share

Report

Posted on by Aditya Pal

196

Hi all,

I'm creating a custom SSRS report in Dynamics 365 Finance and Operations, and my problem is that no data is showing when I run the report, even though the logic seems fine.

[SRSReportParameterAttribute(classStr(SalesReportContract))]
class SalesReportDP extends SRSReportDataProviderBase
{
SalesReportTmp salesTmp;

[SRSReportDataSetAttribute(tableStr(SalesReportTmp))]
public SalesReportTmp getSalesTmp()
{
select salesTmp;
return salesTmp;
}

public void processReport()
{
SalesTable salesTable;
SalesLine salesLine;
CustTable custTable;
InventTable inventTable;

while select salesTable
join salesLine where salesLine.SalesId == salesTable.SalesId
join custTable where custTable.AccountNum == salesTable.CustAccount
join inventTable where inventTable.ItemId == salesLine.ItemId
{
salesTmp.clear();
salesTmp.SalesId = salesTable.SalesId;
salesTmp.CustAccount = salesTable.CustAccount;
salesTmp.CustName = custTable.name();
salesTmp.ItemId = salesLine.ItemId;
salesTmp.Name = inventTable.itemName();
salesTmp.Qty = salesLine.SalesQty;
salesTmp.LineAmount = salesLine.LineAmount;
salesTmp.insert();
}
}

}

[DataContract]
class SalesReportContract
{
TransDate fromDate, toDate;

[DataMember]
public TransDate parmFromDate(TransDate _fromDate = fromDate)
{
fromDate = _fromDate;
return fromDate;
}

[DataMember]
public TransDate parmToDate(TransDate _toDate = toDate)
{
toDate = _toDate;
return toDate;
}

}

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

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

Like (0)

Report
Copy link

Link copied!

You need to do some work on the bug isolation. Your code looks correct to me, but you still should verify that it inserts data to the table. Maybe you run it in a company with no orders.

Then check the other possible reason: the data is generated just fine but the problem is in the report design.

Was this reply helpful? Yes No
Suggested answer

udaY-ch 5,139 on at

Like (0)

Report
Copy link

Link copied!

Hi

These are the below steps i would do to validate the report data logic,

1. Set the table property to 'Regular' - Changing the table’s property to Regular to check if the data is being stored correctly.

2. Use hardcoded values for testing - Set hardcoded values both in the report design and during data insertion to verify that static values are printed correctly.

3. Recreate the report design (if needed) - If the data is stored properly, consider recreating the report design to rule out any issues related to the layout or binding

Thanks

Uday

Was this reply helpful? Yes No
Komi Siabi 13,130 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You have a contract class SalesReportContract and I can't see you using any of its parameters in processReport().

Was this reply helpful? Yes No

Join the conversation

Community site session details

No Data Showing in SSRS Report Using Temp Table in D365 F&O

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

No Data Showing in SSRS Report Using Temp Table in D365 F&O

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates