Personalization, Customization and Productivity Tools

[barthautala]

I have a report I want to use for determining inventory reorder types. I want to be able to see the report for only "make" or only "buy" if I choose to do so without have 2 different reports. Can I do this?

I also want to be able to sort the report based on vendor Alphabetically. Currently this report sort by part number least to most.

Please please forgive the stupid questions. Its been a long time since Ive done C programming. And have no formal Crystal training.

[Heather]

If this is a report you're writing in Cyrstal, then Yes & Yes.

You'll need to create a parameter field.  Then in the Select Expert (on the Report menu) set your procurement field to be equal to your paramater field.

You can set it up to sort by vendor in the Record Sort Expert (also on the Report menu).

[barthautala]

I cant get the Sorting to work. When I open the Record Sort Expert there is already a group in the sort fields box. This is greyed out and I cannot remove it. If I add in the parameter to sort by the vendor, nothing happens. Its like I never added in the sort function at all.

[Gator]

Groups take precedence on sorting.  This is why it is greyed out.  In this case, I would add another group for the vendor.  This new group would then have to be moved above the group that was already there.  I usually do this by dragging group #2 header above group #1 header.  This will switch the order they are in and hence the sorting.