I'm stumped on creating a report and wondered if anyone could help.
How can I get a report to always print the group header-- even when there's no detail under that group header? Is it possible?
I have a table that contains the hours of the day broken into every half hour. The field is: display_time. I have another table that contains appointments with a field called: sch_time. These tables are linked in a set that looks like this:
Parent-Actual_Time (display_time)
|
L __Child- Appointments (sch_time)
I'd like to create a report to print daily appointments like the example below. It would make it easier to see when the appointments are really scheduled:
I can get a report like this:
but this report has no filter on it. It's showing all the records of the appointment database, and groups them under the display_time field.
What I want to show is just the appointments of user entered date.
So, I have alpha5 ask for a date(Var->askD_Print_Date), and then I run a filter on it. This filter-- Sch_Date=Var->askD_Print_Date
That selects only the records in the child database that match the user selected date.
When I do this, it filters it on the detail section, and I lose my group headers that don't have matching detail data.
My report now looks like this:
I've lost all my headers!
Any ideas would be appreciated.
Thanks,
Brad
P.S. Maybe the whole approach I'm taking is wrong, and this report can be created a better way. I thought of using variables instead of this table, and running a report using an array of variables. I even created a script that creates an array of variables with the thought of using them to get my header data. My problem is I don't even know how to get tables to print in a report the way I want, let alone an array of variables. Here's the code of that script if it sparks any ideas in anyone's head:
h_time[11] = on the hour (ex. 12:00 PM)
hq_time[11] = on the quarter hour (ex. 12:15 PM)
hh_time[11] = on the half hour (ex. 12:30 PM)
ht_time[11] = on the three/quarter hour (ex. 12:45 PM)
How can I get a report to always print the group header-- even when there's no detail under that group header? Is it possible?
I have a table that contains the hours of the day broken into every half hour. The field is: display_time. I have another table that contains appointments with a field called: sch_time. These tables are linked in a set that looks like this:
Parent-Actual_Time (display_time)
|
L __Child- Appointments (sch_time)
I'd like to create a report to print daily appointments like the example below. It would make it easier to see when the appointments are really scheduled:
Code:
<06:00 am 06:00 am 06:30 am 00236 Appointment Installation 00424 Project Installation 07:00 am 00024 Appointment Repair 00029 Project Installation . . .
Code:
. . . 05:00 am 05:30 am 06:00 am 06:30 am 00236 Appointment Installation 00424 Project Installation 00426 Appointment Installation 07:00 am 00024 Appointment Repair 00029 Project Installation 00046 Project Installation . . .
What I want to show is just the appointments of user entered date.
So, I have alpha5 ask for a date(Var->askD_Print_Date), and then I run a filter on it. This filter-- Sch_Date=Var->askD_Print_Date
That selects only the records in the child database that match the user selected date.
When I do this, it filters it on the detail section, and I lose my group headers that don't have matching detail data.
My report now looks like this:
Code:
11:00 am 00602 Appointment Repair Other 12:00 pm 00646 Appointment Repair Stop-n-waste 00646 Appointment Repair Stop-n-waste 02:00 pm 00626 Appointment Repair Other 03:00 pm 00613 Appointment Repair Head
Any ideas would be appreciated.
Thanks,
Brad
P.S. Maybe the whole approach I'm taking is wrong, and this report can be created a better way. I thought of using variables instead of this table, and running a report using an array of variables. I even created a script that creates an array of variables with the thought of using them to get my header data. My problem is I don't even know how to get tables to print in a report the way I want, let alone an array of variables. Here's the code of that script if it sparks any ideas in anyone's head:
Code:
dim h_time[24] as c dim hq_time[24] as c dim hh_time[24] as c dim ht_time[24] as c for i = 1 to 24 h_time[i] = 0 ;hq_time[i] = 0 ;hh_time[i] = 0 ;ht_time[i] = 0 h_time[i] = i - 1 ;hq_time[i] = i - .75 ;hh_time[i] = i - .5 ;ht_time[i] = i - .25 h_time[i] = totime(val(h_time[i])*3600, 11, 0) hq_time[i] = totime(val(hq_time[i])*3600, 11, 0) hh_time[i] = totime(val(hh_time[i])*3600, 11, 0) ht_time[i] = totime(val(ht_time[i])*3600, 11, 0) next
hq_time[11] = on the quarter hour (ex. 12:15 PM)
hh_time[11] = on the half hour (ex. 12:30 PM)
ht_time[11] = on the three/quarter hour (ex. 12:45 PM)
Comment