?
Solved

Problem in Crystal Report

Posted on 2014-03-07
9
Medium Priority
?
608 Views
Last Modified: 2014-03-14
Sir,
Hello
I want to design a crystal report as shown below

query
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.
1.jpg
0
Comment
Question by:ronipats
  • 3
  • 2
  • 2
7 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39913837
Where do the remarks come from?

mlmcc
0
 

Author Comment

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

eg.:

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

Expert Comment

by:James0628
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.

 James
0
Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

 

Author Comment

by:ronipats
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.
0
 
LVL 101

Expert Comment

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

mlmcc
0
 
LVL 35

Accepted Solution

by:
James0628 earned 2000 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?

 James
0
 

Author Closing Comment

by:ronipats
ID: 39930910
thanks to all for providing solution.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Screencast - Getting to Know the Pipeline
Suggested Courses

850 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