Display Dynamic Column in the report

Display Dynamic Column in the report

• Camille9805

  I think Cross Table may be a good Idea for dynamic Columns in Crystal Report.
  
  
  

• FranF

  Hi,
  I am designing a report where user can select the columns that they want to see. Based on user selection, I am setting the column's hidden (visibility) property to false. The report hides the data properly, but blank column (no header or data) appears at the end. If user selects8 columns out of max 10 columns, they blank column appear. I tried seeting column width to 0, still that blank column appears. How can i truely hide a column
  
  

• ThisPlay Systems

  You could easily set up a parameter for each column and then display that column conditionally based on the parameter.
  
  For instance, if you have a column that displays First Name, you could have a parameter called DisplayFirstName. Then in design view you'd select the whole FirstName column and in the Visibility-Hidden property set it to :
  
  =iif( Parameters!DisplayFirstName.Value = false, true, false )
  
  This could easily become a big, unwieldy report, though, if you have a great number of dynamic columns. Also, The width of the report is set at design time, and it includes the width of all your columns, not just the visible ones. This could cause you some pagination problems.
  
  Hope this helps.
  
  

• SecurityAdmin

  Hello Nilay,

  Hi..I am Murali..in my application i have to show columns same like this( as same as u r scenario) ..If u don't mine send me sample example for tihs.

  thanks and regards

  muraliMD

  
  
  

• Mani Swaminathan

  Having the same issue, and afaict you can't change a column width dynamically at runtime. It would sure be nice if someone came along and proved me wrong though.
  
  

• Alexander75

  Cant change the column width in runtime. But we can move the column by changing the Left and Top property of Field Object.
  
  

• Gino Rojas Tillemann

  Hi Murali / Nilay,
  
  Hope this link will explain you in setting Parameter value.
  
  http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx
  

• NeoDiO12639

  is it possible to change the page width of a report during runtime or before I run it from VB

  and is it possible to move columns by code during run-time

  I am thinking these are workarounds to the blank spaces when hiding columns

  
  

• Aquineas

  Thanks "Double americano",
  
  Really its work. Now i have another problem to displaying the all column to the end user. How to derrive the list of coulmns used in the Report.
  
  
  Once again thanks for help me,
  Nilay
  
  

• Snarfster

  How about if the report had grouping Will the grouping feature be affected since we're just hiding the columns
  
  
• Display Dynamic Column in the report