Forum Discussion
Hide report Structure
Hi All,
I have tabular report, if i have the data(rows) in the report it will display, if it has 0 rows it will display the message (No Records). but still report structure is present.
My question - i have a requirement, my user dont want to see the structrure also if there is No data( 0 rows) in the reports.
Is it pos
You are going to have to adapt this solution to your particular situation, but here is one way.
Create a measure to use as conditional formatting along the lines of:Show or Hide = VAR ReportBackroundColour = "White" //If your report page has a specific colour, use the Hex code instead of "White" RETURN IF ( ISFILTERED ( FTable[Arrival] ), //Here use whatever criteria/measure result you wish to hide the visual for "#FFFFFF00", //This is the Hex code for transparent ReportBackroundColour )Next create a new rectangular shape shape from the ribbon under "Insert". Resize the shape to make it large enough to cover the visual you need hiding.
Select the visual and turn off all the options under "Style" in the formatting Pane. Go to general and under "Effects", select Backround, go to the conditional formatting for the colour, select "Field Value" and select the [Show or Hide] Measure.
For both visuals (original and rectangle), make sure that "Maintain layer order" under General/Properties is set to on
Drag the rectangle shape to cover the visual and you will get:
6 Replies
Please provide actual sample data (non-confidential) and a depiction of what you are trying to achieve
Hi, here is sample data,
I have a report like below, when i have the data(rows) in the report.
No Status Destination Arrival Reason 123 Delay ABC XYZ Staff issue 456 Delay BCD ZXY Staff issue But when i dont have the data(Rows) in the report, it will display like below.
No Status Destination Arrival Reason But my requirement is when there is no data(rows), it should not display report Strucutre (Columns headers).
Thanks,
Smartnag
And when will there be no data?
IF the delay code is grater than or equl to 1 then the rows will be populated, if not rows wont be populated.
You are going to have to adapt this solution to your particular situation, but here is one way.
Create a measure to use as conditional formatting along the lines of:Show or Hide = VAR ReportBackroundColour = "White" //If your report page has a specific colour, use the Hex code instead of "White" RETURN IF ( ISFILTERED ( FTable[Arrival] ), //Here use whatever criteria/measure result you wish to hide the visual for "#FFFFFF00", //This is the Hex code for transparent ReportBackroundColour )Next create a new rectangular shape shape from the ribbon under "Insert". Resize the shape to make it large enough to cover the visual you need hiding.
Select the visual and turn off all the options under "Style" in the formatting Pane. Go to general and under "Effects", select Backround, go to the conditional formatting for the colour, select "Field Value" and select the [Show or Hide] Measure.
For both visuals (original and rectangle), make sure that "Maintain layer order" under General/Properties is set to on
Drag the rectangle shape to cover the visual and you will get:
Hi Smartnag ,
Whether the advice given by PaulDBrown has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry
