Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Line Post Reply Post New Topic
Author Message
immad
Newbie
Newbie


Joined: 05 Jun 2013
Location: Pakistan
Online Status: Offline
Posts: 25
Quote immad Replybullet Topic: Line
     Posted: 19 Aug 2013 at 1:58am




i want to show data like this in crystal report

Name:--1---2--3--4--5--6--7--8--9--10--11--12--13--14--15
abc----A---P--A--A--P--P--P--P--A--P---A---P---A---A---P

but its look like this

name:--1--2--3
abd----A
-------P
-------A

please help me out
immad
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 19 Aug 2013 at 2:12am
Hi Immad,
 
To show the values in single line you need to follow below logic:
you have to create 3 formulas:

The first one, let's call it @null:

whileprintingrecords;
stringvar names := "";

Place it in your GH section, it will return you null.


The second one, let's say @comma_field:


whileprintingrecords;
stringvar names;
names := names & "---- " & {table.field};

Place it in your Detailes section which you can suppress; the formula will return you next


and the 3rd formula, let's call it @final :

whileprintingrecords;
stringvar names;
Mid(names, 3);

Place it in your GF or report section.

Check the below link for your reference:
 
--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
immad
Newbie
Newbie


Joined: 05 Jun 2013
Location: Pakistan
Online Status: Offline
Posts: 25
Quote immad Replybullet Posted: 19 Aug 2013 at 2:35am
.

Edited by immad - 19 Aug 2013 at 2:42am
immad
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 19 Aug 2013 at 2:42am

As per my understanding , you want to suppress the Checktime rows whenever attendance value is Null. If yes, then

Write click on the section > Select section expert and in the suppress formula editor write the condition as below
 
If IsNull(Attendance_Field) then true.
 
--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum