SSRS Report: How to hide a tablix in second page of the report.

(0) Share

Report

Posted on by Pradeep Itnal

3,248

I am modifying a SSRS report for purchase order confirmation report(purchPurchaseOrder), in my requirement i have to hide a tablix on the the second page of the report. Any pointers will be highly appreciated.

I am on AX2012 R3.

Regards

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

Do you want to hide entire tablix or part of tablix e.g. some rows and textboxes?

Was this reply helpful? Yes No
Pradeep Itnal 3,248 on at

Like (0)

Report

Entire tablix.

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

Like (0)

Report

Have you tried using expression to hide it

e.g.

=iif(Globals!PageNumber = 1,True, False)

if this does not works try by reversing order of true false

=iif(Globals!PageNumber = 1,False, True)

Was this reply helpful? Yes No
Pradeep Itnal 3,248 on at

Like (0)

Report

Globals!PageNumber does not work as Globals!PageNumber can be only used header and footer section. I hace tried this and got a compile error.

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

Like (0)

Report

I see, yeah. fishy one. I cannot think of any possibility for ax flavored ssrs reports.

Can you kindly post your thread on SSRS community, as they may present any idea.

Here we need to remember that if they provide you any option of using code script which is VB traditional code in SSRS, tell them we cannot use code blocks in AX Reports. AX 2012 allows to create code but that cannot be used.

I am afraid you may have to create report in normal SSRS which can be worst last option

Was this reply helpful? Yes No
Suggested answer

Mea_ 60,284 on at

Like (0)

Report

Hi Pradeep Itnal,

Due to this tread and my personal experience it is not possible social.msdn.microsoft.com/.../hiding-a-table-row-depending-on-page-number

Because there is no fixed "page" it depends on printer drivers and setup.

Was this reply helpful? Yes No
Suggested answer

Hajish 460 on at

Like (0)

Report

Go to Report Properties and add below code.

Public Shared Dim PageNo as Double

Public Function SetPageNo( Value as Double) As Decimal
PageNo = Value

return Value
End Function

Public Function GetPageNo( )

return PageNo
End Function

use this code in header page number expression Code.SetPageNo(Globals!OverallPageNumber) // this will return same result.

check the page number by using this code Code.GetPageNo() //use your logic here.

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

Like (1)

Report

Hi Hajish,

In AX 2012, custom code cannot be used. This has been depreciated since arrival of AX2012, back in November 2011. Though you would be able to enter/write custom code, but when you will call it compiler will give you error, on compilation and deployment of report

Was this reply helpful? Yes No
Hajish 460 on at

Like (0)

Report

Thanks Sohaib. :-)

Was this reply helpful? Yes No