Creating Professional Reports using Crystal Report for Visual Studio.NET (Part 2): ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Creating Professional Reports using Crystal Report for Visual Studio.NET (Part 2)

page 7 of 8

by Eric Landes
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 41981/ 60

Article Contents:

Create a Formula

You must have noticed that the Publication Date and the Order Date displays the Date & Time currently and it needs to be formatted for date only. This can be achieved using a formula field.

Right click on the Formula Fields option under the Field Explorer window, and select New.

Give your formula a name and this opens up the Formula Editor window where you can type in the actual date conversion formula. Note that the image shows the code required to extract the date alone from the PublicationDate Field.

Now replace the original PublicationDate field on the report with this formula field.

Now view the report in a browser and you will notice that the report is getting real close to what we saw initially (at least functionality wise).

« (Page 6)

View Entire Article

(Page 8) »

User Comments

Title: Drill Down Groups Automatically
Name: Pattanaik
Date: 2006-02-13 8:35:11 AM
Comment:
I am working on windows application in VB.Net 2003. I am using crysatl reports. I am in a situation where I want to drill down the tree view in crystal report while loading the report.And the first item in the group should be selected by default.

Title: Good feedback
Name: Manish Joisar
Date: 2005-08-25 4:12:59 AM
Comment:
Good Article
I created GRAPH, it running perfectly on my local machine,
but when i deploy my all pages to our development server, Graph image is coming with Red Cross & when i am trying to find that image it is there in winnt/temp folder, it means Crystal report not able to copy image in the folder because of some rights problem, i don't know in which Folder, it is trying to copy that image

Can you help in this regard ?

Title: Crystal Report
Name: Pankaj
Date: 2005-06-16 4:52:01 AM
Comment:
Hi,

this is very nice article regarding the crystal report using vb.net. but i just want one more thing ...can u please provide me the code for asp script, how to call a crystal report from asp script? please mail me--- me_ur_lov@yahoo.com

Title: Alignment of data
Name: sushine
Date: 2005-02-19 11:38:30 AM
Comment:
Can someone help me?

I am trying to create a table of content that is horizontal. How can i go about doing it? each time the report get generated it will tabulate different number of columns. I have been trying for 1 week but failed to make the report auto create columns of data.

I would like to know how can i auto align my data?
As i look at most of the examples, data are all align in vertically.

Title: Mr
Name: Tony
Date: 2005-02-10 7:36:02 AM
Comment:
Without going through can't cpmment

Title: Creating Professional Reports using Crystal Report for Visual Studio.NET
Name: Raghu
Date: 2005-01-10 5:04:53 AM
Comment:
Sir!
this article was very good but, can i get any information regarding how to format a crystal report without using charts and aligning crystal report information, and also desining the reports with colorful

Product Spotlight