Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

SSRS Report Visible and hide on the basis of the condition of available value in invent transfer line

Posted on by 15

I have to show/hide ssrs report in AX 2012. The condition is I have the menu item button which displays label values from the Transfer order. There are multiple lines for each transfer order. For eg. we take one transfer order with 4 lines and when we select the line we see the view details form of the field Pallet id. There is the field on WMSPallet form which is INDTareWeight. If INDTAREWEIGHT >0 for any line only that line value should come in report and remaining should not show. If 3rd line value displays tare weight value  > 0 than 1st and 3rd value should come in report. How to modify this condition in SSRS report?

Categories:
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: SSRS Report Visible and hide on the basis of the condition of available value in invent transfer line

    The solution depends on your report. For example, if you have a report that is based on a temp table, simply don't create temp table records for those lines where TareWeight is 0.

    If the report is based on a query, you have to modify the query in a way that it filters out such records.

  • ankitrsharma Profile Picture
    ankitrsharma 15 on at
    RE: SSRS Report Visible and hide on the basis of the condition of available value in invent transfer line

    Hi Nikolaos, Need to change the report contents based on the condition. If TareWeight is > 0 for suppose 1st and 3rd line the content of these two line comes in the report while 2nd and 4th remains hidden. kindly guide me for the same.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: SSRS Report Visible and hide on the basis of the condition of available value in invent transfer line

    What do you mean by "show/hide SSRS report" and "How to modify this condition in SSRS report"?

    Do you want to hide a button that launches the report? Or do you want to change the report contents based on the condition?

    If it's about showing/hiding the button, you already asked it one time, got an answer and marked the answer as verified: community.dynamics.com/.../disable-button-from-code

    If you have some open questions about it, please post it in the same discussion.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans