Friday, October 15, 2010

Adding a new column in Crystal Report: Crystal report with XSD files.

Hi I recently has a had time adding a new column in Crystal Report. I am blogging this in case I again forget or to help if you are stuck too.

To begin: This issue is specifically when Crystal report is tied to XSD file. The CR gets its schema from the XSD. The .NET code populates the XSD.
My environment is
Crystal Report Ver: XI R2
.NET 2.0. But i guess this should work with most of +/- versions.

1. Add column to SQL Proc.
2. Add column to XSD.

3. Add c# code to populate this new Column.
4. Rebuilt Solution.
5. Now comes the main thing, reflecting the new column into crystal report.
The scree shot below shows set by step solution:
This will bring the "Set Datasource Location dialog box.

Click on "Create Connection" > ADO.NET (XML). This will bring a new Dialog box.
Browse for the local  (not source safe) XSD file. This file should be a part of your .NET Solution.

Leave the "Class Name" and "Use Dataset from Class" blank. Click Finish.
Should have something like this.

Now select both the Tables (Child this begins with In.. in the above diagram). and click Update and Close.
In most of the case this will show the new field, try refreshing if this do not works.

Friday, October 8, 2010

Same thing different day

I think I have lived this day before also. 
Today my colleague left, today was his last day in the office. End of his project, the contract did not renewed. 

I felt it bad, so bad. When people meet and stay with you for sometime you develop so much intimacy with them. When they leave, they make a vacuum. So H left today. The same thing happened when 2 years back my roommate left Thiery. 

People meet and leave, that's why someone has compared our life with a train. The train in your life, you have many people coming and leaving your life. Some stay for some stations, some remain until the end. Life moves on. Nothing stops. As if the person was of no value.

But I tell you, the good part is life doesn't stops. It just moves on. And I am sure there is something better and surprising waiting for H. 6 months (or may be before) I will see him in a better place and position. And I WILL write about it. I am here watching. I don't know when I am moving.............

Gita sar 4th Para say that "परिवर्तन ही संसार का नियम है". and the book "Who moved my cheese" also says the same thing.

Remind me if I forget to write about H. Bye