Solved

Crystal Report Design Help

Posted on 2013-12-30
3
732 Views
Last Modified: 2013-12-31
Hello all,
Please find attached the crystal report.
is there any way I could show only one row for the admin time ie. 9am.5pm.9pm and show only one row if there are multiple rows for a Rono.
Thanks.
test.gif
0
Comment
Question by:Star79
3 Comments
 
LVL 18

Expert Comment

by:vasto
ID: 39746870
You can group by RoNo , concatenate the values for Admin time in a formula and show all data in the group footer replacing Admin time with the formula. You need to concatenate also the directions.

Another option is to handle all processing on the database side.
0
 

Author Comment

by:Star79
ID: 39746877
Please let me know how to create the concatenated formula for admin time
Thanks.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39747247
First add a group on the RoNo field

In the report header add a formula
WhilePrintingRecords;
Global StringVar strAdminInfo;
""

Open in new window


In the group header add a formula
WhilePrintingRecords;
Global StringVar strAdminInfo;
strAdminInfo := "";
""

Open in new window


In the detail section add a formula
WhilePrintingRecords;
Global StringVar strAdminInfo;
strAdminInfo := strAdminInfo  & {AdminTimeField} & "  " & {AdminNotes};
""

Open in new window


In the group footer add a formula

WhilePrintingRecords;
Global StringVar strAdminInfo;
strAdminInfo 

Open in new window



You may have to convert the AdminTime field to a string
Use ToText or CStr

ToText({AdminTimeField})

mlmcc
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

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…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

777 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