PowerBuilder Forum

What is the most efficient way for the report to display data in the imitated Spreadsheet form.
Created a form with empty fields.
SELECT

flight_Data.aircraft_Oid,
'ac_id'= dbo.Udf_Get_aircraft_id_by_Oid(flight_data.aircraft_oid),

day_name_1' = upper(left(datename(weekday, dateadd(day, 1 - 1, :start_Date)), 3)),
'day_no_1' = datepart(day, dateadd(day, 1 - 1, :start_Date)),
'day_name_2' = upper(left(datename(weekday, dateadd(day, 2 - 1, :start_Date)), 3)),
'day_no_2' = datepart(day, dateadd(day, 2 - 1, :start_Date)),
'day_name_3' = upper(left(datename(weekday, dateadd(day, 3 - 1, :start_Date)), 3)),
'day_no_3' = datepart(day, dateadd(day, 3 - 1, :start_Date)),
'day_name_4' = upper(left(datename(weekday, dateadd(day, 4 - 1, :start_Date)), 3)),
'day_no_4' = datepart(day, dateadd(day, 4 - 1, :start_Date)),
'day_name_5' = upper(left(datename(weekday, dateadd(day, 5 - 1, :start_Date)), 3)),
'day_no_5' = datepart(day, dateadd(day, 5 - 1, :start_Date)),
'day_name_6' = upper(left(datename(weekday, dateadd(day, 6 - 1, :start_Date)), 3)),
'day_no_6' = datepart(day, dateadd(day, 6 - 1, :start_Date)),
'day_name_7' = upper(left(datename(weekday, dateadd(day, 7 - 1, :start_Date)), 3)),
'day_no_7' = datepart(day, dateadd(day, 7 - 1, :start_Date)),
'origin_1' = ' ',
'origin_2' = ' ',
'origin_3' = ' ',
'origin_4' = ' ',
'origin_5' = ' ',

'origin_6' = ' ',
'origin_7' = ' ',
'origin_8' = ' ',
'origin_9' = ' ',
'origin_10' = ' ',

'origin_11' = ' ',
'origin_12' = ' ',
'origin_13' = ' ',
'origin_14' = ' ',
'origin_15' = ' ',

'origin_16' = ' ',
'origin_17' = ' ',
'origin_18' = ' ',
'origin_19' = ' ',
'origin_20' = ' ',

'origin_21' = ' ',
'origin_22' = ' ',
'origin_23' = ' ',
'origin_24' = ' ',
'origin_25' = ' ',

'origin_26' = ' ',
'origin_27' = ' ',
'origin_28' = ' ',
'origin_29' = ' ',
'origin_30' = ' ',

'origin_31' = ' ',
'origin_32' = ' ',
'origin_33' = ' ',
'origin_34' = ' ',
'origin_35' = ' '
from flight_Data where
actual_time_out between :start_Date and dateadd(day, 7 - 1, :start_Date)

Form for a week, 5 records per day. Each record is a separate record in the table.
Can extract into Datastore for the same daterange, but after that not sure how to convert into linear.
Thanks for your help.

-- Edited by Lana at 16:57, 2008-12-31