I edited the default shipping report layout extensivley several months ago. Now I am asked to add the width height and depth of each product to each line item in the report.  I looked at the original report and noticed that having this information attatched to each product was accomplished using a group and using the fields "prompt.productname (string)" and "@promptsvalue_multiformat (string)". I am not very versed in Crystal at all, and pretty much walking around in the dark while bumping into things and just trying to remember what & where they were.....so I just copied these fields from the default report and placed them in mine.....all that did was give me random prompt names and values.......so I right clicked on those fields in the default report and took a look at "select expert".....I noticed that the fields in the default report were linked to two other fields when viewed in that interface....I went back to my report and linked them the same (best I could).  I then changed the formula seen in the "select expert" to filter the prompt names to only "width" "height" and "depth".

This worked.........but now the problem is I only get the width and it's value to display.....no matter how many times I copy the fields, it won't move on to the next prompt such as "depth" etc. I guess somehow I need it to know what it has already told me and then move on to the next prompt. It does move on to the next product...so no problem there..

I took another look at the default report and noticed that that after the first two fields used for displaying a prompt and it's value, there are multiple copies of them...but they are somehow linked together and cannot be selected with the mouse.....I gotta feeling that's what I need to do but how??

Any help is appreciated, and if any additional information is required dont hesitate to ask for it.

Thanks

Dan,

I would also add some group bands to define the selection and use the group footer instead of the detail your objects. This will give you more control over what is displayed. The detail section will list every record for whatever it is grouped from. That is why you are getting three entries for each item. Scott is correct with the job summary report. It would be a great one for you to work off of. But, if you work with the group bands by starting with what your main group would be and then add bands to get a more precise grouping. These group bands are what builds the selection formula that the report uses to gather its data. So the more refined you can get it the better. But, defiantly try staying away from using the detail section and use the group footer instead. You'll find that you will use a lot fewer @*#&! words. You can also try tech support, Feng Yang seems to know his Crystal.

Thanks for everybody's feedback.

Dan, like everyone else mentioned. I would suggest you based on "Job Summary Report" to modify your report. The "Reset", "Accumulate", and "Display" are the functions that you need to pull the selected "Prompts" info. (Nice report, by the way.) It shouldn't take you long to redesign the report.

Give tech support a call if you still need some help. Or you can drop by at the trade show, I will be there...

Thanks.

Feng

As always.....messing with crystal is educational for me. Thanks a bunch for all the help while I'm on my learning path. I decided to copy and paste the fields "@width" "@height" "@depth" from the job summary report as you guys mentioned. (That way I wouldn't have to mess with any V.B. formulas) It gave me an error saying it couldn't find the field "accumulateWHD" when I tried to preview this new version of the report. So I copied and pasted that field as well (even though i didn't using on my report..the other fields needed to reference it). So everything is working now. I was spending time in the evenings learning visual studio 2008 to understand the V.B. language up untill a month ago when my daughter was born...maybe (i hope) sometime in the not too distant future I'll get a chance to continue and be able to dig deeper into some of these crystal formulas that are based on V.B...untill then I'll settle for this quick fix and poke at ya'll suggestions and try to learn more when I get a chance.

Thanks again,

Well from what I can see of your report, you're doing good so far. I've been doing this for 15 years and learning all the way by the seat of my pants and let me tell ya. I've got alot of pants that have the seat missing, just hang in there and keep at it.