Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Data doesn't start in first row. Post Reply Post New Topic
Author Message
Turion
Newbie
Newbie
Avatar

Joined: 17 Feb 2010
Online Status: Offline
Posts: 4
Quote Turion Replybullet Topic: Data doesn't start in first row.
     Posted: 17 Feb 2010 at 2:33am
HI
 
I have small problem with one report, I have four columns in total, two with descriptions and two with values. The first two start in first row but the other two start at rows below the first ones. I put them in the details section. I tried supressing but it didnt help. The report is for payslip data showing payments and deductions. I am not sure how to correct it. Please let me know if you need more details ? It looks like:
 
Pay-Slary 2550.00
                               Ded -Paye 361.70
 
Thanks
 
 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 17 Feb 2010 at 2:45pm
This would seem that you have 2 rows of data for each 'payslip record'.
Making it all appear on one row would depend if the above theory is accurate or not and if you ever have more that just these 2 rows or not.
Please give more info.
IP IP Logged
Turion
Newbie
Newbie
Avatar

Joined: 17 Feb 2010
Online Status: Offline
Posts: 4
Quote Turion Replybullet Posted: 18 Feb 2010 at 2:41am

If there is one row in the first column the right one start in the second, if there are 4 rows on the left the right one starts on the fifth. The right rows starts below the left.

There might be even 10 rows of data for eatch record.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Feb 2010 at 7:51am
So if you have multiple rows how do you want to display them and logically based only on data elements how would you determine that?
IP IP Logged
Turion
Newbie
Newbie
Avatar

Joined: 17 Feb 2010
Online Status: Offline
Posts: 4
Quote Turion Replybullet Posted: 19 Feb 2010 at 2:04am
I must admit I dont know how to sove this problem, I just thought that crystal is capable of showig data with multiple rows, starting each column in first row. Are you saying that it is not possible ? 
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Feb 2010 at 7:21am
In general crystal is a row based reporting tool so trying to turn your rows into columns is not its strength. Some variation of this can be done and there are a lot of posts about ways to do it. However, you have to think through your logical display of data for your set. Without understanding that you will likely just spin your wheels.
IP IP Logged
ananddevelop
Newbie
Newbie
Avatar

Joined: 19 Jun 2010
Location: India
Online Status: Offline
Posts: 2
Quote ananddevelop Replybullet Posted: 19 Jun 2010 at 12:25am
i need to generate payslip report for multiple employees

with multiple headers and muliple details


eg:

H1:Emp code Emp name
D1:101        Ramnan
H2:Increment pf esi
D2: 1500     200 300


etc..

could you be kindly help me to this one header one detail and then another header and another details..


IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 19 Jun 2010 at 12:57am
Hi,
 
This is what you do
 
*Create Main Employee Report
*Group By Employee Code Which will create Group Hear for Employee Code.
*The Create One Sub Report with the same Table In that Select EmpCode and EmpName
*Go To Mail Employee Report and Right Click GH1 and Select Insert Section Below which will create new GH1b  and GH1 will be GH1a .
*Insert the Sub Report Created for EmpCode and EmpName in GH1b then right Click the SubReport and Select Change SubReport Links.
*In Available Fields Select EmployeeCode and Move to Fields to Link so your main report data is linked to subreport and will display the data for that employee code.
 
*This resolves the first issue
H1:Emp code Emp name
D1:101        Ramnan
 
************************
*For remaining Data Display
*Create a formula to create Blank Group Header
*Formula Code:-
WhileReadingRecord;
""
*Now Create Group basedon this new formula
*This will create Group Header 2
*Now please follow the same steps we did to create Groups and Details for first issue
*Once done you will have report as you want
 
H1:Emp code Emp name
D1:101        Ramnan
H2:Increment pf esi
D2: 1500     200 300
 
*Now to display Every Pay Slip on Separate Page
*Go to Report Menu---Section Expert then Select GF EmpCode-A check the box New Page After
*Click X+2 formula button and Enter Not OnLast Record.
*This will display Each Pay Slip for each employee on separate page
 
let me know if you stuck hope that helps.....
 
I have created the test report  please email me rahulwalawalkar@yahoo.com for sample report as I don't know how to paste it here.
 
 
Cheers
Rahul


Edited by rahulwalawalkar - 19 Jun 2010 at 12:58am
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