asked on

SQL or Crystal Reports Question

I am trying to create a report that displays results from an inspection record that is in a database. Currently there are approx. 2 dozen different "named attributes" but that list could increase slightly. I would like to be able to, I guess, save each of these named attributes as a new field so that I could use that field anywhere in a report. I want to be able to place the fields anywhere in the report instead of all in a row like it would display currently.

My first file shows a picture of what my report will currently display, in a column, for the various Measurements (attributes).

The second image shows a word document of an inspection report that I am trying to mimic. I need the various fields to populate in different places on the report, not in a row.

How should I proceed?
Mechanical-Sue.rpt

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sue Taylor

ASKER

Got it...... thanks!

Mike McCracken

If you need more help, just ask.

mlmcc

Sue Taylor

ASKER

I need more help, please. I guess I don't 'got it'.

I'm having issues with suppressing the blanks. It's showing spaces for blanks and I haven't figured out how to suppress them.

Also, There could be up to (4) individual inspections. Therefore, there could be up to (4) results for each inspection name (attribute). I want to group them and sort them. {view_PT_InspectionItem_Measurement.ID} will have a numeric value. It will be a sequential number and it just keeps going on and on in the database. So on this inspection report, the number may start with 18413 and for each of the 22 attributes it will go up by one. Then there will be another 22 if there is a second part inspected like there is in this case, etc. Basically, I believe if I sort everything by the ID, I will be ok.
Mechanical-Sue.rpt

Sue Taylor

ASKER

Mike McCracken

I think this does what you want.

I set the GF to suppress when blank.

I also modified the main formula to include the yield test and the display yield to only display for the yield group

mlmcc
Mechanical-Sue.rpt