Suppress a blank row in Cross tab

0

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

devd.danta's picture
Joined: May 28 2015 - 1:08am
Last seen: 3 months 10 hours ago

5 Answers:

0

Filter the null record out in your dataset query.

riodavid's picture
502
Joined: Oct 27 2016 - 1:57am
Last seen: 5 months 2 weeks ago
0

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

 

devd.danta's picture
Joined: May 28 2015 - 1:08am
Last seen: 3 months 10 hours ago
0

Do not filter on Date, filter on the "A,B,C" column.

riodavid's picture
502
Joined: Oct 27 2016 - 1:57am
Last seen: 5 months 2 weeks ago
0

I had used $V{RowVarible}!=null in row header but not get that I want.

devd.danta's picture
Joined: May 28 2015 - 1:08am
Last seen: 3 months 10 hours ago
0

Filter the null record out in your dataset query.

Not the row header.

riodavid's picture
502
Joined: Oct 27 2016 - 1:57am
Last seen: 5 months 2 weeks ago
Feedback
randomness