Crystal Report

I have created a sub-report successfully. But the data is getting repeated till it fits the whole page. How can it be avoided? Please do help me out.

Hi

You can set a property that suppress if duplicated true so that you can avoid the Duplicate Records
Sathish.K

Thanks for helping out. It works perfectly now.

I have another question. Can you please help me out. I want some data's to be displayed in Uppercase. Can this be achieved.

what ever columns you want convert in uppercase just create a formula column in that just return the value in uppercase ..

Alternatively when you sending a query to crystal report you can change to upper case for example if oracle is the backend means you can frame the query like this

Select upper(column name a), column name b from table name

Hope the above will help you

Regards

Sathish.K