Crystal Reports, Ver 8 - Subreports

[mama2bear]

Hi,

I have two separate reports from open job operations in our open workorders, one returns several fields among which are labor (L) lines, the workcenter, and the description of the workcenter. (1S12 is Shear, FP is Flat Plate, and FL is Flat Laser) I have another report that has all the same fields except that it returns material (M) lines, and the sheet metal PN, and the sheet metal description for that metal. The L lines and the M lines are in the same field, which can also contain O outside service and C comment lines.

I am trying to get the sheet metal PN and material description dropped in the detail section of the first report for the laser. Since I already had a report, I didn't use the wizard. It looked like it was going to work, because I got that matching line under my first report line in the details section. My problem was that the box that contained the data line of the subreport was huge. Even though the data line box had handles to shorten the height with the double headed vertical arrows, it would not change, and I could not find a way to make it narrow, so only about 4 matching data lines would appear on a page. Has anyone out there encountered this and solved the problem? If so, please share it with me.

My end goal is to get a report sorted by priority that shows labor lines due with associated hours, and sort the lines by sheet metal material part number and by due date within each material in order to schedule jobs at the laser. (Thanks for taking the time to read all this. I am new here, and fairly new to Crystal. I may have a go at this with Access to see how it handles multiple data types contained in one field.)

 

[halem2]

Sounds like it may be easier to create a new report and insert groups according to your needs then you can sort each group's content by the field you want.

Can you post the report without the data?

 

[mama2bear]

Thanks for your reply. I did keep working at it, and got it done. The sub-report was just not the way to go. I found a different data table that contained sheet metal PN's, and the job number and suffix, where our ERP software shows metal allocated to each job. When I linked that table with another one with job and suffix, I was able to pull in the needed material information without having to add a sub-report. Once I had that, all I needed to do was sort by the first 7 characters in each material PN as my group, and add a running total field to sum the hours upon the change in that group. The shop can now at a glance see how much they want to shear or nest within a given material thickness at each different workcenter.

I am just a beginner using Crystal, and this was a difficult report for me. Our ERP software support person gave me the formula for the 7 character group. I have a long way to go to learn what can be done with this program. It isn't often we need a new report, so I don't get much practice in using Crystal.

Thanks again,

Laverne