Can I select specific columns to output in Crystal
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
Re: Can I select specific columns to output in Crystal
The easy way is to use two separate report files. One that has three columns and one that has four.
Re: Can I select specific columns to output in Crystal
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.
Re: Can I select specific columns to output in Crystal
Well, there probably are other ways to do it, but in my mind, this is the fastest and easiest.
Re: Can I select specific columns to output in Crystal
shakti5385 has a tutorial for dynamic column in her signature see if it serves your purpose the external link
Re: Can I select specific columns to output in Crystal
thanks alot VBFNewcomer,
I will try it out. It's the best solution I've seen so far.:thumb:
Re: Can I select specific columns to output in Crystal
Thank shakti not me....post back if your problem is solved