Joined: 01 Oct 2008
Location: United States
Online Status: Offline
Posts: 5
Topic: Adding Columns Bases on Database Records Posted: 01 Oct 2008 at 9:39am
I am pulling codes out of a Database with a number associated with them. The end user would like one line per employee, meaning if an employee has more then 1 code is it possible to add columns instead of Rows?
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 03 Oct 2008 at 10:19am
This is not going to be difficult. For each code you're going to create a formula that looks something like this:
{@Code1} StringVar code1; if PreviousIsNull({table.employee_ID}) or ({table.employee_ID} <> previous({table.employee_ID})) then code1 := 'No' //set the default value else if {table.code} = 'code1' then code1 := 'Yes'; //set the value if it exists for this employee code1
Create one of these for each code. Put these formulas in columns next to the user name on your report.
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
IP Logged
