SSRS batch processing excel export data missing

(0) Share

Report

Posted on by Community Member

Hi,

Recently I customized the customer aging SSRS report to include custom buckets, payment term and responsible sales name.

When I run the report using print destination as "Screen" report displayed all data.

But when I run it as batch processing the exported excel file on AOS server displays zero values.

I refreshed report data source, redeployed the report, restarted reporting service and other SSRS troubleshooting tips available. But with no success.

Please advice.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Hassan_rulz 3,801 on at

Like (0)

Report
Copy link

Link copied!

Try restarting batch AOS and clear cache files.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

[quote user="Crispin John Augustine"]

Try also exporting to other Formats (PDF, XML..), and you might get some clue, if controls are getting overridden.. Likely that, it is due to some overlapping.

[/quote]

I checked both PDF and XML output. Empty columns.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Restarted batch AOS and also cleared AUC files and usage data but still showing zero values.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

In AX 2012 R1 CU7 there is not option to refresh report server. I restarted both AOS and SQL server but with not success.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Crispin ,

I removed grouping in report design also tried replacing with original report design but still aging balance values are not displayed.

I think this is not caching issue.

I am confused because the balance which is displayed in the first column is fetched from the same array.

I am troubleshooting what is the major difference running SSRS report with batch processing and without it . Without selecting batch processing check box report is working fine. It is also displaying cross company data.

Maybe something like prePromptModifyContract Method.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi ,

This is the code which adds balance amount in aging buckets in CustVendBalanceList > addTrans method.

The first column is added outside the loop. Hence it is displayed always.

I added hardcoded values in for loop and if section and it was displayed in the batch processing exported file.

So now I need to check values of numofAge ,_date,startDateArray,endDate Array,_amountCur.

Info is not working in batch processing, how can I display above values in batch processing log ?

Was this reply helpful? Yes No