Joined: 08 Jan 2007
Online Status: Offline
Posts: 1
Topic: Hiding columns in Crystal Reports 10 Posted: 08 Jan 2007 at 7:17pm
We dont want to show some columns on the report based on user input. We are doing this by suppressing the columns based on the condition, but it creates a blank column space on the report. How do I get rid of that blank space at run time ?
Even while exporting to Excel (in data only mode), it does not delete that blank column space.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 08 Jan 2007 at 8:14pm
You can't do it unless you have the developer edition. The best way to do this type of report is to build the report off a stored procedure or a DataSet object and then use aliases for each column name. That way you can dynamically build the list of columns you want to show and there won't be a gap between columns.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum