Devendra Sharma Posted September 3, 2018 Share Posted September 3, 2018 Hi All,I have one senerio in cross tab where one row are created extra while no data available in row and column header.senerio is 2018-01-28 2018-04-28 2018-05-28 A 1 0 0 B 1 0 0 C 1 0 0 null 0 0 0out put I require like: 2018-01-28 2018-04-28 2018-05-28 A 1 0 0 B 1 0 0 C 1 0 0 Thanks Link to comment Share on other sites More sharing options...
riodavid Posted September 3, 2018 Share Posted September 3, 2018 Filter the null record out in your dataset query. Link to comment Share on other sites More sharing options...
Devendra Sharma Posted September 3, 2018 Author Share Posted September 3, 2018 I can't apply filter dataset query beacuse I need Date as a colunm while the Date not containing the cross tab data but that particular Date others data.If I filtered he null record in dataset then its was not printing the Date (those records are blank for particular Date).Example : Jan Date contain 3 data then it should print 3 row but April& May not contain specific data so its count is zero ,So I want to print April,may date but not extra row, it should print or adjust in 3 rows only. Thanks Link to comment Share on other sites More sharing options...
riodavid Posted September 4, 2018 Share Posted September 4, 2018 Do not filter on Date, filter on the "A,B,C" column. Link to comment Share on other sites More sharing options...
Devendra Sharma Posted September 4, 2018 Author Share Posted September 4, 2018 I had used $V{RowVarible}!=null in row header but not get that I want. Link to comment Share on other sites More sharing options...
riodavid Posted September 5, 2018 Share Posted September 5, 2018 Filter the null record out in your dataset query.Not the row header. Link to comment Share on other sites More sharing options...
balaji.sampathu Posted March 28, 2023 Share Posted March 28, 2023 I'm in the same situation right now, any luck with your request? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now