Customer experience | Sales, Customer Insights,...

Custom Report on Custom Entity

(0) Share

Report

Posted on by Milad Eshraghi

Hi,

I want to build a report on my custom entity, to show some filed in my report.

I build a report in visual studio with this dataset:

SELECT Filterednew_inventorytransfer.new_inventorytransferId,
Filterednew_inventorytransfer.new_TransferTypename,
Filterednew_inventorytransfer.new_Product1,
Filterednew_inventorytransfer.new_Desc1,
FROM Filterednew_inventorytransfer
WHERE (Filterednew_inventorytransfer.new_inventorytransferId = @CRM_Filterednew_inventorytransfer)

it works in visual studio and ask to enter @CRM_Filterednew_inventorytransfer but in CRM it returns an error like this:

The report cannot be displayed. (rsProcessingAborted)

Could you please help me?

All responses (3)

Answers (0)

Suggested answer

sdfasdf 840 on at

Like (0)

Report

RE: Custom Report on Custom Entity

You have a custom parameter named "@CRM_Filterednew_inventorytransfer". In VS, you are most likely being prompted to enter a value to it, and you're probably assigning a GUID value to it, so when you run the report in VS it works. Now when you deploy this report to D365, this parameter will be automatically populated since it's a special parameter (its name begins with "@CRM_"), but the value D365 assigns to it is a FetchXML query, which renders an invalid value for your report.

I would strong recommend you to refer to the following articles:

Create a new report using SQL Server Data Tools

docs.microsoft.com/.../create-a-new-report-using-sql-server-data-tools

Improve report performance by using filters

docs.microsoft.com/.../improve-report-performance-by-using-filters

Hope it helps.
Milad Eshraghi 15 on at

Like (0)

Report

RE: Custom Report on Custom Entity

Thank you for your answer,

I did it and took some snapshots from my datasets and parameter. I can't understand what is wrong in this report.
Suggested answer

sdfasdf 840 on at

Like (0)

Report

RE: Custom Report on Custom Entity

Any parameters whose name begin with "@CRM_" are "special" ones. Hence you may want to change your data set to something like this:

SELECT Filterednew_inventorytransfer.new_inventorytransferId,

Filterednew_inventorytransfer.new_TransferTypename,

Filterednew_inventorytransfer.new_Product1,

Filterednew_inventorytransfer.new_Desc1,

FROM Filterednew_inventorytransfer

Additionally, if you need pre-filtering to be enabled, make sure the @CRM_Filterednew_inventorytransfer parameter is assigned a default value similar to: select * from Filterednew_inventorytransfer