If you are unable to create a new account, please email support@bspsoftware.com

 

grid line on excel when column is null and more row has more than 2 rows

Started by jammaster, 13 Nov 2019 03:53:12 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

jammaster

13 Nov 2019 03:53:12 PM
Hi,

Using Report studio 10.2.2 ...  grid line seems to only come out when exporting report to excel when there are 2 or more rows of data and if the column has null values.  Please see attached for example.  Is there way to get rid of the gridlines only for the ones that are null?  I have workaround where I put if column is null then ' ' else column.   This works but I have lot of columns and have calculation on some of them.   Thanks for help!

Thanks!
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite