removing blank spaces in report RSS

• • Reply
  nicklibee

  Member

  87 Points

  1141 Posts

  removing blank spaces in report

  Jul 04, 2012 03:52 PM|nicklibee|LINK

  Dear all,
  
  I have the following table
  
  Table1
  
  id      empcat100     empcat200      empcat300         empcat400
  1             ab            null           null              null
  2            null           ba            null              null
  3            null           null           cb               null
  4            null           null           null             de
  5             ab1            null           null              null       
  6            null           ba1            null              null
  7            null           null           cb1              null
  8            null           null           null             de1
  
  I have created a crystal report using the above table and the report look like this
  
  id      empcat100     empcat200      empcat300         empcat400
  1             ab            
  2                       ba            
  3                                       cb               
  4                                                         de
  5             ab1                   
  6                        ba1          
  7                                       cb1            
  8                                                        de1   
  
  I want to remove all blank spaces and wanted the output as follows
  
  id      empcat100     empcat200      empcat300         empcat400
  1             ab           ba           cb                 de
  2             ab1          ba1          cb1                de1
   
  
  how can i achieve this?
  
  pls help me
  
  thanks
  ncik

• • Reply
  Anoop Shakth...

  Member

  40 Points

  39 Posts

  Re: removing blank spaces in report

  Jul 25, 2012 05:15 AM|Anoop Shakthi|LINK

  http://www.dbforums.com/microsoft-access/906748-removing-white-empty-space-access-report-when-no-data-present.html

  http://stackoverflow.com/questions/288628/remove-extra-white-space-from-first-page-of-sql-server-reporting-services-report

  http://www.access-programmers.co.uk/forums/showthread.php?t=24062