Dynamics Hide Part of Report Request Page

AlexLim
AlexLim Member Posts: 16
edited 2017-03-30 in NAV Three Tier
Hi all,

I have tried search though online and forum but I can't find related post, maybe i using wrong keyword or something.

Anyway, back to the point.

Due to many reason, I have a report that need print from multiple source(record). For example, Item and Sales Header, and the request page will show 2 filter section, 1 for item and the other for Sales Header.

So my question is, can i hide the individual section based on condition?

For example, if I print from Item, it will only show Item filter section and vise versa.

focnbdpf43tm.jpg
2sftuz7aqkpe.jpg

I know the easiest way is split to multiple report, but again, due to many reason, specially maintenance of layout.

I did try set the sorting in DataItemTableView properties to hide the filter and set filter when print from item, to see I can "force" the filter come out or not. But no luck at the end, either hide or show the section only. :/

I can guess that this is not possible in Navision, however I hope I wrong.

Thank in advance. :)





Answers

  • Kishorm
    Kishorm Member Posts: 921
    You are correct in that what you are trying to achieve is not possible.
  • Albertvh
    Albertvh Member Posts: 516
    You could try putting the filters on the Request Page and take them off your dataitem. You can then show and hide them with a variable on the visible property.
    You could also create a function on the report itself and call that before running the report and then checking in the PreDataitem if the condition is met then break out of the dataitem.
  • AlexLim
    AlexLim Member Posts: 16
    You could try putting the filters on the Request Page and take them off your dataitem. You can then show and hide them with a variable on the visible property.

    This I had think before, however might not a good way as i cant keep add if user request to add new filter.

    You could also create a function on the report itself and call that before running the report and then checking in the PreDataitem if the condition is met then break out of the dataitem.

    I not quiet sure the meaning of " then break out of the dataitem.", can you explain further?

Categories