Problem in Crystal Report

Posted on 2014-03-07
Last Modified: 2014-03-14
I want to design a crystal report as shown below

In which data is placed in detail section. So I am currently able to print all data from table as displayed above. The problem is with REMARKS column. I want to write some remarks but note that remarks doesn’t comes from database. And I need to merge all rows(variable no of rows) in remarks column and display a message there.
How can I do that in detail section of reports.
Question by:ronipats
  • 3
  • 2
  • 2
LVL 100

Expert Comment

ID: 39913837
Where do the remarks come from?


Author Comment

ID: 39914218
remarks text is a simple static text that i want to write in formula filed


formula name : @remarks
if <tablename.field name> = <some condition> then
     "All listed candidates are employees"
     "All listed condidates are Students"
LVL 34

Expert Comment

ID: 39914506
As I understand it, a single "remark" can apply to multiple detail records, and you want the field to extend down, through those records.

 But you're basing the value on a field, which could change with each record.  Could you have one record that's an "employee", then a record that's a "student", and then another record that's an "employee"?  If so, what do you do then, since you don't have multiple "student" records in the middle for the "remark"?

 Or do you have the records sorted/grouped, so that you get all of the "employees" and all of the "students" separate?

 If you're using a group to separate them, you could:
 Create a new group header section.
 Put your "remark" formula in that section.
 Check the "Can Grow" option in the field format, so the field will be extended as necessary.
 Right-click on the section label to the left of the new GH section, select Section Expert and check the "Underlay Following Sections" option.

 If you use the Underlay option, the new GH section, with your "remark" formula in it, will be "under" the detail sections, so they overlap, and your "remark" can extend through multiple detail sections.

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails


Author Comment

ID: 39916979
Hi james,
Record i will getting will be grouped. i.e. either i will get all employee record only or all student record only.
LVL 100

Expert Comment

ID: 39917435
Did you try putting the formula in the group header and underlaying the following sections?

LVL 34

Accepted Solution

James0628 earned 500 total points
ID: 39918282
mlmcc already asked, but did you try using the "Underlay" option like I described?  If you tried that and it didn't give you what you need what was wrong with it?


Author Closing Comment

ID: 39930910
thanks to all for providing solution.

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now