PrintOnlyIfDetail and exporting to excel

poppins

Hi everyone,

I am trying to customize standard report 709 so that I can export it to excel.In the dataitem Item, PrintOnlyIfDetails is set to Yes, so if there is no data the preview of the report is empty...
but the excel file I am generating is printing data (name and description of the items)...
How can I make sure that if the report preview is empty(no data), the excel file is empty as well???

Thanks in advanvce

vremeni4

Hi,

If you PrintOnlyIfDetails is to Yes for dataitem "Item" this will affect the preview but not always the layout.
In other words you have to go to the report layout and make changes on the visibility of the tablix.
Tablix Properties -> Visibility -> "Show or Hide based on an expression"
Add a code, something like this

=IIF(Fields!DocumentNo_PurchaseLine.Value is nothing,true,false)
or
=(Fields!DocumentNo_PurchaseLine.Value="")

(I am not sure whether I got true and false in the right order in this example)

I hope this helps.