topic Re: Help for Paginated report - Power bi report Builder in Report Server

Help for Paginated report - Power bi report Builder

tmshah61 — Tue, 15 Aug 2023 06:34:10 GMT

Hello all,

I have serval Tables in from same dataset. Different filters applied to tables. I have some tables has no values sometimes. report is running properly. When i am exporting no data table and next table is coming in same sheet in excel. i have tried to hide the tablix with

IIF ( Countrows ( "Field") < 1 , TRUE , FALSE)

but still result is same.

I have kept different sheet name for the each tablix.

Please tell me how i can extract each tablix on individual Sheets in excel .

Thank is advance.

Re: Help for Paginated report - Power bi report Builder

FFelix — Tue, 29 Aug 2023 11:17:40 GMT

I am quite a newcomer in the Power BI Reporting clan.

I have a similar problem, I wanted to hide a Tablix in case it contains no items as reslult of of paremeter selected in the reporting. Is there a way to have a formula to be used in the Visible property of the tablix?
Any help would be greately appreciated.

Thanks

Felix

Re: Help for Paginated report - Power bi report Builder

R1k91 — Tue, 29 Aug 2023 12:25:04 GMT

sure you can, just use the Expression builder in the Hidden property of that tablix. your expression must evaluated to true or false and can be built by parameters and/or datasets values.

Re: Help for Paginated report - Power bi report Builder

R1k91 — Tue, 29 Aug 2023 12:26:10 GMT

have you already tried?

Exporting SSRS reports to multiple worksheets in Excel (sqlshack.com)

Re: Help for Paginated report - Power bi report Builder

FFelix — Tue, 29 Aug 2023 15:36:49 GMT

Thank you, but this is exactly my problem: I am not able to find an expression that is able to tell me if there are no items in the Tablix that match a given parameter. Any suggestion? Something like CountRows that satisfies the condition of the item being equal to the value of the selected parameter?

Thanks again

Felix

Re: Help for Paginated report - Power bi report Builder

R1k91 — Tue, 29 Aug 2023 16:03:15 GMT

something like this?

=First(Fields!OneFieldOfYourDataset.Value, "DataSet1") IS NOTHING

If filtering the dataset you get no rows the first is nothing

Re: Help for Paginated report - Power bi report Builder

FFelix — Tue, 29 Aug 2023 16:27:54 GMT

Thanks very much, but it does not seem to work, as the

First(Fields!OneFieldOfYourDataset.Value, "DataSet1")

return the first item of the Field which is not filtered by the parameter. Therefore the Tablix is empty put the First(xxx) is nothing is False.

Thanks again

Felix

Re: Help for Paginated report - Power bi report Builder

FFelix — Thu, 31 Aug 2023 07:05:55 GMT

Hi, I have found a solution that works for me with this expression in the visibility of the Tablix:

=IsNothing(Fields!XXXX.Value)

🙂

Thanks foir the help!

Re: Help for Paginated report - Power bi report Builder

tmshah61 — Thu, 31 Aug 2023 09:16:21 GMT

=IIF(CountRows() < 1, True, False) in tablix visibilty working. now i am able to hide the Tablix.

Thank you all for the help