Last post Jul 25, 2012 05:15 AM by Anoop Shakthi
Member
91 Points
1205 Posts
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
40 Points
39 Posts
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
Member
91 Points
1205 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
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