Can I select specific columns to output in Crystal

[Nitesh]

Hi Guys,

How can I create a report to do the following in Crystal XI.

Say I want to select just the firstname,surname and date of birth for a class of pupils. The report must just include these 3 columns.

On another day I want to select all of the ablove plus the gender of each pupil. Now the report must show 4 columns.

How do I do it. I know how to do a report for a set amount of columns only. In other words, the columns must be dynamic

[Hack]

The easy way is to use two separate report files. One that has three columns and one that has four.

[Nitesh]

Hi Hack,

That method did cross my mind but I can't do that because I have alot of checkboxes that determines the criteria(columns) that will be displayed. The programer before me opened the list generated in Excel and then used a macro to draw lines to enclose all the data in a grid. The user feels that doing this and then running a macro is a lenghty process so I want to try Crystal.

[Hack]

Well, there probably are other ways to do it, but in my mind, this is the fastest and easiest.

[VBFnewcomer]

shakti5385 has a tutorial for dynamic column in her signature see if it serves your purpose the external link

[Nitesh]

thanks alot VBFNewcomer,

I will try it out. It's the best solution I've seen so far.

[VBFnewcomer]

Thank shakti not me....post back if your problem is solved