How to Diaplay Columns in Reports Even Dataset Is EMPTY SSRS Reports

Posted by Self-Innovator under Sql Server on 7/23/2014 | Points: 10 | Views : 3462 | Status : [Member] | Replies : 2
Hello,
I wanted to diaplay the columns fields in my report even if the Dataset is Empty...need to Display only the Column Names in Report in SSRS Reporting Services..
The below is the Expression i have triedbut not works


IIF(CountRows("DataSet1")=0,flase,true)


Anyone find the soln..

Join Hands Change lives
Thanks & Regards
Straight Edge Society



Responses

Posted by: Bandi on: 7/24/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
http://dba.stackexchange.com/questions/48101/how-to-keep-the-structure-of-the-tablix-when-there-is-no-data-to-show

Set the row visibility to Show or hide based on an expression. The expression would like like:

=iif(CountRows("DataSet1") > 0, true, false)



Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Self-Innovator, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 8/1/2014 [Member] [MVP] Platinum | Points: 25

Up
0
Down
click on Mark as Answer link if you resolved the issue with the above fix...

Post us back the solution/fix if you found any alternate....

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Self-Innovator, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response