Wednesday, February 16, 2011

Crystal Reports in C#.NET


Java - To Check ArmString Number


class ArmString
{
    public static void main(String arg[])
    {
        int n;
        n = Integer.parseInt(arg[0]);
        int digit, sum, num;
        sum = 0;
        System.out.println();
        num = n;
        System.out.println("Number : " + n);
        while (n > 0)
        {
            digit = n % 10;
            sum = sum + (digit * digit * digit);
            n = n / 10;
        }
        System.out.println();
        System.out.println("Sum    : " + sum);
        if (sum == num)
        {
            System.out.println("Given number is an ArmStrong");
        }
        else
        {
            System.out.println();
            System.out.println("Given number is not an ArmStrong");

        }
    }
}

Crystal Reports in C#.NET - Display Join of Two Tables

One to Many relationship of  Tables ...


1. Add both the tables to DataSet being used.

 
2.Both tables must have Link between them, (e.g Primary Key of 1 Tables as Foreign Key of other)



How to Group the fields ??
-> 1.Right click in Details Section.
2. from the menu Select Report -> "Group Expert".
3. It will open the window "Group Expert" dialog box
4. In that select  those fields, that you want to group together. (as done in above fig.)
5.click on OK.
6. arrange the fields as you want.





Crystal Reports - for Bill Receipts

To display contents of two related tables,,

1. Create Crystal Report
2. Group the Contents (Fields of table) that u want to display once.
(as shown below)


How to Group the fields ??

-> 1.Right click in Details Section.
2. from the menu Select Report -> "Group Expert".
3. It will open the window "Group Expert" dialog box
4. In that select  those fields, that you want to group together. (as done in above fig.)
5.click on OK.
6. arrange the fields as you want.

Tuesday, February 15, 2011

Save Tigers, Save Our Heritage...


http://www.facebook.com/pages/Save-Tigers-Save-Our-HeritageJust-1411-left/277534109206

For hundred of years the tigers have been hunted for different pleasures, such as delightful coat that it offers. Earlier no one ever thought about the future of these beautiful animals. Hundreds and thousands of these animals have been killed by humans. Today authorities are struggling to see the increase in numbers before their extension. However the number is still declining, there are so many NGOs these days fighting for the tiger conservation. It is now important to save the tigers.