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 0
out 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
5 Answers:
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
