You’re offline. This is a read only version of the page.
2
Hi ,
I have created a view and that view will contain the display Methods and some fields . And i have used that view in the query . And added the query to the report and tried to call the report directly using the menu item and tried using the controller class . Since the data is huge I am running the report using batch process . But getting the following Error while running the report in Batch .
Batch task failed . An error occured hen running report in batch . Please contact system adminstrator .
Previously I have faced the same issue for DataProvider class report but the following solution solved the issue
But In this report I am using the Query .
Hi Martin & Mohit ,
Thanks for the Reply , I was tring to duplicate the standard report (Open Purchase Order report).
Procurement and Sourcing > Purchase Order > Purchase Order Follow up > Open Purchase order report .
Since I need to add one additional field which is not available in the purchTable , I am using the display method . First I have tried to duplicate the report and added one extra display method but it didnt display the value in the report . And later I came to know through some of the articles/posts that custom display method wont diplay in the report untill we use view .
So I have created the view and added it to a query and then showed the required fields in the report but Due to session timeout we are trying to run the report in the batch processing but even in the Batch process it is getting failed after some time around 1 hour .
since that report required dynamic filter in the dialog form I am using the query method as similar to the standard report with slight changes.
My concern is why does it fail even in the batch processing since it is going to run in the background . whether is there is any session timeout even for batch processing ? Or should I have to change any property And I have made read user level access to the menu item too.
Hi, Is there any reason to have this report Query based. As you mentioned you have already resolved the issue for DataProvider class using that article.
If the problem is a timeout and you can't improve performance of your query, you can use the query in an RDP class and utilize pre-processing.
First of all, consider getting rid of display methods, because they can make a huge difference on performance if they make database queries.
For example, imagine a query fetching 10000 records. That's a single query, but if you have two display methods, each runnuing a single query, you suddenly make 20000 more queries than without display methods.
Hi,
Can someone please reply me on this Issue ?
When I try to create a Query report with the custom display method . I can unable to get the custom display method fields in the report , but for the standsrd display method I can get the values in the report .
So in order to get the values of the display method I have created a view for a table and added the view to the Query based on the following example
https://vishaldobariya.wordpress.com/2019/03/08/display-method-on-views-and-ssrs-reports-d365fo/
But the less data batch job works !! but when the data is more Batch job fails with the error.
#1
Abhilash Warrier
565
#2
Martin Dráb
536
Most Valuable Professional
#3
André Arnaud de Cal...
402
Super User 2025 Season 1
Share
Report
All responses (
Answers (
