Creating Professional Reports using Crystal Report for Visual Studio.NET (Part 3)
page 4 of 5
by Eric Landes
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 26885/ 46

Additional Formatting

You could also include some additional formatting like marking the quantity red when it is below a certain value and marking it green when it is above a certain value. This can be achieved by right clicking of the Quantity field on the report, selecting Format, selecting the Font tab, clicking on the x-2 symbol next to Color, and specifying a condition like :

If {Sales.Qty} > 50 Then
   crGreen
Else If {Sales.Qty} < 50 Then
   crRed
Else

   crBlack

Different reports would have different requirements. Reports without any Groups or with just one Group could be much simpler. As the number of Groups increase, the report creation could get more complicated. The important thing to remember here is that using a combination of the Header and Footer, Formulas and Conditional Formatting will give you total control over designing the report to your specific requirement.


View Entire Article

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
Product Spotlight 



Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-04-20 7:43:05 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search