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

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

page 2 of 5

by Eric Landes
Feedback

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

Article Contents:

Create and Modify Formula

1. Create a new formula field as explained in the previous part, and type in the below shown code into the Formula Editor window (Note that we are using Crystal Syntax here to assign a value 1 to the variable RH).

2. Drag and drop the formula on to the Report Header section

3. Hide the formula field so that it doesn’t appear on the report. This can be achieved by right-clicking on the formula field (on the report), select Format, select the Common tab, and check the option Suppress.

4. Right click on the Group 1 Footer panel, select Format Section. This should bring up the Section Expert window.

5. Click on the x-2 symbol, next to the Suppress (No Drill Down) checkbox and type in the code shown below into the formula editor window. Here, we check for the value of the variable to decide if the details should be displayed or not.

Note that you will have to repeat the above steps (with a different variable) to make sure that the Footer 2 (Book Details) does not get displayed while viewing the Order details.

« (Page 1)

View Entire Article

(Page 3) »

User Comments

Title: Crystal Report
Name: Sharad Kumar Agarwal
Date: 2006-02-17 2:27:25 AM
Comment:
Hi ,
This is sharad here , i have doubt about the functionality of the linking in crystal report at run time.Currently i am using Crystal Report XI.
Suppose i am using two tables A and B and there is no linking between these two but have one column same in both the table .I put one -2 column from both the table in the report and i want to know the functionality how this two columns linked with each other at run time.

Waiting for reply.
Thanks
Sharad Kumar Agarwal

Title: Improving Report Presentation and Additional Formatting
Name: Alexander
Date: 2005-09-22 7:38:32 PM
Comment:
Excelentes tips, me ayudaron mucho

Title: Crystal report dynamic formating in VS2005
Name: Pooja
Date: 2005-08-31 5:34:47 AM
Comment:
Hello,

I have visited your site and it helps lot.But i need dynamic formating in crystal report.I mean to say instead of giving a static font size or color to the field in the crystal report, the field changes as per the user requirement.for example there are two tables in one table there is name and address field and in other table there is font size and color.The report display the name and address in the format given in the second table.
Please tell me steps need to perform the above request

Regards
Pooja

Title: addn formating
Name: kiran (IS)
Date: 2005-04-05 7:28:20 PM
Comment:
this is very good tip which helped me a lot

Title: crystal report
Name: Rinkesh patel (gop_vvn2585@yahoo,com)
Date: 2005-03-03 12:03:33 AM
Comment:
hi,developer
i developed one project on saradar patel university
i need to developed report with the parameterised in which i give input as year=2003,month=april,course_id=BCA and yeraor sem=1or2or 3 then collegename is PCI,after giving this input
the report will be generate i try well but this type of report not generate,it is available in vb 6.0 in datareport
i developed in asp.net.
so,u give me code for that.

i thank full u,
your sincearly
rinkesh patel

Title: CYRSTAL REPORT
Name: KUNALSINGH(kunal.singh@india.birlasoft.com)
Date: 2004-09-30 9:29:33 AM
Comment:
HI,
i VIST THE ABOVE SITE AND FOUND SO MANY GOOD THINGS THAT WILL HELP ME WHEN I WILL GO FOR COMPLEX REPORT DESIGN. bUT BEFORE THAT I NEED ONE HELP FROM U THAT I KW ONLY BASIC REPORT GENERATION . LIKE AFTER CONNECTION FETCH THE DATA FROM ONE SINGLE TABLE.THAT IS ASP.NET. i WANT TO LEARN MORE STEP BY STEP . IF U HV ANY URL THAT HELP ME SETP STEP METHOD THEN IT WILL BE A G8 HELP FOR ME. i FOUND SO MANY GOOD THING IN UR SITE BUT I NEED FEW CODING STUFF THAT IT WILL HELP IN DEVELOPEMENT POINT OF VIEW.
REGARDS,
KUNAL SINGH

Product Spotlight