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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

Latest Posts