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

All responses (7)

Answers (0)

Sohaib Cheema 46,610 User Group Leader on at

Like (1)

Report
RE: Customized SSRS Report Page Number

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.
Sohaib Cheema 46,610 User Group Leader on at

Like (0)

Report

RE: Customized SSRS Report Page Number

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.
binitshah 660 on at

Like (0)

Report

RE: Customized SSRS Report Page Number

How to resolve this Sohaib?
Sohaib Cheema 46,610 User Group Leader on at

Like (0)

Report

RE: Customized SSRS Report Page Number

Yes, you are correct in this regard.

Standard SSRS supports this. This seems disabled for AX-SSRS report.
binitshah 660 on at

Like (0)

Report

RE: Customized SSRS Report Page Number

Dear Sohaib,

We cannot find the properties for resetting the page number based on customer ID or any grouping in visual studio 10
Sohaib Cheema 46,610 User Group Leader on at

Like (0)

Report

RE: Customized SSRS Report Page Number

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.
Mea_ 60,278 on at

Like (0)

Report

RE: Customized SSRS Report Page Number

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.