I am creating a report that has command buttons (i.e Save to PDF, Print, Email etc) on the report header section, but these buttons can only be viewed when the report is shown on Report View and not Print Preview.
However, on the same report, I have a couple of fields in the detail section that I want to hide, namely the quantity and unit price fields which should be hidden if the quantity is equal to 1.
Here is my problem. If I make the default be Report view, I see my buttons on the top but it does not hide my quantity and unit price fields. And, if I change the view to Print Preview, I can NOT see the buttons on the top but my quantity and unit price fields are now hidden.
Does anyone please have an idea how I can have both the buttons on top of my report as well as hide the fields in the detail section??