We have often used the crystal report as a reporting tool to create various reports.
We some time need our group header to display in each and every page. In crystal
reports right click crystal report-> select group expert and then select the group
you want to display in each page. and goto the options and check the the
checkbox >Repeat group header in each page.

That's it.. Your group header will display on the top of each page.

While generating reports we are offten need to display data in multiple columns in cyrstal reports or any other report generation tool.

Crystal Report provides very easy way to do it. Please follow the following steps to complete things.

1) Open crystal report
2) Go to the section exprert and then select details section
3) Select 'Format with multiple columns' checkbox.
4) A layout tab appears in the section expert. From where you can design layout that how the multiple columns display in the crystal report.

That's it... You have created reports with multiple columns. You can also format crystal report groups with it.

Happy Programming.

In the crystal report You can also set the color of database field the dynamically. For that you
have to right click the field and select the format object then go to the font and color tab. Click the formula icon opposite to color and a formula editor opens. Put your formula whatever you want to implement and you set your color based on this formula.

Happy Programming..

Some times we need only a single field from a
particular table while creating a report.
Which sometimes has no relationship with others.
To do this So many peoples are importing table
and use a one field.

Crystal Reports 9.0 onwards give us a facility
called command which return the fields as you
have specified in the command query.

To do this go to the database expert and select
add command this will open a query window
there and put the simple query and it will
return fields you have specified in the
query analyzer.

It's very simple.Happy Programming....