Jump to content

Suppress a blank row in Cross tab


Devendra Sharma

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

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

  • 4 years later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...