Microsoft Dynamics AX (Archived)

Customized SSRS Report Page Number

(0) Share

Report

Posted on by binitshah

660

We have customized the customer account statement report and the report is generated for multiple customers.

We are facing an issue in the page number.

When we generate the customer account statement for multiple customers we do not get the page number customer wise. System is generating 1 single report and hence the page number is coming irrespective of the customer.

Can somebody help on this?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sohaib Cheema 49,593 User Group Leader on at

Like (1)

Report
Copy link

Link copied!
Hi,

This issue is due to unsupported XML Schema in VS2010, as compared with new versions of VS. After checking at underlying XML reporting RDL files, I came to know difference of one Tag which is not enabled in VS2010. If you go for VS2013, with any system like Demo AX2012R3-CU9, this is supported there. In VS 2010 it’s not supported.

I have also tried multiple attempts such as following, but all of those failed

Forcefully inserted this <ResetPageNumber> tag in XML of downloaded RDL.

Exported XPO of report and modified the xpo in Notepad to include this tag.

Report failed to deploy in both of above cases.

To see further why it is not supported, you may raise a support request with Microsoft. It seems that by design/choice it was not supported that time.

Note that I have also tried to use Code windows of reporting designer, which is obviously not supported with AX-SSRS report since arrival of AX 2012.

Following is the TAG which is not supported with VS2012, for AX-SSRS

.

Next screenshot is from VS2013.

Was this reply helpful? Yes No
Sohaib Cheema 49,593 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Well, at this moment I cannot think of any optimal way to achieve this.

I would try to look into this tonight, if there is any possibility to achieve this in AX.

Was this reply helpful? Yes No
binitshah 660 on at

Like (0)

Report
Copy link

Link copied!

How to resolve this Sohaib?

Was this reply helpful? Yes No
Sohaib Cheema 49,593 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Yes, you are correct in this regard.

Standard SSRS supports this. This seems disabled for AX-SSRS report.

Was this reply helpful? Yes No
binitshah 660 on at

Like (0)

Report
Copy link

Link copied!

Dear Sohaib,

We cannot find the properties for resetting the page number based on customer ID or any grouping in visual studio 10

Was this reply helpful? Yes No
Sohaib Cheema 49,593 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

An idea can be to reset page number, based on Customer Id. As you can group customer transactions based on customer Id.

SSRS provides option to reset page number with any grouping.

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi Binit Shah,

If it was ok before your customization and now is not, probably customization is a root cause, it's hard to advise you anything without seeing what you actually did.

Was this reply helpful? Yes No