Is there a way to format the no rows message text so it will match the rest of the text on a report?

select a tablix and make sure your "Properties" pane is open. In the "Properties" pane, you can set the "NoRowsMessage" under the "No Rows" category. The "No Rows" category gives you the rest of the properties that you can set toi format the text; for example you can set the Font and Color.

was this ever accepted as the solution because in version 2008 I am unable to see any No Rows category in a tablix property. The only option available seem to be NoRowsMessage and this allows you to set a text message to display when ds returns no data.

Seunny you are looking in the correct place. Ralph was only referring to the Properties pane which is visible down the whole right-hand side of the design view (as long as you've checked its show/hide box in the View tab of the ribbon) he makes no mention of the Tablix Properties dialogue box. The issue I have is that though one can use the No Rows category to format the NoRowsMessage, this formatting is not carried over to the Print Layout view. Anyone have any suggestions as to how to fix this? [RB2 on SS2008] Thanks in advance.

This is very much possible . Insert an additional header row , Format your No Rows message and give an hidden expression for this row , inorder to show only when no: of rows returned is ZERO . Eg: Row visiblity expression for added row . =CountRows() > 1 OR =iif(CountRows("DatasetName")>0,True,False)Rajkumar Yelugu

And ..Please remove No Rows message for the Table and modify the report as described above , let me know if you are stuck some where .Rajkumar Yelugu

When we set NoRowsMessage property of tablix & it's getting display when you have no rows means your tablix does not have any rows that's why it appears on Top. Here are steps format NoRowMessage Select Tablix for which you want to set NoRowsMessage Set NoRowsMessage message for Selected Tablix Set FontFamily, FontSize, FontStyle, FontWeight & TextDecoration(optional) for selected tablix Set TextAlign = Center for selected tablix Set VerticleAlign = Middle for selected tablix Set Color = "your choice color" for selected tablix Thanks, Sandip Shinde Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi, I tried what Sandip suggested and it looks good in Preview and when exported to Word, but in Print Layout and exported to PDF, the font reverts back to the default of Arial 10pt. I normally wouldn't care, but when the user asks for a serif font and it reverts to a sans serif one, it stands out. I've looked through the .rdl files for both the parent report and the sub-report and tried to insert: <Style> <FontFamily>Courier New</FontFamily> </Style> ...everywhere I could find it made sense, still no luck. I also tried something else weird: Since so far all of my sub-reports have been inside tables in the parent report, I tried dragging the sub-report out of the table, checked the textbox that was created in the vacant cell, it had reverted to Arial (even though I thought I had set the default for the whole tablix to Courier New), so I set it to courier new, put the report back, same results. So I don't really know what's up, but in Print Layout and PDF, the NoRowMessage likes to revert to the default Arial font. Preview: Print Layout: Any suggestions?