Struggling to find Field Data / PDF formatting issue
Posted: 18 Oct 2023, 11:09
Hi all,
I am new to Sage report designer but have been tasked with creating a report to display employee information such as salary, pay frequency, cost centre, department etc.
I have had a lot of success so far but I am struggling to find a Data Field to show yearly salary. Some staff are paid weekly and some are paid monthly, I can only seem to find the weekly/monthly wage. Ideally I would like a column to display the yearly salary (ie x 52 or x 12) without the need for formulas to be added in afterwards on Excel. Can anyone help me with this information?
I am also having a problem when printing to PDF - Each detail line is spaced out so far that it is exceeding 50 pages! Each page has 2 or 3 lines from the details section, with empty space between it. When exported to Excel there are no blank rows. I have added a screenshot of the PDF issue. If anyone could be of any help I would be extremely grateful.
Thanks
Sofaqin
I am new to Sage report designer but have been tasked with creating a report to display employee information such as salary, pay frequency, cost centre, department etc.
I have had a lot of success so far but I am struggling to find a Data Field to show yearly salary. Some staff are paid weekly and some are paid monthly, I can only seem to find the weekly/monthly wage. Ideally I would like a column to display the yearly salary (ie x 52 or x 12) without the need for formulas to be added in afterwards on Excel. Can anyone help me with this information?
I am also having a problem when printing to PDF - Each detail line is spaced out so far that it is exceeding 50 pages! Each page has 2 or 3 lines from the details section, with empty space between it. When exported to Excel there are no blank rows. I have added a screenshot of the PDF issue. If anyone could be of any help I would be extremely grateful.
Thanks
Sofaqin