Can I / How Do I get all this info on one report?

[neronikita]

Good morning!

I have the following tables (with fields shown):

DailyVehicleTracking
DailyVehicleTrackingID
VehcileNo
TrackingDate
Mileage
TimeStarted
TimeStopped
Addlcomments

PartsUsed
Partsrecid
dailyvehicletrackingid
partno
numpartsused
partsnotes

PartsList
part_no
manufacturer
description
core return
on_hand
Stock_qty
last_purchased_from
bin_number
Cost
Category

VehicleMaintenanceOperations
VehicleMaintenanceOperationsid
Dailyvehicletrackingid
workitemcompleted
completedby
complaintsymptom
code
comments

I have a report with a group by Vehicle Number then Daily Vehicle Tracking ID. (That group line has mileage, time, etc). In the details section I have the work completed information. I'd like to also include the parts with it, but there isn't one part for each work completed item, so I'm having trouble getting it to work. I've not done much with subreports, but I tried playing around with that and it didn't work either. It would be ideal if it listed all the work items completed in the first detail section, then listed all the parts used in the second detail section. Is that even possible? If so, how on earth do I get it to do that?

Please let me know if you have any questions or I haven't been clear in my description. I've been going in circles with this...

Thanks in advance,

Di

 

[fisheromacse]

you could use formula to combine the records and then display them in group footers.

you will need to adapt this to your specific needs, but here is a the basic info of how to do so:

http://www.tek-tips.com/viewthread.cfm?qid=1478748

lbass (TechnicalUser)
6 Jun 08 17:28
Insert a group on salesnum and then create three formulas:

//{@reset} for the group header:
whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar x := x + {table.SText}+" ";

//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar x;
trim(x);

Then suppress the group header and detail section.

-LB

 

[neronikita]

Thanks, I will try that.