none
Dynamic columns in crystal reports RRS feed

  • Question

  • Hi, i have some columns in my database like :id,bill,payed,date,period,...

    i want to filter columns in dialogue box before showing the report,mean i want to put checkboxes in in a windows before showing report so user can select which columns to show in report. for example if user check id and date checkboxes after he clicked print in report he must see 2 columns with id and date header. and i don't want long spaces between column so it must put columns in right places despite paper width.

    thanks.

    Saturday, October 13, 2012 12:21 PM

All replies

  • Dynamic clolumns can be done with report parameter. For example, you can create a reportparameter1, in the report, add a formula, if reportparameter is 0 return field1, otherwise field2. In this way you can do dynmanic column and grouping.

    The same trick can be applied to SSRS reporting too.

    Wednesday, October 17, 2012 10:32 PM
  • Hello,have you done with your dynamic report...I have similar requirement.

    If you have code then send me please.

    Thanks.

    Thursday, December 6, 2012 12:47 PM