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.  1.png My first file shows a picture of what my report will currently display, in a column, for the various Measurements (attributes).  
2.png 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
LVL 4
ITworksAsked:
Who is Participating?
 
mlmccCommented:
You are going to have to use a group and build the report itself in the group footer.

Details section will be

WhilePrintingRecords;
Global StringVar HeatNumber;
Global StringVar Inspector;
Global StringVar Sampler;
...

If {MeasurementField} = "Heat Number" then
    HeatNumber := {InspectionValueField}
Else if {MeasurementField} = "Inspector" then
   Inspector := {InspectionValueField}
Else if {MeasurementField} = "Sampler" then
    Sampler := {InspectionValueField}
...
Else
   "";
""

Open in new window


You can then create the report with the lines and everything in the group footer and use formulas like

Name - Display Heat Number
WhilePrintingRecords;
Global StringVar HeatNumber;
HeatNumber

Open in new window


You will have one test and variable for each value you need and one display formula for each value for the report

mlmcc
0
 
ITworksAuthor Commented:
Got it...... thanks!
0
 
mlmccCommented:
If you need more help, just ask.

mlmcc
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
ITworksAuthor Commented:
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
0
 
ITworksAuthor Commented:
.
0
 
mlmccCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.